SQL query using JCL.

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
amolpawar
Member
Posts: 25
Joined: Mon Jun 29, 2009 2:52 pm

SQL query using JCL.

Post by amolpawar » Thu Jul 22, 2010 1:50 pm

HI,

I am having a file which contains SQL queries, i want to execute that update queries using JCL.

Please help me.

Thanks,
Amol S Pawar

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Thu Jul 22, 2010 2:16 pm

here is a link on DSNTEP2 and DSNTEP4

but, I would contact my site db2 support, since you may need authority to run these jobs.
As well as the fact that they more than likely have the JCL models already constructed.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

amolpawar
Member
Posts: 25
Joined: Mon Jun 29, 2009 2:52 pm

Post by amolpawar » Thu Jul 22, 2010 3:51 pm

I am unable to find loadlib for DSNSTEP2 for following code

//STP0100 EXEC PGM=IKJEFT01
//SYSREC00 DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
RUN PROGRAM(DSNSTEP2) PLAN(DSNSTEP2) LIB('DB2TEST.RUNLIB.LOAD')
END
/*
//SYSIN DD *
SQL query
/*



Please suggest me

Thanks,
Amol

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Thu Jul 22, 2010 3:58 pm

that is why I said, check with your DB2 support,
as they know where this stuff is.

Why would you think that WE would know how your site is set-up?
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Jul 23, 2010 5:41 pm

And you have coded "DSNSTEP2", while Dick has mentioned about DSNTEP2 - no extra "S"?
Regards,
Anuj

samaysimant
Member
Posts: 3
Joined: Sat Jul 31, 2010 7:24 pm

Post by samaysimant » Sun Aug 01, 2010 3:52 pm

Its DSNTEP2

Not DSNSTEP2

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others