SQL Type Support by the IBM Data Virtualization Manager for z/OS interface
This section outlines the supported SQL types for IBM Data Virtualization Manager for z/OS.
| SQL Type | VSAM/ CICS VSAM | Adabas | ACI | SQL/IMS | CICS SP | IMS SP |
|---|---|---|---|---|---|---|
| SQL_Char | X | X | X | X | X | X |
| SQL_Numeric | X | X | X | X | X | X |
| SQL_Decimal | X | X | X | X | X | X |
| SQL_Bigint | ||||||
| SQL_Integer | X | X | X | X | X | X |
| SQL_Smallint | X | X | X | X | X | X |
| SQL_Float | ||||||
| SQL_Real | ||||||
| SQL_Double | ||||||
| SQL_Date | X | X | ||||
| SQL_Time | X | X | ||||
| SQL_Binary | X | X | X | X | X | X |
| SQL_Graphic | X | X | X | X | X | X |