Is it possible to connect 2 different SSID using rexx?

Marlon · Posted: Sat Apr 11, 2009 1:57 am

Hi,

Is it possible to create a rexx program and connect two different ssid?

This are the things that I need to do,

Table1 --> production table
Table2 --> test region

I need to read table1(production) and update some records from our table2(test region).

I was thinking if my code below will work before saying yes to my boss for this process assuming that I will not load table1 from test region. Hope someone could help me on this? Thanks.

say production ssid1 = DB2P and test ssid2 = DB2T

/*rexx*/
ADDRESS TSO "SUBCOM DSNREXX"

IF RC <> 0 THEN
DO
X_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
IF X_RC <> 0 THEN
DO
SAY 'PROBLEM LOADING '||SUBSYS' ENVIRONMENT'
EXIT 0
END
END

ADDRESS DSNREXX "CONNECT" ssid1
IF SQLCODE <> 0 THEN
DO
CALL SQLCA
EXIT 0
END
ELSE
DO
SAY "SUCCESSFUL CONNECTION TO DB2P"
END

ADDRESS DSNREXX "CONNECT" ssid2
IF SQLCODE <> 0 THEN
DO
CALL SQLCA
EXIT 0
END
ELSE
DO
SAY "SUCCESSFUL CONNECTION TO DB2T"
END

....
....
reading and updating logic starts here..and so on...
....
....

wanderer · Posted: Sat Apr 11, 2009 2:53 am

If you have access to remote SSID using DDF and can use three part names loc.creator.tbname in your system(e.g. DSNTEP2 etc), then why not.

Connect to 1st ssid using DSNREXX and when you need remote tables just use three part names to get data from there. No need to establish explicit connection to 2nd ssid.

Marlon · Posted: Sat Apr 11, 2009 3:32 am

I tried your suggestion and it works!!! now this is my problem

say SSID1 = DB2T (test region)
SSID2 = DB2U (pre-prod region)
SSID3 = DB2P (prod region)

when I tried using DB2T and DB2U using my rexx script I was able to select the tables that I need to inquire. BUT when I tried same rexx script and change DB2U to DB2P, I'm encountering this problem

SQLCODE: -516 --> I displayed the sqlcode error from my script

-516 THE DESCRIBE FOR STATIC STATEMENT DOES NOT IDENTIFY A PREPARED
STATEMENT

Marlon · Posted: Sat Apr 11, 2009 3:45 am

Just disregard my second response...I found out my bug loc.creator.tbname --> my creator name is different from db2u and DB2t that's why i'm getting -516 error...thanks WANDERER!!!