Finding Record processed status

iamnagus · Post by **iamnagus** » Mon Dec 17, 2007 3:39 am

I have 10 records in input file.

I extracted using sequential file stage and kept into another sequential file stage.

I want to find the Record Status for all records.

for ex, if a record is processed with Warnings it should be flagged as 'W'
if a record is processed with Errors then it should be flagged as 'E'
if a record is processed successfully then it should be flagged as 'N'.

in the target there should be another extra column(Ex: Record_Status) with the status of the records 'W','E','N'.

How to perform this process in datastage server eddition?

how to get the solution can any explain this?

Regards..

ArndW · Post by **ArndW** » Mon Dec 17, 2007 4:29 am

You will need to explain how you classify an "E"rror or a "W"arning or "N" type of record. A specific example might go a long way in helping you get an answer.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 17, 2007 5:27 am

Several examples, indeed. What does it mean that a record is "processed successfully"? (That is, what business rules are being validated?) Under what - presumably different - scenarios does a warning or an error get generated? The typical answer will be to record the test results in stage variables, and combine them using other stage variables. But if you need something more complex, such as dynamic late-bound business rules that in turn depend upon the data values, then clearly a more complex solution involving one or more routines will be required.