SQL data types.
Syntax
_SQLTYPES_datatype( )
| datatype |
Description |
|
BIGINT
|
BigInteger |
|
BINARY
|
Binary |
|
BIT
|
Bit |
|
CHAR
|
Character |
|
DATE
|
Date |
|
DECIMAL
|
Decimal |
|
DOUBLE
|
Double |
|
FLOAT
|
Float |
|
INTEGER
|
Integer |
|
LONGVARBINARY
|
Long Variant Binary |
|
LONGVARCHAR
|
Long Variant Character |
|
NULL
|
Null |
|
NUMERIC
|
Numeric |
|
OTHER
|
Other |
|
REAL
|
Real |
|
SMALLINT
|
Small Integer |
|
TIME
|
Time |
|
TIMESTAMP
|
Timestamp |
|
TINYINT
|
Tiny Integer |
|
VARBINARY
|
Variant Binary |
|
VARCHAR
|
Variant Character |
Returns
|
integer
|
representing the data type.
|
Example
cs.registerOutParameter(1, _SQLTYPES_VARCHAR( ))
|