Answer Posted / siri
replace is ACTION parameter of the BIND CARD....in ACTION parameter PACKAGE or PLAN can be addition(ADD) or replacement.....
SYNTAX : ACTION(ADD/REPLACE)
ADD : add the new package to sysibm.syspackage
REPLACE : will replace the an existing package with the same name ,location and collection
REPLVER(version-id) will replace a specific version of an existing package..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the location where the output received from explain statement is stored.
What is a plan and package in db2?
What is runstats db2?
What is the difference between bind and rebind in db2?
How can you do the explain of a dynamic sql statement?
What is the use of commit in db2?
What is role in db2?
Explain in brief how does db2 determine what lock-size to use?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What does reorg do in db2?
What is node in db2?
What is buffer pool?
What db2 400?
What is a trigger in the db2 database?