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.

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.

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..

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.

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

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

What does runstats do in db2?

0 Answers  

wht displays the number of times a query modified ?

2 Answers   TCS,

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

What is IMAGECOPY ?

6 Answers  

What is meant by concurrency?

1 Answers  

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

what is sql abend code -801,-802?

2 Answers  

What is lock escalation?

2 Answers  

What are data types?

2 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,