Application Programming Interface Guide > Built-in Procedures > SQL Definition Sets > sql SQL Definition Set
 
sql SQL Definition Set
The sql SQL definition set defines data types and constants for use with SQL procedures.
Location
/lib/types/sql
Types Tab
The Types tab contains definitions for SQL procedure data types.
Data Type Name
Base Type
BIGINT
BIGINT
BINARY
BINARY(1024)
BIT
BIT
BLOB
BLOB
BOOLEAN
BOOLEAN
CHAR
CHAR(255)
CLOB
CLOB
DATE
DATE
DECIMAL
DECIMAL(32,2)
DOUBLE
DOUBLE
FLOAT
FLOAT
INTEGER
INTEGER
INTERVAL DAY
INTERVAL DAY
INTERVAL DAY TO HOUR
INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE
INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND
INTERVAL DAY TO SECOND
INTERVAL HOUR
INTERVAL HOUR
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND
INTERVAL HOUR TO SECOND
INTERVAL MINUTE
INTERVAL MINUTE
INTERVAL MINUTE TO SECOND
INTERVAL MINUTE TO SECOND
INTERVAL MONTH
INTERVAL MONTH
INTERVAL SECOND
INTERVAL SECOND
INTERVAL YEAR
INTERVAL YEAR
INTERVAL YEAR TO MONTH
INTERVAL YEAR TO MONTH
LONGVARBINARY
VARBINARY(1024)
LONGVARCHAR
VARCHAR(2147483647)
NUMERIC
NUMERIC(32,0)
REAL
FLOAT
SMALLINT
SMALLINT
TIME
TIME
TIMESTAMP
TIMESTAMP
TINYINT
TINYINT
VARBINARY
VARBINARY(1024)
VARCHAR
VARCHAR(255)
Constants Tab
The Constants tab contains definitions for SQL procedure constants.
Constant Name
Type
Value
BOOLEAN FALSE
BOOLEAN
false
BOOLEAN TRUE
BOOLEAN
true