Hello ,
I am trying to run a tpump script,but i keep on getting the access module error16-unexected data format.can anybody give me an idea about what would be the input file for the following script.i am just importing two field one number and one char.
tpump code:
.LOGTABLE iw_demo.TLddNT2H1;
.LOGON demotdat/dbc,dbc;
DROP TABLE iw_demo.TBL1T1;
DROP TABLE iw_demo.TBL2T1;
DROP TABLE iw_demo.tlnt2err1;
CREATE TABLE iw_demo.TBL2T1,FALLBACK
(AINTEGER INTEGER,
ACHAR CHAR (5))
UNIQUE PRIMARY INDEX (AINTEGER);
/*****************************************************************/
/* BEGIN LOAD WITH ALL THE OPTIONS SPECIFIED SUCH AS ERRLIMIT, */
/* CHECKPOINT, SESSIONS,TENACITY */
/*****************************************************************/
.BEGIN LOAD
SESSIONS 6 4
PACK 3
CHECKPOINT 1
TENACITY 2
ERRLIMIT 5
ERRORTABLE iw_demo.tlnt2err1;
.LAYOUT LAY1A;
.FIELD AINTEGER * INTEGER;
.FIELD ACHAR * CHAR (5);
.DML LABEL LABELA
IGNORE DUPLICATE ROWS
IGNORE MISSING ROWS
IGNORE EXTRA ROWS;
INSERT INTO iw_demo.TBL2T1 VALUES
AINTEGER,:ACHAR);
.IMPORT INFILE "c:\tpump1input.dat"
LAYOUT LAY1A
APPLY LABELA ;
.END LOAD;
.LOGOFF;
I am trying to run a tpump script,but i keep on getting the access module error16-unexected data format.can anybody give me an idea about what would be the input file for the following script.i am just importing two field one number and one char.
tpump code:
.LOGTABLE iw_demo.TLddNT2H1;
.LOGON demotdat/dbc,dbc;
DROP TABLE iw_demo.TBL1T1;
DROP TABLE iw_demo.TBL2T1;
DROP TABLE iw_demo.tlnt2err1;
CREATE TABLE iw_demo.TBL2T1,FALLBACK
(AINTEGER INTEGER,
ACHAR CHAR (5))
UNIQUE PRIMARY INDEX (AINTEGER);
/*****************************************************************/
/* BEGIN LOAD WITH ALL THE OPTIONS SPECIFIED SUCH AS ERRLIMIT, */
/* CHECKPOINT, SESSIONS,TENACITY */
/*****************************************************************/
.BEGIN LOAD
SESSIONS 6 4
PACK 3
CHECKPOINT 1
TENACITY 2
ERRLIMIT 5
ERRORTABLE iw_demo.tlnt2err1;
.LAYOUT LAY1A;
.FIELD AINTEGER * INTEGER;
.FIELD ACHAR * CHAR (5);
.DML LABEL LABELA
IGNORE DUPLICATE ROWS
IGNORE MISSING ROWS
IGNORE EXTRA ROWS;
INSERT INTO iw_demo.TBL2T1 VALUES
.IMPORT INFILE "c:\tpump1input.dat"
LAYOUT LAY1A
APPLY LABELA ;
.END LOAD;
.LOGOFF;