Load Card giving problem.

murali922 · New User Joined: 25 Jul 2005 Posts: 92 Location: India

i am trying to load data into a table. The following is the load card that i use.

LOAD DATA INDDN SYSREC LOG YES RESUME YES SHRLEVEL CHANGE
INTO TABLE C0C.T8865
(
TABLE_CD POSITION (3) CHAR (5) ,
ACTIVE_PART_CD POSITION (8) CHAR (1) ,
SYS_PARTITION_NO POSITION (9) SMALLINT ,
TABLE_DS POSITION (11) CHAR (40)
)

When I execute the load card, it gives me a syntax error.

********************************* TOP OF DATA **********************************
DSNT490I SAMPLE DATA UNLOAD PROGRAM
DSNT505I DSNTIAUL OPTIONS USED: SQL
DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO 80
DSNT504I UNLOAD DATA SET SYSPUNCH BLOCK SIZE SET TO 80

DSNT502I ERROR IN DSNTIAUL SQL INPUT:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "INDDN". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: IS
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 14 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF' X'0000000E' X'00000000' SQL DIAGNOSTIC
INFORMATION
******************************** BOTTOM OF DATA ********************************

I am not able to spot any syntax error in this. Can some one please help...

Thanks.

kavisuresh · New User Joined: 22 May 2007 Posts: 7 Location: chennai

Hi,

Try this Load card,

LOAD DATA LOG NO RESUME YES NOCOPYPEND INDDN SYSREC00 INTO TABLE C0C.T8865

Regards,
Kavitha

murali922 · New User Joined: 25 Jul 2005 Posts: 92 Location: India

Now I getting ERROR: ILLEGAL SYMBOL "LOG".

murali922 · New User Joined: 25 Jul 2005 Posts: 92 Location: India

Whatever comes immediately after LOAD DATA, the job says its illegal.

E.G : If I use
LOAD DATA INDDN SYSREC ....

It says INDDN is illegal.

If I use
LOAD DATA LOG NO

It says LOG is illegal.

wanderer · Posted: Wed Aug 15, 2007 1:40 am

DSNTIAUL is used to unload data. Why are you using it to load tables?