DSXchange

I have been trying to configure the netezza connector stage to read data in parallel. So far I have been able to achieve the following: a) Read data in parallel using an Auto query. b) Reading Data in parallel using user defined simple query. - In order to achieve this we have to use the place holde...

Netezza Database uses the concept Temporary work tables for loading the data unless we specify the load types as direct loads. Therefore your regular update expressions would not work in case of a user defined query. Netezza Connector stage provides place holders for the main table and the temporary...

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.. :lol: .I know you can do it from Datastage sequencer..after the DLR_ID got loaded ju...

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

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