Page 1 of 1

Appending Multiple column names

Posted: Thu Jan 31, 2008 8:24 am
by MOHAMMAD.ISSAQ
I'm using DS server 7.1 version on Unix environment.
I want to append multiple coulmn names into a single.
Say for e.g:
Input Col Output Col
a e
b
c
d
where the value of e=a:b:c:d
Since in Input have nearly 2000 columns it's a daunting task to append the column names.
Can anybody suggest me a simple way of doing this?

Thanks in advance

Posted: Thu Jan 31, 2008 8:35 am
by ray.wurlod
Daunting, tedious, but not difficult. Suggestion, build a few at a time in stage variables: there is an upper limit on the length of an expression.

And beware of nulls.

Posted: Thu Jan 31, 2008 9:05 am
by MOHAMMAD.ISSAQ
Thanks ray for suggestion.
I found one solution for copying column names.
If we create one sequential file job and "include column name as header" we'll get all the columns names.

Posted: Thu Jan 31, 2008 9:28 am
by kcbland
I absolutely thought you were doing an ETL exercise just like Ray. You were looking to get the list of columns in metadata for some reason. You've got yourself a reasonable solution.