CType constants

The CType constants identify the underlying column datatypes of the fields in a schema.

These constants distinguish what kind of SQL datatype the fields came from.

Note: The CType constant uses a different notation for the standard convention of the HCL Compass API enumerations. You use the following prefixes for CType constants:

For VBScript, use PD. For example: PD_C_CHAR.

For Perl, use $CQPerlExt::PD. For example, $CQPerlExt::PD_C_CHAR.


Constant	Value	Description
PD_C_CHAR	1	A CHAR data type.
PD_C_LONGVARCHAR	2	A CHAR * for a null terminated string as long as 2 Gigabytes. The actual limit depends on the database limit.
PD_C_LONGVARBINARY	3	A CHAR * but not null terminated. This comes from a database type of binary large objects and contains as much as 2 Gigabytes.
PD_C_SLONG	4	A LONG integer.
PD_C_TIMESTAMP	5	A CHAR * that holds a datetime "value.as." For example, yyyy-mm-dd or hh:mm:ss.
PD_C_DOUBLE	6	A double data type.