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) |
|
Copyright © 2013 CA.
All rights reserved.
|
|