Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

REXX and DB2 Command

177 views
Skip to first unread message

Ed Benoit

unread,
Oct 27, 2009, 6:56:24 PM10/27/09
to
Hello All,
Can I do a display of DB2 in a REXX.
Example: -display database(xxxxxx) spacenam(xxxxxxx)
I would like to catch the output of the display of the DB2 command in
rexx. There is no mention of it in Command Reference
Please point me to the manuals that I should review.

Ed.


----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX

Robert Zenuk

unread,
Oct 27, 2009, 7:24:52 PM10/27/09
to
Yes...

/* Quick and Dirty DB2 command scraper */
arg ssid cmd
queue cmd
queue "END"
x = outtrap(thd.)
"DSN SYSTEM("ssid")"
say thd.0 'lines'
do t=1 to thd.0
say strip(thd.t)
end
drop thd.


Rob

In a message dated 10/27/2009 3:56:30 P.M. US Mountain Standard Time,

Albert Klimek

unread,
Oct 28, 2009, 5:01:43 AM10/28/09
to
Take a look at Redbook DB2 Squeezing the Most Out of Dynamic SQL
(sg246418.pdf) Chapter 6. Developing REXX applications using dynamic SQL

Albert

Ed Benoit <Ibm...@AOL.COM>
Gesendet von: TSO REXX Discussion List <TSO-...@VM.MARIST.EDU>
28.10.2009 00:56
Bitte antworten an
TSO REXX Discussion List <TSO-...@VM.MARIST.EDU>


An
TSO-...@VM.MARIST.EDU
Kopie

Thema
[TSO-REXX] REXX and DB2 Command

Ed.


VERLAGSGRUPPE WELTBILD GMBH
Sitz der Gesellschaft: Augsburg
Handelsregister Augsburg HRB 6035
Ust-ID-Nr: DE 127501299

Geschäftsführung:
Carel Halff (Vorsitzender), Dr. Martin Beer, Dr. Klaus Driever

Vorsitzender des Aufsichtsrates:
Dr. Klaus Donaubauer

0 new messages