The global constants for the Structured Query Language (SQL) are listed in the following table. The SQL global constants are for internal use only.
Global Constant | Integer Value |
---|---|
SQL_COLLECTION | 3 |
SQL_COLLECTION_METHOD | 7 |
SQL_EXPLICIT_INVERSE | 4 |
SQL_IMPLICIT_INVERSE | 5 |
SQL_INVALID | 0 |
SQL_METHOD | 2 |
SQL_PROPERTY | 1 |
SQL_TYPE_BIGINT | -5 |
SQL_TYPE_BINARY | -2 |
SQL_TYPE_BIT | -7 |
SQL_TYPE_CHAR | 1 |
SQL_TYPE_DATE | 9 |
SQL_TYPE_DATE_VERSION3 | 91 |
SQL_TYPE_DECIMAL | 3 |
SQL_TYPE_DOUBLE | 8 |
SQL_TYPE_FLOAT | 6 |
SQL_TYPE_INTEGER | 4 |
SQL_TYPE_INTERVAL_DAY_TO_SEC | 110 |
SQL_TYPE_LONGVARBINARY | -4 |
SQL_TYPE_LONGVARCHAR | -1 |
SQL_TYPE_NULL | 0 |
SQL_TYPE_NUMERIC | 2 |
SQL_TYPE_OID | -50 |
SQL_TYPE_REAL | 7 |
SQL_TYPE_SMALLINT | 5 |
SQL_TYPE_TIME | 10 |
SQL_TYPE_TIMESTAMP | 11 |
SQL_TYPE_TIMESTAMP_VERSION3 | 93 |
SQL_TYPE_TIME_VERSION3 | 92 |
SQL_TYPE_TINYINT | -6 |
SQL_TYPE_VARBINARY | -3 |
SQL_TYPE_VARCHAR | 12 |
SQL_TYPE_WCHAR | -8 |
SQL_TYPE_WLONGVARCHAR | -10 |
SQL_TYPE_WVARCHAR | -9 |
SQL_XKEYDICT | 6 |