Host Variable Data Type Declarations

The following tables list valid ALLBASE/SQL host variable data types for each supported language. FIPS 127.1 standards compliant data types are indicated with a YES. ALLBASE/SQL extensions to the standard are indicated with a NO.

Table 2-3 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for C

ALLBASE/SQL DATA TYPES	FIPS 127.1 Compliant?	C DATA DECLARATIONS
`CHAR(1)`	NO	`char``dataname``;`
`CHAR(n)`	YES	`char``dataname``[n+1];`
`VARCHAR(n)`	NO	`char``dataname``[n+1];`^[1]
`SMALLINT`	YES	`short``dataname``; or`
	NO	`short int``dataname``;`
`INTEGER`	NO	`int``dataname``; or`
	NO	`long int``dataname``; or`
	YES	`long``dataname``;`
`REAL`	YES	`float``dataname``;`
`FLOAT(1..24)`	NO	`float``dataname``;`
`FLOAT(25..53)`	NO	`double``dataname``;`
`DOUBLE PRECISION`	YES	`double``dataname``;`
`BINARY`	NO	`sqlbinary``dataname``;`
	NO	`sqlbinary``dataname``[n];`
`VARBINARY`	NO	`sqlvarbinary``dataname``[m];`^[2]
`DECIMAL`	NO	`double``dataname``;`
`DATE`	NO	`char``dataname``[11];`
`TIME`	NO	`char``dataname``[9];`
`DATETIME`	NO	`char``dataname``[24];`
`INTERVAL`	NO	`char``dataname``[21];`
^[1]This declaration is for non-dynamic statements only. Refer to the chapter, "Using Dynamic Operations," in the ALLBASE/SQL C Application Programming Guide for a description of how to use VARCHAR dynamically. ^[2]See the "BINARY Data" section in the ALLBASE/SQL C Application Programming Guide for the calculation of m.

Table 2-4 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for COBOL

SQL DATA TYPES	FIPS 127.1 Compliant?	COBOL DATA DESCRIPTION ENTRIES
`CHAR(n)`	YES	`01``DATA-NAME``PIC X(n).`
`VARCHAR(n)`	NO	`01``GROUP-NAME`.`49``LENGTH-NAME``PIC S9(9) COMP.49``VALUE-NAME``PIC X(n).`
`BINARY`	NO	`01``DATA-NAME``PIC X(n).`
`VARBINARY(n)`	NO	`01``GROUP-NAME`.`49``LENGTH-NAME``PIC S9(9) COMP.49``VALUE-NAME``PIC X(n).`
`SMALLINT`	NO	`01``DATA-NAME``PIC S9(4) COMP.`
`INTEGER`	YES	`01``DATA-NAME``PIC S9(9) COMP.`
`FLOAT`	NO	`01``DATA-NAME``PIC S9(p-s)V9(s) COMP-3.`
`DECIMAL(p,s)`	NO	`01``DATA-NAME``PIC S9(p-s)V9(s) COMP-3.or`
	YES	`01``DATA-NAME``PIC S9(p-s)V9(s) [USAGE IS] DISPLAY [SIGN IS] LEADING SEPARATE [CHARACTER].`
`DATE`	NO	`01``DATA-NAME``PIC X(10).`^[1]
`TIME`	NO	`01``DATA-NAME``PIC X(8).`^[1]
`DATETIME`	NO	`01``DATA-NAME``PIC X(23).`^[1]
`INTERVAL`	NO	`01``DATA-NAME``PIC X(20).`^[1]
^[1]Applies to default format specification only.

Table 2-5 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for FORTRAN

SQL DATA TYPES	FIPS 127.1 Compliant?	FORTRAN DATA DECLARATIONS
CHAR(1)	NO	`CHARACTER``DataName`
CHAR(n)	YES	`CHARACTERn``DataName`*
VARCHAR(n)	NO	`CHARACTERn``DataName`*^[1]
SMALLINT	NO	`INTEGER2``DataName`*
INTEGER	YES	`INTEGER``DataName`
REAL	YES	`REAL``DataName``or`
	NO	`REAL4``DataName`*
FLOAT(1..24)	NO	`REAL``DataName``or`
	NO	`REAL4``DataName`*
FLOAT(1..53)	NO	`DOUBLE PRECISION``DataName``or`
	NO	`REAL8``DataName`*
DOUBLE PRECISION	YES	`DOUBLE PRECISION``DataName``or`
	NO	`REAL8``DataName`*
BINARY	NO	`CHARACTER``DataName``or`
	NO	`CHARACTERn``DataName`*
VARBINARY	NO	`CHARACTERn``DataName`*
DECIMAL	NO	`DOUBLE PRECISION DataName or`
	NO	`REAL8``DataName`*
DATE	NO	`CHARACTER10``DataName`*
TIME	NO	`CHARACTER8``DataName`*
DATETIME	NO	`CHARACTER23``DataName`*
INTERVAL	NO	`CHARACTER20``DataName`*
^[1]This declaration is for non-dynamic statements only.

Table 2-6 ALLBASE/SQL FIPS 127.1 Compliant Data Type Declarations for Pascal

SQL DATA TYPES	FIPS 127.1 Compliant?	PASCAL TYPE DESCRIPTION
`CHAR(1)`	NO	`DataName` `: char;`
`CHAR(n)`	NO	`DataName` `: array [1..n] of char; or`
	YES	`DataName` `: packed array [1..n] of char;`
`VARCHAR(n)`	NO	`DataName` `: string[n];`
`BINARY(1)`	NO	`DataName` `: char;`
`BINARY(n)`	NO	`DataName` `: array [1..n] of char; or`
	NO	`DataName` `: packed array [1..n] of char;`
`VARBINARY(n)`	NO	`DataName` `: string[n];`
`SMALLINT`	NO	`DataName` `: smallint;`
`INTEGER`	YES	`DataName` `: integer;`
`REAL`	YES	`DataName` `: real;`
`FLOAT`	NO	`DataName` `: longreal;`
`DECIMAL`	NO	`DataName` `: longreal;`
`DATE`	NO	`DataName` `: packed array[1..10] of char;`^[1]
`TIME`	NO	`DataName` `: packed array[1..8] of char;`^[1]
`DATETIME`	NO	`DataName` `: packed array[1..23] of char;`^[1]
`INTERVAL`	NO	`DataName` `: packed array[1..20] of char;`^[1]
^[1]Applies to default format specification only.

Host Variable Data Type Declarations

Technical documentation

» Table of Contents

» Index