Hi
I have the following environment as mentioned above with DB2 as the database.
I need to run custom .sql files from within the datastage environment without invoking any shell or script.
Is there a way to do it?
Thanks in advance for your support
Akshyat
Running a custom .sql file through DataStage
Moderators: chulett, rschirm, roy
Re: Running a custom .sql file through DataStage
You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option .....
akshyat wrote:Hi
I have the following environment as mentioned above with DB2 as the database.
I need to run custom .sql files from within the datastage environment without invoking any shell or script.
Is there a way to do it?
Thanks in advance for your support
Akshyat
Re: Running a custom .sql file through DataStage
[quote="y_suresh"]You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option .....
Using this option can I load any sql file as a parameter from any directory on my server box ?
Using this option can I load any sql file as a parameter from any directory on my server box ?
@AXE
Re: Running a custom .sql file through DataStage
hi akshyatakshyat wrote:y_suresh wrote:You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option .....
Using this option can I load any sql file as a parameter from any directory on my server box ?
for your project.. .I know you can do it from Datastage sequencer..after the DLR_ID got loaded just call the custome SQL script from a Datastage Execute Activity...
let me know you have any problem
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
Re: Running a custom .sql file through DataStage
Thanks Avishek..avi21st wrote:akshyat wrote:hi akshyaty_suresh wrote:You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option .....
Using this option can I load any sql file as a parameter from any directory on my server box ?
for your project.. .I know you can do it from Datastage sequencer..after the DLR_ID got loaded just call the custome SQL script from a Datastage Execute Activity...
let me know you have any problem
@AXE