| View previous topic :: View next topic |
| Author |
Message |
ravikumar_sri2001
Beginner
Joined: 06 Dec 2002
Posts: 117
Topics: 44
Location: Chennai,India
|
 Posted: Mon Apr 04, 2005 10:18 am Post subject: Problem with LOAD utility |
 |
|
Hi Gurus,
My load jcls is given below.
| Code: |
//LOAD EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
LIB('DB2.DSN.RUNLIB.LOAD')
/*
//SYSREC DD DSN=IOFL.D03305.INSTP,DISP=SHR
//SYSIN DD DSN=IOFL.D03305.PUNCH,DISP=SHR
//*
|
IOFL.D03305.INSTP contains the rows to be inserted into the table
Content of the SYSIN dataset is
| Code: |
LOAD DATA INTO TABLE
DSDB22.EFINSTT_V02
(
INST_SWT_ID POSITION( 1 )
CHAR( 8 ) ,
INST_ID POSITION( 9 )
CHAR( 11) ,
INST_PROC_ID POSITION( 20 )
CHAR( 8 ) ,
etc....
|
I am getting following error while executing this jcl.
DSNT493I SQL ERROR DURING SQL STATEMENT PREPARE , TABLE LOAD DATA INTO TABLE
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD DATA, TOKEN FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE WAS EXPECTED
Please help to resolve this problem.
Thanks,
Ravikumar. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
CZerfas
Intermediate
Joined: 31 Jan 2003
Posts: 211
Topics: 8
|
| Posted: Tue Apr 05, 2005 5:41 am Post subject: |
|
|
Hello Ravikumar,
what you posted as your LOAD-JCL is in fact an Unload-Job. Was that by accident, or did you really try to load a table with the DSNTIAUL program?
regards
Christian |
|
| Back to top |
|
|
ravikumar_sri2001
Beginner
Joined: 06 Dec 2002
Posts: 117
Topics: 44
Location: Chennai,India
|
| Posted: Wed Apr 06, 2005 8:27 am Post subject: |
|
|
Christian,
Yes, i was trying to load the table with the DSNTIAUL program. Please give me correct load-jcl to load the table. Thanks in advance.
Thanks,
Ravikumar. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
ravikumar_sri2001
Beginner
Joined: 06 Dec 2002
Posts: 117
Topics: 44
Location: Chennai,India
|
| Posted: Thu Apr 07, 2005 3:20 am Post subject: |
|
|
Kolusu,
Extremely sorry for not searching the archive. I got LOAD-jcl from the link you provided. While running the load-jcl, i got the following error.
DSNU050I DSNUGUTC - LOAD DATA
DSNU650I - DSNURWI - INTO TABLE DSDB22.EFINSTT_V02
DSNU056I - DSNUGMAP - TABLE 'DSDB22.EFINSTT_V02' NOT FOUND
DSDB22.EFINSTT_V02 is a View. Can't i load the VIEW ?. I dont have access to the table.
Thanks,
Ravikumar. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Thu Apr 07, 2005 5:39 am Post subject: |
|
|
Ravikumar,
You CANNOT load a view . It is your table that you have to load.
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
ravikumar_sri2001
Beginner
Joined: 06 Dec 2002
Posts: 117
Topics: 44
Location: Chennai,India
|
| Posted: Wed Apr 13, 2005 7:39 am Post subject: |
|
|
Thanks a lot for your replies.
Thanks,
Ravikumar. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
