DB2 Server for VM: System Administration


Migrating from Version 3 Release 4

Considerations for Assembler Even Precision Packed Decimal

Prior to Version 3 Release 5, assembler host variables declared as even precision packed decimal were converted to odd precision by the preprocessor. As of Version 3 Release 5, the database manager supports assembler host variables defined as even precision packed decimal, and they are not converted to odd precision. In some cases, the lack of conversion may cause a datatype mismatch between a host variable and a column. To prevent potential performance degradation, applications affected by this change should be modified so the datatypes of the host variables exactly match the datatypes of the columns to which they will be compared.

Considerations for SQLSTATE Changes for SQL92 Support

The SQLSTATEs returned by several conditions were changed to comply with SQL92. Application programs that have a dependency on the SQLSTATE returned may be affected by these changes. See DB2 Server for VM Messages and Codes for information on the changed SQLSTATEs.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]