By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

DB2 on Z/OS - SQL w/o SPUFI / QMF kinda tool

P: n/a
Hi all,

A crazy thought just popped up into my head.
Supposing your site didnt have SPUFI / QMF / Candle / Platinum or any
tool that would let u create and run your SQLs, which would be the best
way to get your data?

(fyi we use SPUFI, CANDLE and PLATINUM)

I think there is a method to use IKJEFT01 and the DSN SYSTEM / some
such command with the SQL in a JCL to retreive the data in either a
dataset / SYSOUT.

Could somebody let me know how i could go about doing this?

Searching around on google isnt giving me much to go with.
-Aanand

Nov 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Aanand wrote:
Hi all,

A crazy thought just popped up into my head.
Supposing your site didnt have SPUFI / QMF / Candle / Platinum or any
tool that would let u create and run your SQLs, which would be the best
way to get your data?

(fyi we use SPUFI, CANDLE and PLATINUM)

I think there is a method to use IKJEFT01 and the DSN SYSTEM / some
such command with the SQL in a JCL to retreive the data in either a
dataset / SYSOUT.

Could somebody let me know how i could go about doing this?

Searching around on google isnt giving me much to go with.
Here is houw you can get the same results as SPUFI, QMF etc..

//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(?????) (your subsystem)

RUN PROGRAM(DSNTEP2) PLAN(DSNTEP71) -
LIB('SYS2.DB2.????.RUNLIB.LOAD') (your runlib library)

END
//SYSIN DD *
SELECT (your select, update, delete statements)
//*

Hope this helps, I've used this before so many times
>
-Aanand
Nov 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.