T-PUMP DML ERROR

Teradata Applications
Enthusiast

T-PUMP DML ERROR

.LOGTABLE  etlt5.EMP_TPUMP_LOG;
.logon ttdbia/LOGIN DETAILS;

.BEGIN LOAD;
PACK 5
RATE 10
ERROR TABLE Etlt5.TPUMPERROR;

 .LAYOUT RECLAYOUT;

 .FIELD    id        * varchar(10);
.FIELD    name      * varchar(20);
.FIELD    country   * varCHAR(30);

.DML label INST;

INSERT INTO etlt5.infa_source12
(id,name,country)
VALUES
(:id, :name, :country)

 .IMPORT INFINE /home/a0c9sx/SQLAExport.txt;

 LAYOUT RECLAYOUT
APPLY INST ;

 .END LOAD;
.LOGOFF;

=============ERROR=======================
0002 .logon ttdbia/a0c9sx,;
**** 04:52:00 UTY8400 Teradata Database Release: 15.10.01.03
**** 04:52:00 UTY8400 Teradata Database Version: 15.10.01.03
**** 04:52:00 UTY8400 Default character set: ASCII
**** 04:52:00 UTY8400 Current RDBMS has UDT support
**** 04:52:00 UTY8400 Current RDBMS has Large Decimal support
**** 04:52:00 UTY8400 Maximum supported buffer size: 1M
**** 04:52:00 UTY8400 Upsert supported by RDBMS server
**** 04:52:00 UTY8400 Data Encryption supported by RDBMS server
**** 04:52:00 UTY8400 Array Support supported by RDBMS server
**** 04:52:00 UTY8400 Statement Independence supported by RDBMS server
**** 04:52:01 UTY6211 A successful connect was made to the RDBMS.
**** 04:52:01 UTY6210 Logtable 'etlt5.EMP_TPUMP_LOG' indicates that a restart is
     in progress.
     ========================================================================
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ========================================================================

0003 .BEGIN LOAD;
     ========================================================================
     =                                                                      =
     =          Processing TPump Statements                                 =
     =                                                                      =
     ========================================================================
0004 PACK 5
     RATE 10
     ERROR TABLE Etlt5.TPUMPERROR;
**** 04:52:01 UTY2832 A .DML statement must be entered before any SQL
     statements.
     ========================================================================
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ========================================================================
**** 04:52:01 UTY6215 The restart log table was not dropped by this task.
**** 04:52:01 UTY6212 A successful disconnect was made from the RDBMS.
**** 04:52:01 UTY2410 Total processor time used = '0.036435 Seconds'
     .       Start : 04:52:00 - SAT MAR 26, 2016
     .       End   : 04:52:01 - SAT MAR 26, 2016
     .       Highest return code encountered = '8'.
$

Here is my tpump script and the Error i'm getting.

Please help me in resolving it.Thanks in advance !!!

3 REPLIES
Teradata Employee

Re: T-PUMP DML ERROR

Remove the semicolon between BEGIN LOAD and the load options.

Enthusiast

Re: T-PUMP DML ERROR

Removed,but still the same errors

Senior Apprentice

Re: T-PUMP DML ERROR

You posted the same question on StackOverflow and it was answered there yesterday...