Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

input file for tpump

Status
Not open for further replies.

balajius2

Technical User
Nov 2, 2004
13
US
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;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top