470,581 Members | 2,433 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

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

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
1 1999

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.

Similar topics

5 posts views Thread by Mortimer | last post: by
4 posts views Thread by Jagdip Singh | last post: by
1 post views Thread by Narender Singh | last post: by
2 posts views Thread by alex.mcshane | last post: by
2 posts views Thread by waimanlau | last post: by
3 posts views Thread by mvsguy | last post: by
reply views Thread by mohandaspradeep | last post: by
1 post views Thread by LA1 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.