Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Load Card giving problem.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
murali922

New User


Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Aug 14, 2007 3:29 pm    Post subject: Load Card giving problem.
Reply with quote

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.
Back to top
View user's profile Send private message

kavisuresh

New User


Joined: 22 May 2007
Posts: 7
Location: chennai

PostPosted: Tue Aug 14, 2007 3:37 pm    Post subject: Re: Load Card giving problem.
Reply with quote

Hi,

Try this Load card,

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

Regards,
Kavitha
Back to top
View user's profile Send private message
murali922

New User


Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Aug 14, 2007 3:55 pm    Post subject:
Reply with quote

Now I getting ERROR: ILLEGAL SYMBOL "LOG".
Back to top
View user's profile Send private message
murali922

New User


Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Aug 14, 2007 3:56 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Wed Aug 15, 2007 1:40 am    Post subject: Reply to: Load Card giving problem.
Reply with quote

DSNTIAUL is used to unload data. Why are you using it to load tables?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us