| SQL_CHAR(n)1
|
PIC X(n)
|
|
| SQL_NCHAR(n)1
|
PIC X(n) or PIC N(n)
|
|
| SQL_VARCHAR(n)1
|
PIC X(n)
|
|
| SQL_NVARCHAR(n)1
|
PIC X(n) or PIC N(n)
|
|
| SQL_LONGVARCHAR1
|
PIC X(max) or SQL TYPE LONG-VARCHAR(max)
|
|
| SQL_NTEXT1
|
PIC X(max) or PIC N(max)
|
|
| SQL_DECIMAL(p,s) or SQL_NUMERIC(p,s)
|
PIC S9(p-s)V9(S) COMP-3
|
p = precision (total number of digits).
s = scale (number of digits after the decimal point).
OpenESQL doesn’t support using unsigned packed decimal host variables.
|
| SQL_SMALLINT
|
PIC S9(4) COMP-5
|
|
| SQL_INTEGER
|
PIC S9(9) COMP-5
|
|
| SQL_REAL
|
COMP-1
|
|
| SQL_FLOAT
|
COMP-2
|
|
| SQL_DOUBLE
|
COMP-2
|
|
| SQL_BIT
|
PIC S9(4) COMP-5
|
|
| SQL_TINYINT
|
PIC S9(4) COMP-5
|
|
| SQL_BIGINT
|
PIC S9(18) COMP-3
|
|
| SQL_BINARY(n)
|
PIC X(n) or SQL TYPE BINARY(n)
|
|
| SQL_VARBINARY(n)
|
PIC X(n) ) or SQL TYPE VARBINARY(n)
|
|
| SQL_LONVARBINARY
|
PIC X(max) or SQL TYPE LONG-VARBINARY(max)
|
|
| SQL_DATE or SQL_TYPE_DATE
|
PIC X(10) ) or SQL TYPE DATE
|
yyyy-mm-dd
|
| SQL_TIME or SQL_TYPE_TIME or SQL_SS_TIME2
|
PIC X(8) or SQL TYPE TIME or SQL TYPE TIME-RECORD
|
hh:mm:ss
|
| SQL_TIMESTAMP or SQL_TYPE_TIMESTAMP
|
PIC X(29) or SQL TYPE TIMESTAMP or SQL TYPE TIMESTAMP-RECORD
|
yyyy-mm-ddhh:mm:ss.ffffff
|
| SQL_SS_TIMESTAMPOFFSET
|
PIC X(34)
|
yyyy-mm-ddhh:mm:ss.ffffff +/-hh:mm
|
| 1For more information on using host variables with international data, particularly PIC N and PIC G host variables, see
OpenESQL Globalization Best Practices.
|
