Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of bind parameter, Replace?
- 5 Answers
- 10794 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rana
A "BIND REPLACE" will require a DBRM as input and will
replace the existing data with that supplied in the DBRM.
It will then analyse the access paths for the SQL supplied
in the DBRM. You tend to run a "BIND REPLACE" when the
associated application has been updated so that DB2 is also
updated with any changes to the SQL.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / mahesh vasudevan
For new packages it will be "ADD" option for an already
existing package...it needs to be replaced with the new DBRM
bound...hence it is REPLACE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ramanathan
Plan or Package can be an addition or Replacement.
Default is REPLACEMENT.
REPLACE will replace the existing package with the same name, location & collection.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satty
bind parameter replace is a parameter related to locking
technique. it will specify when to remove the lock.
if any thing wrong please intimate me
| Is This Answer Correct ? | 1 Yes | 10 No |
How to resolve -504 sql code in DB2?
What are foreign keys?
How to fetch the last row from the table in SQL (db2)?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the reason behind not using select * in embedded sql programs?
what's the best lock size that you could use when you create a tablespace?
What information is contained in a SYSCOPY entry?
What information is used as input to the bind process?
What are the isolation levels possible ?
What is table space in db2?
How to retrieve rows from a db2 table in embedded sql?
COBOL 
