| Author |
Message |
karthikraman_m
New User
Joined: 10 Jun 2005 Posts: 14 Location: India
|
|
|
|
Hi,
I need to know how to code and execute SQL statements from a REXX program. Please let me know if any good materials are available for learning this.
Thanks in Advance |
|
| Back to top |
|
 |
References
|
Posted: Wed Sep 28, 2005 2:47 pm Post subject: Re: Embedded SQL in REXX |
 |
|
|
 |
MGIndaco
Moderator
Joined: 10 Mar 2005 Posts: 479 Location: Milan, Italy
|
|
|
|
I think that you have more than one way.
If you search with google this string:
you will find a lot of suggest from IBM and other publications.
Personally I never tested it because I've not not the necessary routines installed(i.e. the RXSUBCOM) .
This is one of the many link:
http://www.db-hq.net/Articles/db2zos/objzos/MAS006.sql
For what I've done in the paste, I found easy and useful a simple call to DSNTIAUL to do the same(especially for batch).
I hope in this help.
If you need other suggest about the second way I'll post you a sample. |
|
| Back to top |
|
 |
|
|