Originally posted by: jvanboga
several ways you can handle this. Thing to keep in mind is that while great at what it does DBID is not as sophisticated as some tools.
For example.... This would give you what you are looking for you will not be able to build a type tree with it.
column column_1 name column_1,
column column_2 name column_2,
select column_1, column_2 from table_name
where condition_stmnt
This would select the names of your columns without the data and can be used in DBID
Select column_id, column_name
from user_tab_columns
where table_name='table'
order by 1
but it doesn't select the data with the column_names. Also, the columns are returned as rows.
This won't work either because the definition for the column name won't match date and numeric column definitions....
select 'column1' column1,
'column2' column2,
'column3' column3
from table1
union
select column1,
column2,
column3
from table1
Usually, what we do is define an output with an optional record/row and insert the column name in the output card.
#IBMSterlingTransformationExtender#DataExchange#IBM-Websphere-Transformation-Extender