Page 1 of 1

ORCHESTRATE reference in SQL File

Posted: Wed Oct 08, 2014 11:21 pm
by jerome_rajan
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?

Posted: Wed Oct 08, 2014 11:43 pm
by ray.wurlod
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.

Posted: Wed Oct 08, 2014 11:56 pm
by jerome_rajan
Thanks Ray.

Just tried it after your reply. It worked!