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
 

 

DB2 Bind card parameters

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

New User


Joined: 07 Mar 2005
Posts: 43

PostPosted: Wed May 04, 2005 4:51 pm    Post subject: DB2 Bind card parameters
Reply with quote

in DB2 bind card what does these following parameters mean?

ACT(REP) RETAIN
ACQUIRE(USE)
RELEASE(COMMIT)
VALIDATE(BIND)
EXPLAIN(NO)
Back to top
View user's profile Send private message

i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Thu May 05, 2005 3:40 pm    Post subject:
Reply with quote

hi,

ACT(REP) : Action is replace the existing one
ACQUIRE(USE) :locks on table and table space are imposed when it executed sql statement
RELEASE(COMMIT) :locks on table and table space are released on commit.
VALIDATE(BIND) : the authorization is validated at bind time.
EXPLAIN(NO) : no display of access path


cheers...........

pavan
Back to top
View user's profile Send private message
prabhucs01
Warnings : 1

New User


Joined: 07 Mar 2005
Posts: 43

PostPosted: Thu May 05, 2005 4:03 pm    Post subject:
Reply with quote

ACT(REP) : Action is replace the existing one

pavan replace the existing once means what?

replace what?
Back to top
View user's profile Send private message
vinoddevkar

New User


Joined: 13 Apr 2005
Posts: 9
Location: pune

PostPosted: Tue May 10, 2005 10:24 am    Post subject: bind card parameters
Reply with quote

ACT(REP) : Action is replace the existing one

Replace the existing one means u have executed the program with abc.plan and u have done some modifications in the pgm and again if u submit it with the same plan name it will give error as it is already existing....Action(replace) will take care of the execution of the pgm without errors
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 Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
No new posts CICS NEW SIT PARAMETERS CICS BEHAVIOR... Kyle Carroll CICS 0 Fri Nov 04, 2016 11:55 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


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