Dear friends,
How to insert the datastage Log-warnings into the oracle table.
Thanks
Vinod
How to insert the datastage Log-warnings into the oracle tab
Moderators: chulett, rschirm, roy
How to insert the datastage Log-warnings into the oracle tab
vinodkumar.b.p
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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)
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.