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 TypeJava Data Type
DATETIMEjava.sql.Timestamp
INTEGERjava.lang.Integer
CHAR, CHARACTER, VARCHARjava.lang.String
INT, SMALLINT, FLOAT, DOUBLEjava.lang.Double

* I really don’t know why INT and SMALLINT are mapped to Java Double, but they are!

19 Notes/ Hide

  1. cekstechnotes posted this