MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

new company / new project

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A
View previous topic :: View next topic  
Author Message
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 366
Topics: 104

PostPosted: Mon Dec 03, 2007 8:13 am    Post subject: new company / new project Reply with quote

Hi,

The question is to find out the parameters to be used for Package or Plan BIND. We joined a new project where DB2 is used. How to know the below given params by ourselves? Is it useful to query SYSIBM tables to get the same?
Code:

//SYSTSIN   DD *         
 DSN SYSTEM(XXXX)         
 BIND PACKAGE(XXXXXXX) - 
 OWNER(XXXXXXXX) -       
 QUALIFIER(XXXXXXX) -     
 MEMBER (XXXXXXXX) -     
 VALIDATE(BIND) -         
 CURRENTDATA(NO) -       
 EXPLAIN(YES) -           
 RELEASE(COMMIT) -       
 ACTION(REPLACE) -       
 ISOLATION(CS)           
/*             

//SYSTSIN   DD *         
 BIND PLAN(XXXXXXXX) -     
 OWNER(XXXXXXXX) -         
 PKLIST(XXXXXXX.*) -       
 QUALIFIER(XXXXXXX) -       
 ACQUIRE(USE) -             
 RELEASE(COMMIT) -         
 CURRENTDATA(NO) -         
 ACTION(REPLACE) RETAIN -   
 ISOLATION(CS);                       
/*

Also, would like to know how the package and plan BIND card will differ if any sub-program call is involved.

Please explain.

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Mon Dec 03, 2007 8:55 am    Post subject: Reply with quote

Consult your DB2 admin.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group