IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Bind card parameters


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts Generate output lines (SYSIN card for... DFSORT/ICETOOL 4
No new posts Need suggestion on a sort card DFSORT/ICETOOL 10
No new posts Want to mask Middle 8 Digits of Debit... COBOL Programming 3
Search our Forums:

Back to Top