GENERATING ERROR CODES

[ravindrag]

i have 63 columns in my source, i have to generate an error code if the source feild contain a null value then i have to check for other logics and generate errorcodes accordingly.

i have created two stage variables for each column stag1 to check if the record is null or not in stag2 if stag1 is notnull then i will check for other logics and i will generate the codes . finally after creating all stage variables i will use all these variables in one variable and use this variable in rejectdetail column in rejecttable.

my problem is that in reject record i am getting only few codes repeatedly , i.e same code ex..xx23 is comming 32 times but it should come only once as every code is unique . i have created a sequential file and passed all the stage variables to it here codes are comming properly but in record detail this is not comming.

Is there any other way to do it?


Thanks in advance

[ray.wurlod]

Almost certainly, but there's not enough information in your post to suggest better mechanisms.

Stage variables are evaluated for every row processed, so it's not surprising that there are repeats - a null in a new row in the same column will generate a repeat (if I read your specification correctly).