Covers the world of Teradata Tools & Utilities. This includes topics such as SQL Assistant, BTEQ, TPump, FastLoad, TPT, etc. For articles, blogs and more, see the Tools section of the site.
You must login to post to the forums.
Teradata PT 12.0 error output schema does not match
Topic by paulcy
31 Aug 2008
Objective: Export a large amount of data to a pipe delimited file.Error: Output Schema does not match data from SELECT statementWhat I am doing:I am using the TPT wizard to create and run the job. As I go through the steps in TPT, when I get to the part of selecting what columns I want, I click the 'select all' option. The format of the columns that I am selecting ranges from char to int to decimal. After selecting all, I then proceed to change the type to varchar. I am changing the type because I read in the manual that if you are exporting to a delimited file, all columns need to be changed to varchars. The problem is when I run the job, anything that wasn't already a varchar causes the above error if it is selected. I am assuming I am doing something wrong in the TPT script but I figured I would ask.
|
17601 views
|
20 replies,
5 months ago
|
Teradata Parallel Transporter Wizard 13.10 Issues
Topic by mm185159
27 Apr 2011
tpt wizard, teradata parallel transporter wizard 13.10
When using TPT Wizard 13.10 I am not able to save a job. When I get to the Finish and Submit dialog screen, I click on "Finish" and nothing happens. Then I click on Cancel and a dialog box asks me if I want to cancel with unsaved job?.
Has anyone run into this issue and how can it be fixed?
|
6241 views
|
12 replies,
1 month ago
|
Unable to open Teradata SQL assistant
Topic by lellukka
22 hours ago
teradata sql assistant
Hi All,
I am having issues opening the Teradata SQL assistant.
Error message: An error has occourred. See the log file /User/USERNAME/Documents/SQLA/.metadata/.log.
It used to work before and it actually works on another machine (including virtual machine...)
Version: Eclipse 3.5 for Mac OS X, Copyright IBM Corp. and others 2002, 2008. All rights reserved.
|
2 views
|
0 replies
|
Mload and Fload Errlimit
Topic by teradatauser2
1 day ago
Hi
If i have a Mload and Fload job wherein i have not set the Errlimit to any value , what is the default value that Teradata takes ?
If you have a link to Mload/Fload manual that also has some text on this, then pls share
Thx
|
21 views
|
1 reply,
1 day ago
|
SQL Assistant 14.01 download availability?
Topic by srjilek
08 Jun 2012
sql assistant 14
Where should I go to download SQL Assistant v14 which was released in March?
http://developer.teradata.com/tools/articles/whats-new-in-teradata-sql-assistant-14-01
The TTU windows install is only version 13.10.0.2, but I'm already using 13.10.0.5. I don't see any other direct options in the downloads section for SQL Assistant.
|
5585 views
|
8 replies,
7 months ago
|
SQL assistant vs BTEQ
Topic by TdMan
29 Aug 2007
Can anyone tell me the difference btw running a query or set of query in sql assistant and BTEQ?
|
100698 views
|
21 replies,
1 week ago
|
Find record position for Fastload
Topic by m_v_anita
3 days ago
Incase of fastload error I am facing difficulty in getting exact line number (record number) in a large file of more than 1 million records .
The ERR1 table is showing the column name only , i am not able to locate the record causing the problem
ErrorCode ErrorFieldName DataParcel
|
14 views
|
0 replies
|
TPT: Moving tables from One TD box to other TD box using TPT
Topic by sahilchaudhry08
4 days ago
Hi I am new to thi forum . I am in urgent need to know. I have 2 teradata boxes example 6700 and 1690 whether I can write a TPT script to transfer whole table with data from 6700 TD box to 1690 TD box. Please help.
|
3 views
|
0 replies
|
Statistics collection
Topic by Fractals
5 days ago
statistics collection, statistics, performance
I have few doubts regarding statistics collection.
1. Does the order of columns used in collect stats command important?
2. Consider the following scenario
Table A joins with Table B based on Col1 and Col2 and Table A joins with Table C based on Col1, Col2 and Col3.
|
3 views
|
0 replies
|
Hadoop to Teradata
Topic by neubee1453@gmail.com
01 Mar 2012
fastload, hadoop
I have a ~250 node hadoop cluster containing a large data set that I want to move to Teradata as quickly as possible. The target Teradata system has ~100 (recent generation) nodes.
|
3911 views
|
5 replies,
7 months ago
|
SQL_ASSISTANT "Error executing query for record 1: 22001: Character string truncated"
Topic by jlwan98@hotmail.com
1 week ago
hI,
I encounter a error when i use SQL Assistant 14.0 to load a.txt to database,the error imformation is:"Error executing query for record 1: 22001: Character string truncated"
the content of a.txt is
"aaaa" : "中国"
"bbbb" : "英国"
my os's code page is (ansi 936)/(gb2312)
can any one solve this error,thank you in advance!
|
3 views
|
0 replies
|
TPT: system variables with result count
Topic by SebastianE
16 Jul 2012
tpt, parallel transporter
Hi everybody,
In the current implementation of our load scripts with multiload and tpump we are using the system variables holding the result count(&sysinscnt, &sysupdcnt, &sysetcnt, &sysuvcnt) for logging and further processing.
|
1420 views
|
4 replies,
6 days ago
|
FastLoad Error: FDL4830 CHAR/BYTE Type - record too short
Topic by bmkumar
08 May 2007
Hi All,I’m facing a problem to invoke the fastload script. The script is :DATEFORM ANSIDATE;.LOGON dwtest/informatica,inf_test;.ROUTE MESSAGES WITH ECHO TO FILE /users/mis/narahar/fl_informatica.out.ldrlog;database infmat;DROP TABLE infmat.adt;DROP TABLE infmat.et1_fl_audit;DROP TABLE infmat.et2_fl_audit;CREATE SET TABLE infmat.AUDIT ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,CHECKSUM = DEFAULT( PROCESS_END_DT_TM TIMESTAMP(0) FORMAT 'yyyy-mm-ddbhh:mi:ss', AUDIT_SID INTEGER NOT NULL, PROCESS_ID INTEGER, PROCESS_BEGIN_DT_TM TIMESTAMP(0) FORMAT 'yyyy-mm-ddbhh:mi:ss' NOT NULL, PROCESS_SEQ_ID INTEGER, PROGRAM_NAME VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROCESS_NAME VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROGRAM_ID INTEGER, PROCESS_TYPE VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROCESS_STATUS VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) UNIQUE PRIMARY INDEX ( AUDIT_SID );BEGIN LOADING infmat.audit ERRORFILES infmat.et1_fl_audit,infmat.et2_fl_audit;SET RECORD TEXT;DEFINE PROCESS_END_DT_TM (CHAR(21),NULLIF='0000-00-00b00:00:00'), AUDIT_SID (char(20)), PROCESS_ID (CHAR(19),NULLIF='*'), PROCESS_BEGIN_DT_TM (CHAR(19)), PROCESS_SEQ_ID (CHAR(47)), PROGRAM_NAME (CHAR(65)), PROCESS_NAME (CHAR(70)), PROGRAM_ID (CHAR(19)), PROCESS_TYPE (CHAR(15)), PROCESS_STATUS (CHAR(30))file=/users/mis/abc/flexpt.dat;INSERT INTO infmat.audit( PROCESS_END_DT_TM, AUDIT_SID, PROCESS_ID, PROCESS_BEGIN_DT_TM, PROCESS_SEQ_ID, PROGRAM_NAME, PROCESS_NAME, PROGRAM_ID, PROCESS_TYPE, PROCESS_STATUS )values ( : PROCESS_END_DT_TM (FORMAT 'yyyy-mm-ddbhh:mi:ss'), : AUDIT_SID, : PROCESS_ID, : PROCESS_BEGIN_DT_TM, : PROCESS_SEQ_ID, : PROGRAM_NAME, : PROCESS_NAME, : PROGRAM_ID, : PROCESS_TYPE, : PROCESS_STATUS);END LOADING;LOGOFF;The invoked script and error is:fastload 0001 DATEFORM ANSIDATE;**** 00:39:25 Date/Time Format set to ANSIDATE*** 00:39:25 Command completed successfully0002 .LOGON dwtest/informatica,**** 00:39:25 Teradata Database Release: V2R.06.01.01.14**** 00:39:25 Teradata Database Version: 06.01.01.16**** 00:39:25 Current CLI or RDBMS allows maximum row size: 64K**** 00:39:25 Character set for this job: ASCII**** 00:39:42 Number of FastLoad sessions connected = 48**** 00:39:42 FDL4808 LOGON successful0003 .ROUTE MESSAGES WITH ECHO TO FILE /users/mis/narahar/fl_informatica.out.ldrlog;0004 database informat;**** 00:39:42 Command completed successfully0005 DROP TABLE informatica.audit;**** 00:39:43 Command completed successfully0006 DROP TABLE informatica.et1_fl_audit;**** 00:39:43 Command completed successfully0007 DROP TABLE informatica.et2_fl_audit;**** 00:39:43 Command completed successfully0008 CREATE SET TABLE informatica.AUDIT ,NO FALLBACK , NO BEFORE JOURNAL,NO AFTER JOURNAL,CHECKSUM = DEFAULT (PROCESS_END_DT_TM TIMESTAMP(0) FORMAT 'yyyy-mm-ddbhh:mi:ss', AUDIT_SID INTEGER NOT NULL, PROCESS_ID INTEGER,PROCESS_BEGIN_DT_TM TIMESTAMP(0) FORMAT 'yyyy-mm-ddbhh:mi:ss' NOT NULL, PROCESS_SEQ_ID INTEGER, PROGRAM_NAME VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROCESS_NAME VARCHAR(70) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROGRAM_ID INTEGER, PROCESS_TYPE VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, PROCESS_STATUS VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) UNIQUE PRIMARY INDEX ( AUDIT_SID );**** 00:39:43 Command completed successfully0009 BEGIN LOADING informatica.audit ERRORFILES informatica.et1_fl_audit, informatica.et2_fl_audit;**** 00:39:44 Number of AMPs available: 48**** 00:39:44 BEGIN LOADING COMPLETE 0010 SET RECORD TEXT; **** 00:39:44 Now set to read 'TEXT' records**** 00:39:44 Command completed successfully0011 DEFINE PROCESS_END_DT_TM (CHAR(21),NULLIF='0000-00-00b00:00:00'), AUDIT_SID (char(20)), PROCESS_ID (CHAR(19),NULLIF='*'), PROCESS_BEGIN_DT_TM (CHAR(19)), PROCESS_SEQ_ID (CHAR(47)), PROGRAM_NAME (CHAR(65)), PROCESS_NAME (CHAR(70)), PROGRAM_ID (CHAR(19)), PROCESS_TYPE (CHAR(15)), PROCESS_STATUS (CHAR(30)) file=/users/mis/narahar/flexpt.dat;**** 00:39:44 FDL4803 DEFINE statement processed0012 INSERT INTO informatica.audit( PROCESS_END_DT_TM AUDIT_SID, PROCESS_ID, PROCESS_BEGIN_DT_TM, PROCESS_SEQ_ID, PROGRAM_NAME, PROCESS_NAME, PROGRAM_ID, PROCESS_TYPE, PROCESS_STATUS )values ( : PROCESS_END_DT_TM (FORMAT 'yyyy-mm-ddbhh:mi:ss'), : AUDIT_SID, : PROCESS_ID, : PROCESS_BEGIN_DT_TM, : PROCESS_SEQ_ID, : PROGRAM_NAME, : PROCESS_NAME, : PROGRAM_ID, : PROCESS_TYPE, : PROCESS_STATUS);*** 00:39:44 Number of recs/msg: 194*** 00:39:44 Starting to send to RDBMS with record 1**** 00:39:44 RECORD is too short by 60 byte(s) Field 1: 2002-12-03 08:33:36 Field 2: 265 Field 3: 2002-12-03 08:24:55 Field 4: WORKORDER Field 5: Field 6: WORKORDER Field 7: ETL - INFORMATICOMPLETED**** 00:39:44 FDL4830 CHAR/BYTE Type - record too short =================================================================== = = = Logoff/Disconnect = = = =================================================================== **** 00:39:44 Logging off all sessions**** 00:39:46 Total processor time used = '9.32 Seconds' . Start : Tue May 8 00:39:25 2007 . End : Tue May 8 00:39:46 2007 . Highest return code encountered = '12'.**** 00:39:46 FastLoad PausedPlease help me to Invoke a fastload Script.Regards,B Mohan Kumar
|
20190 views
|
6 replies,
1 week ago
|
Installation of teradata Express 13 Demo for practice
Topic by karanarora
1 week ago
recently , i have joined teradata training so they have shared the "teradata express 13 " demo tool which will installs on 32 bit processor. mine is 64 bit.
please help how to install the software using VMware workstation.
i have installed VMware workstation9 .
please share the steps to install the same using VMware.
|
5 views
|
0 replies
|
DBC.DBQLogtbl Application id meaning/definitions
Topic by Vincent Gabrielli
01 Oct 2009
Hello support team members, I need your help. in the DBC.DBQLogtbl there is a field named APPID (The application ID under which the query is submitted) does anyone know what UVSH stands for? Example you also find BTEQ, SAS, JDBC, TPUMPEXE, TSCOM3.OUT these are known applications id’s
|
4973 views
|
3 replies,
2 weeks ago
|
Load CLOB from Oracle
Topic by marcog82
2 weeks ago
Hi,
I want to load a table with CLOB field from Oracle to Teradata.
I see the TPT Load but it works only if the CLOB is converted into VARCHAR.
Are there other solutions using TPT LOAD?
Thanks, Marco
|
16 views
|
0 replies
|
|
5 views
|
1 reply,
2 weeks ago
|
bteq export and import for _ET dataparcel
Topic by tdurbin
20 Feb 2012
bteq, export, export/import, _et
Hi, I'm new to Teradata and need to do the following:
I'm on a Unix system, using verision 13.0.
We're inserting data into the "Stage" table from a delimited text file (bell is the delimeter \007)
1. export the dataparcel field from the _ET table to a file (delimited text if possible)
2. fix the contents of the file
|
4941 views
|
21 replies,
2 weeks ago
|
Teradata query parser
Topic by Sleipner
04 Mar 2011
parser
I have a huge number of very large, complex queries which I want to deconstruct into their components and store in a database or XML format. I found one program at http://www.sqlparser.com/ but only their Java version supports Teradata, and it seems a little more complex than I really need or want (and I don't know Java).
One goal is to register the various tables and fields that are used, so that I can make a more targeted help file that primarily concentrates on those, and also to recognize if/where deprecated fields or columns are being used.
|
4981 views
|
4 replies,
2 weeks ago
|
Using templates for operators provided in TPT
Topic by nitindixit
12 Oct 2012
Hi,
How can we use the templates for the operators provided in TPT?
I am having problem in providing schema for producer operators...
Here is the script
DEFINE JOB jobname
DESCRIPTION '---'
(
DEFINE SCHEMA countries_SCHEMA @LoadTargetTable;
APPLY $INSERT @LoadTargetTable TO OPERATOR ($LOAD)
|
5726 views
|
16 replies,
2 weeks ago
|
Need to set Return Code upon "EOF on stdin"
Topic by JimmyLee
3 weeks ago
bteq, EOF, RC
I am experiencing a sporadic problem with BTEQ skipping all the commands from STDIN.
The script is a shell script that does a bunch of set up and then calls BTEQ, piping in the commands that are in the same file.
Here's my script (at least part of it):
|
9 views
|
0 replies
|
Problem with title line when using .export report
Topic by andyh2000
3 weeks ago
question, help, csv
Hi, I am having the following problem when trying to create a CSV report to email out. The title line of the report is showing up like this "((((((((((((((((((((((((((((((((((((((((((((((((((AGT_ENT_US" instead of all the field names. The records themselves are showing up properly.
.set MAXERROR 1
.set width 1300
.set titledashes off
|
8 views
|
1 reply,
3 weeks ago
|
Flat files to Teradata tables
Topic by rakeshreddy43
30 Jul 2009
HiCan anyone send me the procedure for loading the data from flat files(VSAM, txt, csv etc) to teradata tables without using Informatica. thanks,Rakesh
|
3532 views
|
5 replies,
3 weeks ago
|
TD utilities and JAVA.
Topic by mayanktiwari
3 weeks ago
Hi All,
I am developing a code on Core JAVA. But I dont know how to Execute the code with the help of the TD Utilities on UNIX.
Is there any facility/add-in provided by TD by we can do this.
Please respond back if anybody knows about it.
Thanks & Regards,
Mayank
|
1 view
|
0 replies
|
TPT with named pipe
Topic by jawadahmed
1 month ago
teradata parallel transporter (tpt loading)
I have a C++ application which writes into a pipe. TPT reads the delimited records from pipe. But it is throwing an an error:
Teradata Parallel Transporter Version 13.10.00.02
Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel Transporter/lo
gs/JA255020-173.out
Job id is JA255020-173, running on WPKJA255020-QCX
|
263 views
|
3 replies,
3 weeks ago
|
Pages
|
|