DB2Z/os V9 binds
Posted: Mon May 16, 2011 9:09 pm
Hi , I need to bind a new package in db2 v9 and would like to maintain the same options as v8 where possible.
1) However , I have noticed that the new V9 bind Option 'ROUNDING' has picked up the default value 'HALFEVEN' . Can anyone advice how this new option (default value) deviate from the V8 , which hasn't had this option ? Basically I am wondering how DB2 handle 'ROUNDING' in V8.
2) Bind option 'DEFERPREP' has been set to 'B' in V9 bind and would like to make it to 'C', similar to V8. If I change 'CURRENTDATA' to 'YES' , will that make the expected out come ?
1) However , I have noticed that the new V9 bind Option 'ROUNDING' has picked up the default value 'HALFEVEN' . Can anyone advice how this new option (default value) deviate from the V8 , which hasn't had this option ? Basically I am wondering how DB2 handle 'ROUNDING' in V8.
2) Bind option 'DEFERPREP' has been set to 'B' in V9 bind and would like to make it to 'C', similar to V8. If I change 'CURRENTDATA' to 'YES' , will that make the expected out come ?