Sub Select field names

[mrzepnic]

I have a sql statement that I need to either sub select or concat to create the select field. When I do this it returns the value of the concat ex.

Select concat('Hel','lo') from world

It would return Hello instead of the value for the column HELLO.

It does the same thing if I subselect from syscolumns

Select (select column_name from syscolumns) from world

Any ideas on how to do this interactively?

 

[BrianTyler]

I don't think that it is possible within DB2 itself. The only solution is to build an appication which will determine the column name needed, and then build the SQL for submission.

The application could be a complex script in UNIX / AIX, or could be a procedure building dynamc SQL.

 

[mrzepnic]

Brian,

Thanks that what I thought but, I wanted to be sure.