Previous Topic Next topic Print topic


SQLVAR Elements

Restriction: This topic applies to Windows environments only.
COBOL Name C Name PL/I Name Data Type Usage in DESCRIBE and PREPARE INTO Usage in FETCH, OPEN or EXECUTE
SQLTYPE sqltype sqltype smallint Code indicating the data type of the column and if null values are allowed. See the table in SQLTYPE Values for SQLTYPE codes. Indicates the data type of a host variable and if an indicator variable is provided. See the table in SQLTYPE Values for SQLTYPE codes.
SQLLEN sqllen sqllen smallint Indicates the length attribute of the columns. For date/time columns, the length of the string representation of the value is used. See the table under SQLLEN Values for SQLLEN values. Indicates the length attribute of the host variable. See the table under SQLLEN Values for SQLLEN values.
SQLDATA sqldata sqldata pointer to a buffer Contains the CCSID indicator for bit data Format is x'0000'zzzz' where zzzz is X'FFFF' Contains the address of the host variable.
SQLIND sqlind sqlind pointer Undefined. Contains the address of an associated indicator variable if SQLTYPE is odd.
SQLNAME sqlname sqlname char(30) Name of the column (or a string of length zero if no name exists). Not used in XDB Server.

More:

Previous Topic Next topic Print topic