Description

ALIAS
Specifies that the label is for an alias. Labels on aliases are implemented as system object text.
alias-name
Identifies the alias to which the label applies. The name must identify an alias that exists at the current server.
COLUMN
Specifies that the label is for a column. Labels on columns are implemented as system column headings or column text. Column headings are used when displaying or printing query results.
table-name.column-name or view-name.column-name
Identifies the column to which the label applies. The table-name or view-name must identify a table or view that exists at the current server, but must not identify a global temporary table. The column-name must identify a column of that table or view.
TEXT
Specifies that i5/OS column text is specified. If TEXT is omitted, a column heading is specified.
INDEX
Specifies that the label is for an index. Labels on indexes are implemented as system object text.
index-name
Identifies the index to which the label applies. The name must identify an index that exists at the current server.
PACKAGE
Specifies that the label is for a package. Labels on packages are implemented as system object text.
package-name
Identifies the package to which the label applies. The name must identify a package that exists at the current server.
VERSION version-id
version-id is the version identifier that was assigned to the package when it was created. If version-id is not specified, a null string is used as the version identifier.
SEQUENCE
Specifies that the label is for a sequence. Labels on sequences are implemented as system object text.
sequence-name
Identifies the sequence on which you want to add a label. The sequence-name must identify a sequence that exists at the current server.
TABLE
Specifies that the label is for a table or a view. Labels on tables or views are implemented as system object text.
table-name or view-name
Identifies the table or view on which you want to add a label. The table-name or view-name must identify a table or view that exists at the current server, but must not identify a global temporary table.
IS
Introduces the label you want to provide.
string-constant
Can be any SQL character-string constant of up to either 50 bytes in length for tables, views, aliases, SQL packages, sequences, or column text, or 60 bytes in length for column headings. The constant may contain single-byte and double-byte characters.

The label for a column heading consists of three 20-byte segments. Interactive SQL, the Query/400 program, IBM DB2 Query Manager and SQL Development Kit for iSeries, and other products can display or print each 20-byte segment on a separate line. If the label for a column contains mixed data, each 20-byte segment must be a valid mixed data character string. The shift characters must be paired within each 20-byte segment.