teradata - T-PUMP DML ERROR -


while running t-pump i'm getting dml error. here script loading data file table infa_source12:

.logtable  etlt5.emp_tpump_log; .logon ttdbia/usr/passwrd; .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 etlt5.infa_source12 (id,name,country) values  (:id, :name, :country)  .import infine /home/a0c9sx/sqlaexport.txt; layout reclayout apply inst ; .end load; .logoff; 
error: **** 10:18:50 uty2832 .dml statement must entered before sql 

i referred below link:

http://www.teradatawiki.net/2013/10/teradatautilities-tpump.html

your script full of synax errors (copied website):

.logtable  etlt5.emp_tpump_log; .logon ttdbia/usr/passwrd; .begin load; -- no semicolon, next keywords part of begin load         -- sessions missing  pack 5  rate 10  error table etlt5.tpumperror; -- no space between error , table .layout reclayout; .field    id        * varchar(10); .field    name      * varchar(20); .field    country   * varchar(30);  .dml label inst;   insert etlt5.infa_source12 (id,name,country) values  (:id, :name, :country)  -- missing semicolon, needed each sql statement .import infine /home/a0c9sx/sqlaexport.txt; -- no semicolon, next keywords part of import layout reclayout apply inst ; .end load; .logoff; 

it save more time when follow examples found in manuals...


Comments