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
 

 

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

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

New User


Joined: 13 Jul 2005
Posts: 5

PostPosted: Tue Aug 08, 2006 4:36 pm    Post subject: code bind paramtrs 4 a prog using tables frm 2 diff sub sytm
Reply with quote

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.
Back to top
View user's profile Send private message

renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Wed Aug 09, 2006 7:41 am    Post subject: Re: code bind paramtrs 4 a prog using tables frm 2 diff sub
Reply with quote

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
Back to top
View user's profile Send private message
sh_ak

New User


Joined: 13 Jul 2005
Posts: 5

PostPosted: Wed Aug 09, 2006 6:51 pm    Post subject:
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Aug 09, 2006 7:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Thu Aug 10, 2006 8:10 am    Post subject: Re: code bind paramtrs 4 a prog using tables frm 2 diff sub
Reply with quote

ofer,

pls read ur manual clearly and respond


thanks
renjith
Back to top
View user's profile Send private message
trevor_rebelo

New User


Joined: 18 Aug 2005
Posts: 17

PostPosted: Mon Aug 21, 2006 2:46 pm    Post subject:
Reply with quote

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
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
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm


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