473,226 Members | 1,595 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,226 software developers and data experts.

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 2109

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Mortimer | last post by:
Hi, I hope someone can help. I can't seem to find the answer to this anywhere. I need to change the SQL terminator from a semicolon (;) to an exclamation point within SPUFI in order to process a...
4
by: Jagdip Singh | last post by:
Hi, What is SPUFI regards, jagdip
1
by: Narender Singh | last post by:
Hi All, Is there anyway i can run the Online Spufi panel in batch. I don't want to use the DSNTEP2 program, b'cause it has a limit of 133 Record length. And apart from these i don't have access...
2
by: alex.mcshane | last post by:
Hi - I would be grateful for advice regarding the following. Via SPUFI, I am using an SQL member to generate further SQL Statements. Unfortunately, the generating output SQL statements are...
2
by: waimanlau | last post by:
Hi all! System Specs: DB2 UDB 7 on z/OS 390 The Problem: I want to execute a DDL file in my allocated Data Set. But the only thing that happens, when I press Enter is, that SPUFI jumps...
3
by: mvsguy | last post by:
I'm a sysprog who is new to DB2. I've installed both QMF & SPUFI. SPUFI seems far more flexible than QMF. Could someone explain the difference? What does QMF do that SPUFI can't? Regards,...
0
by: mohandaspradeep | last post by:
Hi Is there any restriction in coding number of queries in a single file for a Batch SPUFI in DB2? Can a Batch SPUFI have any no of queries in it ?
1
by: LA1 | last post by:
I have telecomuter that logs into a mainframe to use a DB2 database. The client uses SPUFI to edit the database and make changes. The client has received from us a new notebook. Both his old and...
1
by: karpalmera | last post by:
Hello! I am using UDB 8 in Z/OS and I am trying to execute this statement in SPUFI select dept, name, row_number() over() from staff It just doesn't work. Here is the error message:...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.