DSXchange

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

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

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

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

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

avi21st wrote:

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

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..