Type Definitions and Limits

Table 4-1 displays valid type definitions 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_BIGINT	8-byte integer
CS_MONEY	Money type
CS_SMALLINT	2-byte integer
CS_TINYINT	1-byte unsigned integer
CS_SMALLINT	2-byte integer
CS_USMALLINT	2-byte unsigned integer
CS_UINT	4-byte unsigned integer
CS_UBIGINT	8-byte unsigned integer
CS_TEXT	Text type
CS_IMAGE	Image type
CS_UNICHAR	UTF16 Unicode character type
CS_UNITEXT	UTF16 Unicode text type
CS_XML	xml data

All basic ANSI type definitions are also valid in Embedded SQL.

Implementation limits

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