Hi,
I want to capture the warning messages and i have to load it in a table. if the warning is because of truncation errors, unique constraint, whatever it is? How to capture those warnings?
How to capture the warnings
Moderators: chulett, rschirm, roy
How to capture the warnings
With regards,
Xpert
Xpert
Hi,
I tried with DSGetLogSummary function, but its giving newest log only. but i want to capture all the warnings. Thanks in Advance.
I tried with DSGetLogSummary function, but its giving newest log only. but i want to capture all the warnings. Thanks in Advance.
pankajg wrote:I think you can do this by using DSGetLogSummary
U wil need to write a routine and use the function DSGetLogSummary, the result of which you can store or write to a file and then load that file into the database.
Check out the BASIC guide for more information on DSGetLogSummary.
With regards,
Xpert
Xpert
You can capture the database errors like SQL CODE and SQL ERROR from the job by extendending the reject link with these column enabled using RPC.
If you need to load the logs available from datastage, you can use dsjob -logsum/-logdetail/-lognewest functionality.
If you need to load the logs available from datastage, you can use dsjob -logsum/-logdetail/-lognewest functionality.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Depending on what stage type you are using, and how you are sending the rows to the table (upsert vs write), there may be an additional column called sqlcode on the reject link.
However, capture of all warnings is probably easiest done by post-processing the job log.
However, capture of all warnings is probably easiest done by post-processing the job log.
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.