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

[Aanand]

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

[nesans]

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