How to insert the datastage Log-warnings into the oracle tab

vinodbp · Post by **vinodbp** » Wed May 27, 2009 1:45 am

Dear friends,

How to insert the datastage Log-warnings into the oracle table.

Thanks
Vinod

ArndW · Post by **ArndW** » Wed May 27, 2009 2:43 am

You can access the log messages by using DSGetLogInfo(), then those values can be written to Oracle using the normal processing stages in a job.

nagarjuna · Post by **nagarjuna** » Wed May 27, 2009 5:49 am

get the log of the job using dsjob -logsum or dsjob -logdetail and redirect into a file .Then load that file into oracle table .

ray.wurlod · Post by **ray.wurlod** » Wed May 27, 2009 4:38 pm

Or create a DataStage job to do it. Prefer a server job because these have inbuilt stage types for reading from hashed files.

battaliou · Post by **battaliou** » Wed Apr 14, 2010 6:11 am

Ok, to save you some hastle here is some code wrongly ascribed as DSGetLogInfo

Code: Select all

event_max_li = DSGetNewestLogId ( DSJ.ME , DSJ.LOGANY) - 1
event_max_le = DSGetLogEntry(DSJ.ME,event_max_li)
call DSLogInfo(event_max_le,event_max_li)