MVSFORUMS.com

matchum · Beginner Joined: 10 May 2007 Posts: 2 Topics: 1

Issue:
Z/OSe with ISPF and REXX needs to access a mix of DB2 versions. The DB2 v7 libraries are pre-allocated to ISPLLIB.

Question:
I can dynamically 'augment' ISPLLIB but cannot re-define it within an ISPF session but how can I DYNAMICALLY replace the ISPLLIB before invoking the DB2 v8 version of DSNREXX

kolusu · Posted: Thu May 10, 2007 7:53 am Post subject:

matchum,

Check this link

http://www-1.ibm.com/support/docview.wss?rs=64&context=SSEPEK&dc=DB520&uid=swg21214800&loc=en_US&cs=UTF-8&lang=en&rss=ct64db2

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

matchum · Beginner Joined: 10 May 2007 Posts: 2 Topics: 1

Kolusu,

Just the job - thanks for that handy URL Laughing

semigeezer · Posted: Thu May 10, 2007 10:00 am Post subject:

I've never used DB2 (so take this for what it is worth), but I don't think that URL has the correct answer, or at least it is incomplete.
You should be able to do the LIBDEF allocation and then invoke a separate command to do the DSN calls. You must start the CLIST (or Rexx) using the SELECT CMD(%clistname) service and pass the allocation to that. It has been too many years since I used LIBDEF with this problem, but I think there is a keyword on the SELECT service (something like PASSLIB??) that will do this.

The reason for this is that you need to establish a tasklib for Rexx and DB2 to find the modules, and select cmd() will do that.

Or, I could be completely wrong (something that only happens about 30 times a day Shocked

)