ITEM: BL6545L

Sql substring returning numbers for the headings.

ENV: db2/6000 v1.1, AIX ?
DESC: When customer issues a select statement with a \ function
        for a column name it returns the results correctly
        but the column heading in the result is not the
        column name used instead a number representing the position
        of the column appears. 
ACT:
Functions in a query are identified by the column number and not
the column name.  The function is not the name of the column, therefore
the number is returned.   This is working as designed.
Use the alias clause to get the desired heading instead of the numeric
when using substr function.
 db2 "select \, substr(colname, n1, n2) as \ ...




Support Line: Sql substring returning numbers for the headings. ITEM: BL6545L

Dated: December 1996 Category: N/A

This HTML file was generated 99/06/24~13:30:21

Comments or suggestions?
Contact us