Constants for ESQL/C data types

The sqltypes.h header file contains defined constants for the Informix® ESQL/C data types.

The Informix ESQL/C data types are assigned to host variables in the Informix ESQL/C program. If your program initializes a column description, it usually obtains the column value from the Informix ESQL/C host variable. To set the column data type for this value, the program must use the Informix ESQL/C data types.

The following code fragment shows only some of the Informix ESQL/C data type entries in the sqltypes.h header file. For a complete list of constants for Informix ESQL/C data types, see Constants for Informix SQL column data types.

#define CCHARTYPE             100
#define CSHORTTYPE            101
#define CINTTYPE              102
#define CLONGTYPE             103
#define CFLOATTYPE            104
#define CDOUBLETYPE           105

Within the Informix ESQL/C program that uses dynamic SQL statements, you can use the constants that are shown in preceding code fragment to set the data types of the associated host variables. Use the Informix ESQL/C data type constants to set the data types of host variables used as input parameters to a dynamically defined SQL statement or as storage for column values that are returned by the database server. A sample program that executes a dynamic INSERT statement stores a TEXT value into a database table.