Type Definitions and Limits

The following type definitions are valid in Embedded SQL:

Table 4-1: Valid typedefs

Typedef

Description

CS_BINARY

Binary type

CS_BIT

Bit type

CS_CHAR

Character type

CS_DATE

Date type

CS_TIME

Time type

CS_DATETIME

Datetime type

CS_FLT8

8-byte float type

SQLINDICATOR

Used for indicator variables (2-byte integer)

CS_INT

4-byte integer

CS_MONEY

Money type

CS_SMALLINT

2-byte integer

CS_TINYINT

1-byte integer

CS_SMALLINT

Unsigned 2-byte integer

CS_TEXT

Text type

CS_IMAGE

Image type


Implementation limits

The nesting depth for exec sql include filename limit is 32.