The numeric ESL data types are:
EDS_INT
EDS_FLOAT
The following table shows the SQL data types to which these data types may be converted. For an explanation of the columns and terms in the table, see Converting Data from ESL to SQL Data Types.
SQLTYPE |
Test |
SQL STATE |
EDS_SQL_DECIMAL EDS_SQL_NUMERIC EDS_SQL_TINYINT EDS_SQL_SMALLINT EDS_SQL_INTEGER EDS_SQL_BIGINT EDS_SQL_REAL EDS_SQL_FLOAT EDS_SQL_DOUBLE |
Data converted without truncation |
00000 |
Data converted with truncation, but without loss of significant digits |
22001 |
|
Conversion of data would result in loss of significant digits |
22003 |
|
EDS_SQL_BIT |
Data value is 0 or 1 |
00000 |
Data value is not 0 or 1 |
22003 |
