cannot INSERT with tTeradataFastloadUtility

One Star

cannot INSERT with tTeradataFastloadUtility

hi;

If tTeradataFastloadUtility is executed, the processing number always becomes 0.

Is not the INSERT missed to the script that tTeradataFastloadUtility outputs?
What should I do to output INSERT ?
Please teach in the methods other than using tTeradataMultiload.

#################
.SESSIONS 8;
.SET RECORD VARTEXT ";";
.LOGON usr,pwd;
DEFINE
id (VARCHAR(255)),
name (VARCHAR(255))
FILE=C:\Talend\TDQ_EE_MPX-All-r33000-V3.2.2\workspace\test.csv;
BEGIN LOADING db.host.mytable ERRORFILES db.host.mytable_ERR1, db.host.mytable_ERR2 CHECKPOINT 1000000;
.END LOADING;
.LOGOFF;
#################
One Star

Re: cannot INSERT with tTeradataFastloadUtility

FastloadUtility was normal end.
There is no error message.
but,Not Data loaded because there is no Insert sentence ."INSERT INTO TEST ( AAA ) VALUES (:AAA);"

############### From here to log of FastloadUtility the under
===================================================================
= =
= FASTLOAD UTILITY VERSION 12.00.00.004 =
= PLATFORM WIN32 =
= =
===================================================================

===================================================================
= =
= Copyright 1984-2007, NCR Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================

**** 11:31:57 Processing starting at: Mon Feb 15 11:31:57 2010

0001 .SESSIONS 8;

**** 11:31:57 FDL4866 SESSIONS command accepted

0002 .SET RECORD VARTEXT ",";

**** 11:31:57 Now set to read 'Variable-Length Text' records
**** 11:31:57 Delimiter character(s) is set to ','
**** 11:31:57 Command completed successfully

===================================================================
= =
= Logon/Connection =
= =
===================================================================

0003 .LOGON usr,

**** 11:31:59 Teradata Database Release: 12.00.00.10
**** 11:31:59 Teradata Database Version: 12.00.00.10
**** 11:31:59 Current CLI or RDBMS allows maximum row size: 64K
**** 11:31:59 Character set for this job: ASCII
**** 11:31:59 Number of FastLoad sessions requested = 8
**** 11:31:59 Number of FastLoad sessions connected = 2
**** 11:31:59 FDL4808 LOGON successful

0004 DEFINE
ID (VARCHAR(255)),
NAME (VARCHAR(255)),
FILE=C:\Talend\TDQ_EE_MPX-All-r33000-V3.2.2\workspace\test.csv;

**** 11:31:59 FDL4803 DEFINE statement processed

0005 BEGIN LOADING talendpoc.mytable ERRORFILES talendpoc.mytable_ERR1, talendpoc.
mytable_ERR2 CHECKPOINT 1000000;

**** 11:32:00 Number of AMPs available: 2
**** 11:32:00 BEGIN LOADING COMPLETE

===================================================================
= =
= End Loading Phase =
= =
===================================================================

0006 .END LOADING;

**** 11:32:00 END LOADING COMPLETE

Total Records Read = 0
Total Error Table 1 = 0 ---- Table has been dropped
Total Error Table 2 = 0 ---- Table has been dropped
Total Inserts Applied = 0
Total Duplicate Rows = 0

Start: Mon Feb 15 11:32:00 2010
End : Mon Feb 15 11:32:00 2010

0007 .LOGOFF;

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 11:32:01 Logging off all sessions
**** 11:32:02 Total processor time used = '0.1875 Seconds'
. Start : Mon Feb 15 11:31:57 2010
. End : Mon Feb 15 11:32:02 2010
. Highest return code encountered = '0'.
**** 11:32:02 FDL4818 FastLoad Terminated

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog