IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

NEED JCL FOR SUBMITTING EMBEDDED SQL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sandy_mcs

New User


Joined: 01 Apr 2006
Posts: 17
Location: Pune

PostPosted: Mon Apr 03, 2006 7:31 pm
Reply with quote

Can somebody plz send me the jcl for submitting embedded sql.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Mon Apr 03, 2006 9:26 pm
Reply with quote

hy sandy_mcs,

DB2BATCH EXEC PGM=IKJEFT1B,DYNAMNBR=20
STEPLIB DD DISP=SHR,SYS1.DSN.SDSNLOAD
SYSPRINT DD SYSOUT=*
SYSTSPRT DD SYSOUT=*
SYSOUT DD SYSOUT=*
SYSUDUMP DD SYSOUT=*
SYSDBOUT DD SYSOUT=*
SYSTSIN DD *
DSN SYSTEM (your-db2-ssid)
RUN PROGRAM (DSNTEP2) -
PLAN (DSNTEP2)
//SYSIN DD *
and-here-your-db2-query dml or ddl or dcl....
/*

martin9
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts submitting feedback for manuals All Other Mainframe Topics 3
No new posts JCL submitting JCL JCL & VSAM 6
No new posts cobol embedded sql COBOL Programming 7
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB JCL & VSAM 12
No new posts Null Indicator value -2 means in Embe... DB2 2
Search our Forums:

Back to Top