Using INCLUDE TABLE

Output of INCLUDE TABLE

The CA IDMS precompiler uses these data type equivalents when directed by an INCLUDE TABLE statement to create a host variable declaration.

CA IDMS data type	PL/I data type on INCLUDE TABLE
BINARY(n)	CHAR (n)
CHARACTER(n)	CHAR (n)
VARCHAR(n)	CHAR (n) VAR
GRAPHIC(n)	GRAPHIC (n)
VARGRAPHIC(n)	GRAPHIC (n) VAR
DECIMAL(p,s)	FIXED DECIMAL (p,s)
UNSIGNED DECIMAL(p,s)	FIXED DECIMAL (p,s)
NUMERIC(p,s)¹	FIXED DECIMAL (p,s)
UNSIGNED NUMERIC(p,s)	FIXED DECIMAL (p,s)
DOUBLE PRECISION	FLOAT BINARY (53)
FLOAT (n) where n <= 24 where n > 24	FLOAT BINARY (21) FLOAT BINARY (53)
REAL	FLOAT BINARY (21)
DATE	CHAR (10)
TIME	CHAR (8)
TIMESTAMP	CHAR (26)
SMALLINT	FIXED BINARY (15)
INTEGER	FIXED BINARY (31)
LONGINT	FIXED BINARY (31)
SQLIND	FIXED BINARY (31)
TID	CHAR(8)

Default Structure

The default structure created by the INCLUDE statement has these features:

A level 1 element for the table
A level 2 subordinate element named for each table column, defined with the equivalent program language data type
An additional level 2 element, with the suffix '_I', for each column that allows null values, to be available as an indicator variable
If you specify a table without a schema name qualifier, you must supply a schema name with a precompiler option in the JCL.

Note: For more information about precompiler options, see Precompiler Directives.