Does ODBC work from an after job routine?
Does anybody have sample code?
Thanks
Hoa Nguyen
Can an after job Routine Connect to Oracle Database
Moderators: chulett, rschirm, roy
After-job routines that run shell commands can certainly run sqlplus or sqlldr, and from there, you can do just about anything.
Welcome aboard!
Welcome aboard!
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ODBC (BCI) functions can be called from before/after subroutines.
However, you will find that the Data Direct ODBC drivers that ship with DataStage are not licensed for this, so you would need to purchase valid licensing for the ODBC drivers. This is not cheap.
However, you will find that the Data Direct ODBC drivers that ship with DataStage are not licensed for this, so you would need to purchase valid licensing for the ODBC drivers. This is not cheap.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Can an after job Routine Connect to Oracle Database
Hi,
We need routine that be able to connect to an Oracle database so it can do insert/update into the a set of process control tables. These table will historically store info. about the process: job name, job id, start time, end time...etc...etc.
Thanks,
Hoa Nguyen
We need routine that be able to connect to an Oracle database so it can do insert/update into the a set of process control tables. These table will historically store info. about the process: job name, job id, start time, end time...etc...etc.
Thanks,
Hoa Nguyen