Hi,
Is it possiable to connect to the oracle database and run squl script using routines available in datastage?
Advance Thanks.
Regards,
Vinodhraj
Connect to Oracle Database and run sql script in routine
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle