Converting Sybase decimal and numeric data

Use TDSNUMERIC and TDS-SYBASE-DECIMAL datatypes for Sybase Adaptive Server numeric and decimal data. These datatypes are defined as:

01 NUMDEC
    05 PRECISION PIC X(1).
    05 SCALE     PIC X(1).
    05 ARR       PIC X(33).

In the preceding example, 1 byte is for precision, 1 byte is for scale, and 33 bytes are for the packed value.

You can use conversion between these datatypes and character data. Open ServerConnect also supports conversion between these datatypes and TDS-PACKED-DECIMAL (IBM packed decimal).

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF