Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of bind parameter, Replace?
- 5 Answers
- 10501 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 |
What is a db2 tablespace?
What is a DBRM, PLAN ?
What is tablespace?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is a DB2 catalog?
how to resolve -805 . how to see dbrm and package not found
What is catalog database in db2?
What is the use of reorg in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Explain in detail about buffer manager and its functionalities?
COBOL 
