user defined query in odbc

rgr · Post by **rgr** » Thu Jul 26, 2012 6:05 pm

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

chulett · Post by **chulett** » Thu Jul 26, 2012 6:45 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Jul 27, 2012 5:19 pm

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.

rgr · Post by **rgr** » Fri Jul 27, 2012 5:23 pm

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

chulett · Post by **chulett** » Fri Jul 27, 2012 8:59 pm

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.