DSXchange

Hi,

Is it possiable to connect to the oracle database and run squl script using routines available in datastage?

Advance Thanks.

Regards,
Vinodhraj

You can executed OS commands, scripts, and programs by using the DSExecute API from a routine. Just execute sqlplus and pass it the script name. Stick to sqlplus via sqlnet and avoid ODBC because licensing is not supported for usage outside a transformation job.