ORCHESTRATE reference in SQL File

jerome_rajan · Post by **jerome_rajan** » Wed Oct 08, 2014 11:21 pm

Hi,

Is it possible to reference to a column in the DataStage metadata using ORCHESTRATE.column_name in a SQL file containing an insert statement in a target oracle connector stage?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2014 11:43 pm

Don't know.

Have you tried it?

My guess would be that it is OK, since the SQL file is simply read to become the SQL Statement property value.

jerome_rajan · Post by **jerome_rajan** » Wed Oct 08, 2014 11:56 pm

Thanks Ray.

Just tried it after your reply. It worked!