SQL Programming Manual for Pascal

Using Dynamic SQL
HP NonStop SQL Programming Manual for Pascal—528614-001
7-24
Dynamically Allocating Memory
Literals have been defined to represent these data types. Some of the more common
literals follow; for a complete list, see Section 6, Error and Status Processing.
To include the declarations for these literals, use the SOURCE command to copy the
SQLDT section of the PEXTDECS file:
?SOURCE $ volume. subvolume.PEXTDECS (SQLDT);
The literals represent values on the following continuum:
Figure 7-6 on page 7-25 shows some sample code to display a value according to its
data type.
SQLDT_ASCII_F Fixed-length character string
SQLDT_ASCII_V Variable-length character string
SQLDT_16BIT_S 16-bit signed integer
SQLDT_16BIT_U 16-bit unsigned integer
SQLDT_32BIT_S 32-bit signed integer
SQLDT_32BIT_U 32-bit unsigned integer
SQLDT_REAL 32-bit floating point
SQLDT_DOUBLE 64-bit floating point
SQLDT_64BIT_S 64-bit signed integer
SQLDT_DEC_U Unsigned ASCII numeric (DECIMAL) number
SQLDT_DEC_LSS DECIMAL number, leading sign separate
SQLDT_DEC_LSE DECIMAL number, leading sign embedded
SQLDT_DEC_TSS DECIMAL number, trailing sign separate
SQLDT_DEC_TSE DECIMAL number, trailing sign embedded
SQLDT_DATETIME DATETIME item
0 through 63 CHARACTER data
64 through 127 VARCHAR data
128 through 191 NUMERIC data
192 through 212 Date-time or
INTERVAL data