DSXchange

Hi,
How to write a user defined query in ODBC stage, I know there is user defined option, Here are the details, I have A, B, C columns from the source link and I need to delete the records in target table having col X,Y Z, P, Q, R using where condition X =A and Y=B and Z<=C.

Thanks,
Rgr

The best way? Let the stage generate it so you get the bind parameters correct and then... tweak it.

You don't even need user-defined SQL for this. Simply use DataStage to filter the rows needing deleting) and pass them to a straightforward DELETE in the target stage.

Thank you craig and ray, I used user defined query as suggested by you.

As Ray noted - best practice is to only use "user-defined" SQL when you have no other choice, otherwise let the stage generate the SQL. A "normal" delete will work just fine for this.