DSXchange

Hello ArndW,
thanx for your kind suggession.i will really try to be more careful next time.
If, i will generate this query thru datastage,i think,i will not take care of my requirement as passing date at runtime,or read data from any other file .can u plz suggest me what hould i do???

I am trying to write a user defined query for oracle stage and i have to pass parameterized values for one column named audit_create_date,which i will pass at runtime.but i m getting this error...Oracle call failed; sqlcode = -1008; message: ORA-01008: not all variables bound in where clause i m pas...