Running a custom .sql file through DataStage

[akshyat]

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

[y_suresh]

You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option .....

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

[akshyat]

[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 ?

[avi21st]

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 ?

hi akshyat

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

[akshyat]

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 ?

hi akshyat

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

Thanks Avishek..