DB2 graphic  QMF Version 8

Support for long names

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:

Table 2. Long names chart
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:

Table 3. Long name lengths supported 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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004