SQL data types specific to Informix

The SQL data types specific to HCL Informix® are available to a column in the Informix database.

The HCL Informix Guide to SQL: Reference describes these data types. If you do not include the -xopen option when you compile your Informix ESQL/C program, the DESCRIBE statement uses these data types to specify the data type of a column or the return value of a user-defined function. Constants for these Informix SQL data types are defined in the Informix ESQL/C sqltypes.h header file.

The following figure shows some of the SQL data type entries in sqltypes.h.

Figure 1. Some Informix SQL data type constants

#define SQLCHAR          0
#define SQLSMINT         1
#define SQLINT           2
#define SQLFLOAT         3
#define SQLSMFLOAT       4
#define SQLDECIMAL       5
#define SQLSERIAL        6
#define SQLDATE          7
#define SQLMONEY         8
⋮

For a complete list of constants for SQL data types, see Table 1. The integer values in Figure 1 are language-independent constants; they are the same in all HCL Informix embedded products.