Page 1 of 1
Can an after job Routine Connect to Oracle Database
Posted: Thu Mar 08, 2007 6:38 pm
by nguyenh
Does ODBC work from an after job routine?
Does anybody have sample code?
Thanks
Hoa Nguyen
Posted: Thu Mar 08, 2007 6:53 pm
by kcbland
After-job routines that run shell commands can certainly run sqlplus or sqlldr, and from there, you can do just about anything.
Welcome aboard!
Posted: Thu Mar 08, 2007 6:59 pm
by ray.wurlod
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.
Posted: Thu Mar 08, 2007 10:41 pm
by chulett
How about you let us know why you are asking about this? What would you need to do 'after job' in Oracle? The 'why' behind your 'what' would let us make suggestions how best to accomplish your goal...
Can an after job Routine Connect to Oracle Database
Posted: Mon Mar 12, 2007 11:13 am
by nguyenh
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
Posted: Mon Mar 12, 2007 11:36 am
by kcbland
Write a shell script, use sqlplus and sqlldr to accomplish your goals.
Posted: Mon Mar 12, 2007 11:45 am
by DSguru2B
Do it in a job. Get all the info into a flat file and then load it into the table. You dont have to do it in the after job sub-routine.