Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Embedded SQL in REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
Author Message
karthikraman_m

New User


Joined: 10 Jun 2005
Posts: 14
Location: India

PostPosted: Wed Sep 28, 2005 2:47 pm    Post subject: Embedded SQL in REXX
Reply with quote

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
View user's profile Send private message
References
PostPosted: Wed Sep 28, 2005 2:47 pm    Post subject: Re: Embedded SQL in REXX Reply with quote

MGIndaco

Moderator


Joined: 10 Mar 2005
Posts: 479
Location: Milan, Italy

PostPosted: Wed Sep 28, 2005 10:42 pm    Post subject:
Reply with quote

I think that you have more than one way.
If you search with google this string:
Quote:
"ADDRESS DSNREXX"

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1