The following table lists the changes to the columns returned by SQLColumns() from version 2.1.1 to version 5.
For the current values see Table 37.
To have DB2 CLI behave at it did for version 2 (same column names and
order), set the DB2 CLI/ODBC configuration keyword PATCH2. See "How to Set CLI/ODBC Configuration Keywords" for more information on how to set this keyword.
Table 186. Changes to Columns Returned By SQLColumns
| Version 2 Column | Version 5 Column | Change |
|---|---|---|
| 14 DATETIME_CODE | Removed for version 5 | This information is no longer returned. It was always NULL for version 2. |
| No version 2 equivalent | 14 SQL_DATA_TYPE | This information was not returned in version 2. |
| No version 2 equivalent | 15 SQL_DATETIME_SUB | This information was not returned in version 2. |
| 15 CHAR_OCTET_LENGTH | 16 CHAR_OCTET_LENGTH | The column number has changed, but the name and description remain the same. |
| 16 ORDINAL_POSITION | 17 ORDINAL_POSITION | The column number has changed, but the name and description remain the same. |
| 17 IS_NULLABLE | 18 IS_NULLABLE | The column number has changed, but the name and description remain the same. |