code bind paramtrs 4 a prog using tables frm 2 diff sub sytm

sh_ak · New User Joined: 13 Jul 2005 Posts: 5

My program ABC accesses 3 tables from 2 diff sub systems. How to code the bind parameters for compiling this job?

currently, i have given the bind param in the compile jcl as :

DSN SYSTEM(DSNT)
BIND PACKAGE(PKG1) +
CURRENTDATA(NO) +
OWNER(XXX) +
QUALIFIER(XXX) +
ACTION(REPLACE) +
ISOLATION(CS) +
VALIDATE(BIND) +
MEMBER(ABC) +
ENABLE(BATCH)
BIND PACKAGE(PKG2) +
CURRENTDATA(NO) +
OWNER(YYY) +
QUALIFIER(YYY) +
ACTION(REPLACE) +
ISOLATION(CS) +
VALIDATE(BIND) +
MEMBER(ABC) +
ENABLE(BATCH)

i'm getting rc=8; it shows 'unsuccessful bind' with a sql code
= - 204. Pls tell me if there is some other way of coding the bind params.

renjith · New User Joined: 07 Aug 2006 Posts: 11

I guess u cant achieve ur goal by making any changes in ur bind card.
In order to achieve the same u must create aliases for those tables, (which are in other subsystem)in ur current subsystem.So that u can access those tables as local tables.And u can make use of the same bind card

thanks
renjith

sh_ak · New User Joined: 13 Jul 2005 Posts: 5

Hi Renjith, thanks for the reply. I dont have any idea about creating aliases.could you pls tell me how to do this. would appreciate ur help

ofer71 · Posted: Wed Aug 09, 2006 7:15 pm

You can't create an alias and reference it from another subsystem. To read more about creating aliases, please refer to the fine manual.

O.

renjith · New User Joined: 07 Aug 2006 Posts: 11

ofer,

pls read ur manual clearly and respond

thanks
renjith

trevor_rebelo · New User Joined: 18 Aug 2005 Posts: 17

Hi

Try putting the END statment after the bind card

e.g.
Bind Package1
.....
....
Bind Package2
....
...
END

2. if this packages are meant to bind a program to seperate subsystem then qualify the colletion ID with the location ID of the subsystems

Regards
Trevor