Column, table, and other names up to 128 characters in length have been supported for some time in SQL. In Version 8.1, long names are supported in DB2 QMF for TSO/CICS. The following names are affected by this enhancement:
Names | Compatibility mode for Version 7.2 or earlier | New Function mode (NFM) |
---|---|---|
Authorization ID | FIXED CHAR(8) | VARCHAR(128) |
SQLID | FIXED CHAR(8) | VARCHAR(128) |
Table, View, Synonym and Correlation | VARCHAR(18) | VARCHAR(128) |
Column (see Note 1) | VARCHAR(18) | VARCHAR(30) |
Location (see Note 2) | VARCHAR(16) | VARCHAR(16) |
Note 1: Column names, currently described as VARCHAR(16) is extended to VARCHAR(128) in the DB2 catalog. However, Column names are limited to 30 bytes of Unicode in DB2 UDB for z/OS Version 8.1. DB2 QMF for TSO/CICS Version 8.1 supports a maximum length of 30 bytes.
Note 2: Location names, currently described as VARCHAR(16), is extended to VARCHAR(128) in the DB2 catalog. However, Location names are limited to 16 bytes of Unicode in DB2 UDB for z/OS Version 8.1. DB2 QMF for TSO/CICS Version 8.1 supports a maximum length of 16 bytes.
When DB2 UDB for z/OS Version 8.1 is running in NFM, long names in the database are supported. In all other modes, DB2 QMF for TSO/CICS Version 8.1 does not support long names in the database.
In addition to DB2 UDB for z/OS Version 8.1, the following name lengths are supported by DB2 QMF for TSO/CICS Version 8.1 when connecting to a remote server:
iSeries | UNIX and Windows | VSE & VM | z/OS | |
---|---|---|---|---|
Earlier than Version 2.0 | Version 7.1 | Version7.2 or earlier | Version 8.1 Compatibility mode or earlier | |
Schema name | 10 | 8 | 8 | 8 |
Column name | 10 | 18 | 18 | 18 |
Table name | 18 | 18 | 18 | 18 |
Version 2.0 or later | Version 7.1 | V8.1 NFM or later | ||
Schema name | 10 | 8 | 128 | |
Column name | 30 | 30 | 30 | |
Table name | 128 | 128 | 128 | |
Version 7.1 | ||||
Schema name | 30 |