I have the following requirement:
i have a perl script generating a list of values in a file as output. these values are available under one field in the file. i want to send this field (along with values) as a column in the column list while using select clause on some table. the select clause also contains one/more other columns in the column clause. Th select clause may appear like this:
select col1,col2,'#parameter# from table1;
here the parameter is nothing but the file having some distinct list of values.
please let me know if any other information is required
how to select column dynamically
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Mar 07, 2008 1:17 am
how to select column dynamically
ETL DEVELOPER
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: how to select column dynamically
Why?datastagedw wrote:I have the following requirement:
...
please let me know if any other information is required
What is it meant to achieve?
A list of constant values in a SELECT statement will generate those constants for every row selected.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.