How to use ORCHESTRATE in presql

[bgs_vb]

Hi ,
We have created a parallel job using Teradata connector stage as target ,sequential file as source stage .

We need to delete few records using presql before loading the data.
Delete from table where col1=orchestrate.col1 .

But job is aborting with error as "Object 'ORCHESTRATE' does not exist."

How do we use orchestrate in presql in teradata ?

[prasson_ibm]

Hi,
I came to understand that we cant use ORCHESTRATE in Pre/Post sql statement since it Pre/Post sql statement executes once for stage and Orchestate will execute for each and every row processed.

[chulett]

You can't leverage any "row data" in the pre or post areas, which is basically what you are trying to do. You'd either need to hard-code any values there or perhaps use job parameters to control what values get deleted.

So what kind of "few records" do you need to delete?

[rameshrr3]

If you are doing an insert , Can you try the "Delete Before Insert" Action in the "Write Mode" property ? That may allow you to use row values ( probably auto generated SQL)

[prasannakumarkk]

To add to this make sure you make the column as key based on which records are to be deleted before insert