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
