RDBMS - ISAM Configuration Variables

(Vision/CISAM)

APPX_PD_SIGNS

Tells APPX what byte pattern to use for the sign bits of packed decimal numbers. The first hex digit signifies the bit pattern for positive numbers, and the second the bit pattern for negative numbers. The default is “CD” which is how APPX is normally distributed. Vision uses a default of “FD” which can be overridden when the vision programs are compiled. The setting of this variable affects files stored as native APPX files. It also affects the APPX EMs, which store some packed decimal information. To use a setting of “FD”, you must install a special set of APPX internal EMs, and if you have existing data in “CD” format, you must export the data, set APPX_PD_SIGNS=FD, then import the data. Note that if you are accessing Vision/CISAM files over a network using APPX/ODBC or APPX/Net, this variable must be set to the same value on both the client and the server systems.

Valid values: CD or FD

Default value: CD