Page 1 of 1
How to insert the datastage Log-warnings into the oracle tab
Posted: Wed May 27, 2009 1:45 am
by vinodbp
Dear friends,
How to insert the datastage Log-warnings into the oracle table.
Thanks
Vinod
Posted: Wed May 27, 2009 2:43 am
by ArndW
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.
Posted: Wed May 27, 2009 5:49 am
by nagarjuna
get the log of the job using dsjob -logsum or dsjob -logdetail and redirect into a file .Then load that file into oracle table .
Posted: Wed May 27, 2009 4:38 pm
by ray.wurlod
Or create a DataStage job to do it. Prefer a server job because these have inbuilt stage types for reading from hashed files.
Posted: Wed Apr 14, 2010 6:11 am
by battaliou
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)