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
Reg:Passing sql at the run time
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
Reg:Passing sql at the run time
pradeep.v
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers