Re: [EXTERNAL] DB2 :SQL is returning the alternative names instead of column names

What exactly do you want to achieve?

1. If you want a query that returns the column names of a table, or the field names of a file, then you can do the following.

SELECT DISTINCT
SYS_CNAME
FROM
QSYS2.SYSCOLUMNS
WHERE
TABLE_NAME = 'myfile';

The above works for both DB2 for i tables and DB2 for i files.

2. If you want a query that returns data, and you want the system field names as column labels, then one option is to define the labels for each column in the SELECT statement.

Suppose you have a table with three columns in it. Don't use SELECT *. Do something like this instead:

SELECT
MYCOLMA AS MYCOLMA,
MYCOLMB AS MYCOLMB,
MYCOLMC AS MYCOLMC
FROM
MYLIB.MYFILE;

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
217-773-4486 ext. 12676
www.dotfoods.com