Get column names from command line using stage name/link nam

zulfi123786 · Post by **zulfi123786** » Thu May 12, 2016 10:21 am

Hi ,

I am need to get column names using job name, stage name & link name.

The column definitions could be imported into the stage using table definitions or hand coded.

tried the dsjob but doesnt help any ideas will definitely help

Thanks

chulett · Post by **chulett** » Thu May 12, 2016 10:45 am

What exactly did you try and what about it "doesn't help"?

zulfi123786 · Post by **zulfi123786** » Thu May 12, 2016 2:14 pm

Looked into the options available with dsjob but this level of detail is not provided in the api.

Guess The column definitions should be in the universe tables, any way to get column names associated with a link from command line ?

ray.wurlod · Post by **ray.wurlod** » Thu May 12, 2016 4:46 pm

Many years ago I created a DataStage routine to reverse-engineer DDL from a DataStage table definition. So it's definitely do-able. Alas, I have long since lost the code. (It also generated IFX format.)

zulfi123786 · Post by **zulfi123786** » Sat May 14, 2016 1:54 am

Though I can't fully read it for now, Thanks for the reply Ray.

Realized my premium membership expired and its 3 days since I renewed but the same is not yet reflected