MVSFORUMS.com

syandra · Beginner Joined: 26 May 2003 Posts: 19 Topics: 6

Hi all,

Can we execute DB2 queries from the TSO.
PLease let me know all the possibilities.

Thanks,
Sukumar

coolman · Posted: Mon May 26, 2003 4:06 am Post subject:

Sukumar,

The following job would execute a query from a batch job

kolusu · Posted: Mon May 26, 2003 9:55 am Post subject:

syandra,

You can also use DSNTIAUL.check this link for explanation and examples of DSNTIAUL.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542

Interactively , you can use SPUFI , QMF , PRO-EDIT to execuete your db2 queries.

Hope this helps...

cheers

kolusu

syandra · Beginner Joined: 26 May 2003 Posts: 19 Topics: 6

Can we run DB2 queries from the TSO command line

kolusu · Posted: Tue May 27, 2003 5:20 am Post subject:

syandra,
You can code an REXX exec which will access DB2. you can put all your queries in the EXEC and run it from the TSO command line.

Check this link for examples.

ftp://ftp.software.ibm.com/software/os390/db2server/books/REXXV5.PDF

Hope this helps....

cheers

kolusu

coolman · Posted: Wed May 28, 2003 1:58 am Post subject:

Kolusu,
Iam not able to access the link you had provided.

Syandra,
Answering your question, just try this :

1.Go to command shell (option 6)
2.Type TSO DSN
3. Now Type this
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2)
4. You would have a : prompt
5. Now, type your query there and press Enter
6. You would be greeted with +: prompt
7. Now press space bar (or any other characters), and complete that line
8. When you press an Enter, you would get the Result of your query (online)

Kolusu,
This is where I have a question. How do you replace step7. I tried "end,exit,quit" (allmost everything), but not able to find a way to terminate the program

Any suggestions...

Hope this helps...

Cheers,
Coolman.
________
marijuana dispensary

kolusu · Posted: Wed May 28, 2003 5:18 am Post subject:

coolman,

I have no problems accessing the above posted link. Do you have acrobat reader on your system?If you do not have then you can download the reader from the net. It is free. The link points to a PDF file and if you are on a dial up connection it will take a while for the link to open.

Coming to your other query, my shop has restricted the usage of DB2 utility programs via TSO. so I cannot simulate your problem. sorry about that.

Thanks

Kolusu