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
Post a Comment