How to pull column name(s) along with the associated data

[satish_valavala]

Hi All,

I need to pull column name(s) along with the associated data for look-up column name(s) with a static look-up table and get corresponding match ID to populate source data and look-up ID to target table.

I appreciate your inputs.

Thanks
VS

[gateleys]

Can you please try to rephrase your question? It just did not make any sense to me...and I would guess, to many others (the fact that you have not received any response until now).

[ray.wurlod]

Good luck finding a tool. Dynamic metadata is not supported in DataStage server jobs.

There are workarounds, of course, such as generating entire SQL statements into job parameters. But not on a row-by-row basis, which is what your question seems to require.