SAS - IOM JDBC Driver Data Type Mapping
Seems like that there are only a few SQL data types supported in SAS 9.2 IOM JDBC driver.
For example, only CHAR, CHARACTER, VARCHAR, INT, INTEGER, SMALLINT, FLOAT, DOUBLE and DATETIME can be used in a table creation statement; therefore, the corresponding Java data types (mapped from previous SQL data types) are as well kinda lacking.
Following is the SQL/Java data type mapping table which is according to my recent test result:
|SQL Data Type||Java Data Type|
|CHAR, CHARACTER, VARCHAR||java.lang.String|
|INT, SMALLINT, FLOAT, DOUBLE||java.lang.Double|
* I really don’t know why INT and SMALLINT are mapped to Java Double, but they are!