Previous Topic: Defining Host VariablesNext Topic: Defining Bulk Structures


Including Tables

You include an SQL table in a CA ADS dialog by specifying the table on the WORK RECORD screen of ADSC.

ADSC creates host variable structures using these data type equivalents when directed to include a table on the Work Record Screen:

CA IDMS data type

Data type in included table

BINARY(n)

PIC X(n)

CHARACTER(n)

PIC X(n)

VARCHAR(n)

-LEN PIC S9(4) COMP

-TEXT PIC X(n)

GRAPHIC(n)

PIC G(n) DISPLAY-1

VARGRAPHIC(n)

-LEN PIC S9(4) COMP

-TEXT PIC G(n) DISPLAY-1

DECIMAL(p,s)

PIC S9(p-s)V9(s) COMP-3

UNSIGNED DECIMAL(p,s)

PIC 9(p-s)V9(s) COMP-3

NUMERIC(p,s)

PIC S9(p-s)V9(s) DISPLAY

UNSIGNED NUMERIC(p,s)

PIC 9(p-s)V9(s) DISPLAY

DOUBLE PRECISION

COMP-2

FLOAT(n) where

n <= 24

n > 24

 

COMP-1

COMP-2

REAL

COMP-1

DATE

PIC X(10)

TIME

PIC X(8)

TIMESTAMP

PIC X(26)

SMALLINT

PIC S9(4) COMP

INTEGER

PIC S9(8) COMP

LONGINT

PIC S9(18) COMP

Indicator variable

PIC S9(4) COMP or PIC S9(8) COMP

TID

PIC X(8)