SQLTYPE Values

Restriction: This topic applies to Windows environments only.

The meanings of SQLTYPE values depend on the type of statement executed, as shown in the table below. The following differences should be noted:

For DESCRIBE and PREPARE
The codes for DB2 mode differ depending on whether or not null values are allowed in the column. An even value for SQLTYPE indicates that the column does not allow nulls. An odd value indicates that the column does allow nulls. In XDB mode, the codes do not differ.

For FETCH, OPEN and EXECUTE

Codes differ depending on whether or not indicator variables are provided for use with the host variable. An even value for SQLTYPE means no indicator variable is provided, an odd value indicates that SQLIND contains the address of an indicator variable.

In addition, because host variables do not include DATE, TIME or TIMESTAMP data types, these values are usually retrieved using fixed length character strings.

Data Type	DESCRIBE & PREPARE	FETCH, OPEN & EXECUTE
	DB2 Mode:	XDB Mode	No Indicator	Indicator
	date (See note 1.)	XDB Mode	No Indicator	Indicator	384	385	4	384	385
time (See note 1.)	388	389	7	388	389
timestamp (See note 1.)	392	393	11	392	393
varying-length character string	448	449	9	448	449
fixed-length character string	452	453	6	452	453
long varying length character string	456	457	10	456	457
varying length graphic string	464	465	17	464	465
fixed length graphic string	468	469	16	468	469
long varying length graphic string (See note 2.)	472	473	22	472	473
floating point	480	481	3	480	481
packed decimal	484	485	8	484	485
money	484	485	5	484	485
large integer	496	497	2	496	497
small integer	500	501	1	500	501

Table Notes:

For host variable, a fixed-length character string representation of the date, time or timestamp is used.
For host variable, a long graphic string.