ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 431
SQL Statements E - R
GENPLAN
Table 11-2. GENPLAN WITH Clause Data Types — Pascal
Pascal Host Variable Data Type Declaration GENPLAN WITH Clause SQL Data Type
DataName : char; CHAR
DataName : array [1.. n ] of char; CHAR(n)
DataName : packed array [1.. n ] of char; CHAR(n)
DataName : string[ n ]; VARCHAR( n )
DataName : smallint; SMALLINT
DataName : integer; INTEGER
DataName : longreal; FLOAT
DataName : real; REAL
Table 11-3. GENPLAN WITH Clause Data Types — FORTRAN
FORTRAN Host Variable Data Type
Declaration
GENPLAN WITH Clause SQL Data Type
CHARACTER DataName CHAR
CHARACTER*n DataName CHAR(n)
INTEGER*2 DataName SMALLINT
INTEGER DataName INTEGER
REAL DataName REAL
REAL*4 DataName REAL
DOUBLE PRECISION DataName FLOAT
REAL*8 DataName FLOAT