Reg:Passing sql at the run time

[pradeep_nov18]

Hi All,

I want to pass the sql statement in the runtime using parameters property in datastage.How to achieve this?

For Eg:

I want run the below sql.

delete from <Table_name> where <batch_load> = <date> in a parameters in runtime

How to perform the above,Please let me know.

Thanks for your help in Advance.

Regards..Pradeep.V

[chulett]

You just... do it. Put the whole thing in a parameter then put the parameter in the stage.

What have you tried? What problems have you encountered? I for one would not take this path and would look into using a "sql file". For whatever that is worth.