Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Accessing DB2 table using REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ssk1711

New User


Joined: 16 Jun 2008
Posts: 40
Location: bangalore

PostPosted: Thu Jun 19, 2008 3:07 pm    Post subject: Accessing DB2 table using REXX
Reply with quote

Hi,
I am trying to access DB2 tables using REXX.

My program is :

*************************************************************

/* Rexx */
/* Access DB2 Tables */

/* Assign the query to a variable */

QUERYSQL = "SELECT USER_NAME FROM USER_DETAILS" ,
"WHERE EDIT_ACCESS='Y'"

Drop ResTable.

Cnt = 1

/* Check whether the DSNREXX environment is available */

'SUBCOM DSNREXX'

/* If not, then make it available */

IF RC THEN
DO
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
END

/* Connect to the DB2 subsystem */

ADDRESS DSNREXX 'CONNECT' 'SubsystemName' /* eg: DBT2 */

/* Set the DSNREXX environment */

ADDRESS DSNREXX

/* Prepare the SQL statement */

"EXECSQL PREPARE S1 FROM :QUERYSQL"

************************************************************

The problem is with CONNECT statement.
When I execute it, i got the error msg : "Routine not found"

Can anyone please tell me what may went wrong with the statement ?
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Thu Jun 19, 2008 4:02 pm    Post subject: Reply to: Accessing DB2 table using REXX
Reply with quote

ssk,

Quote:
Can anyone please tell me what may went wrong with the statement ?


The error message says it all. The connection has failed. Just check whether you have given the correct subsystem name.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Thu Jun 19, 2008 4:27 pm    Post subject:
Reply with quote

Or whether the REXX/DB2 feature was correctly installed (DB2 installation process).

O.
Back to top
View user's profile Send private message
ssk1711

New User


Joined: 16 Jun 2008
Posts: 40
Location: bangalore

PostPosted: Mon Jun 23, 2008 2:58 pm    Post subject:
Reply with quote

Thanks.
I have to contact my system administrator regarding this.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Need help on If condition continuatio... ashok_uddaraju CLIST & REXX 4 Fri May 19, 2017 8:55 am
No new posts Accessing first bit of PD value rajatbagga DFSORT/ICETOOL 11 Wed May 03, 2017 6:03 am
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us