Gurus,
We have error table structure as below.
KEY
SRC_CLM_NM
SEVERITY_FLG
ERR_DESC
We are planning to reject the error to error table for invalid data or databease rejects. The problem is we need seperate row for each data problem i.e. a row got rejected due to 3 reasons like invalid date, key not found in lookup etc for this scenario there should be 3 entries in error table.
I'm able to make a sigle entry in DB with concatinating the errors in ERR desc column with message like error1:| :error2 etc.
But we need every error to be in seperate row. I tried using the field function but then we do not know how many errors will be there at run time and also its not working as expected as for err_desc column i can have one derivation only.
Regards,
Error Handling
Moderators: chulett, rschirm, roy
But its one row the i.eArndW wrote:Pivot stage would solve this nicely
key src ERR_DESC
1 ABCD ERR1: ERR2:ERR3
To convert to
1 ABCD ERR1
1 ABCB ERR2
1 ABCD ERR3
And ERR_DESC columns error are decides on run time , we do not know how many errors will be there in a row at time of processing it may be 1 0r 10.
Regards,