IMS - DBD (database description)
A database description defines an IMS database. To increase the available data type, merge a COBOL map with the database description.
| Data definition | SQL type | Host format |
|---|---|---|
| TYPE=C - Alphanumeric | SQL_Char | Character |
| TYPE =X - Hexadecimal | SQL_Binary | Binary |
| TYPE=P - Packed Decimal | SQL_Decimal | Packed Decimal |
| TYPE=F - Binary Fullword Note: Only valid for MSDB databases.
|
SQL_Integer | Integer |
| TYPE=H - Binary Halfword Note: Only valid for MSDB databases.
|
SQL_Smallint | Smallint |