X/Open data type constants
If your programs conform to the X/Open standards (compile
with the -xopen option), you must use the data type values
that the following table shows. HCL
OneDB™ defines
the constants for these values in the sqlxtype.h header
file.
| SQL data type | Defined constant | X/Open integer value |
|---|---|---|
| CHAR | XSQLCHAR | 1 |
| DECIMAL | XSQLDECIMAL | 3 |
| INTEGER | XSQLINT | 4 |
| SMALLINT | XSQLSMINT | 5 |
| FLOAT | XSQLFLOAT | 6 |