Message_handler_Issue
Posted: Wed Aug 08, 2007 3:23 pm
Hi,
I created a message handler to suppress all the rows that fail due to RI . Iam doing an insert in to a Db2 table using Db2/API stage . I am suppressing the warning SQL0530N the insert or update value of the FK is not equal to any value of parent key of the parent table SQLSTATE =23503, Datastage is providing me a messageID = TODC000085 , it is ok untill here . But my problem is it is also suppressing other Db2 warning messages . For example I have another warning message CL10112E Error in assignment . SQLSTATE = 22005 , but it is not showing nay warning messages .
My question is . Datastage will generate only one messageid for all the Db2 related warnings or it will generate different ids , How to catch the other Db2 related warnings other than RI warnings .
Thanks,
SomaRaju.
I created a message handler to suppress all the rows that fail due to RI . Iam doing an insert in to a Db2 table using Db2/API stage . I am suppressing the warning SQL0530N the insert or update value of the FK is not equal to any value of parent key of the parent table SQLSTATE =23503, Datastage is providing me a messageID = TODC000085 , it is ok untill here . But my problem is it is also suppressing other Db2 warning messages . For example I have another warning message CL10112E Error in assignment . SQLSTATE = 22005 , but it is not showing nay warning messages .
My question is . Datastage will generate only one messageid for all the Db2 related warnings or it will generate different ids , How to catch the other Db2 related warnings other than RI warnings .
Thanks,
SomaRaju.