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.

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?

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.

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

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.

Can anyone tell me the difference btw running a query or set of query in sql assistant and BTEQ?

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

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.

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.

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.

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! 

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.

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

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.

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

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
 

Hi Experts,
 

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

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.

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)

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):

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

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

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

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