Page 2 of 2

Re: Syntax Error

PostPosted: Tue Dec 21, 2010 10:41 pm
by Frank Yaeger
SAVE will include any record that was not written to another file. If SAVE gives you no records, then all of the records were written to other files. You can check that.

Again, your conditions are not necessarily mutually exclusive, so a record may be written to more than one output file. You need to check that out and figure out what you really want.

You still haven't done a good job of explaining the rules for each output file, so I can't help you figure out the correct conditions for REPORT07, but I suspect SAVE won't do it based on what you want there.

Re: Syntax Error

PostPosted: Wed Dec 22, 2010 12:20 am
by xboss
Well Frank, this is the only requirements that I got from my manager, I have no idea what made you look this so ambigious


Create 6 error reports that will be sent to the merchant and 1
valid data report (which has all the records without errors)

REPORT1 - Title: Sentinel Error Report
Records without '#F' starting in first column or '?' in column 54
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT1)

REPORT2 - Title: PAN non-Numeric Error Report
Records with any non-numeric in column 6 through 21
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT2)

REPORT3 - Title: Expiration Date non-Numeric Error Report
Records with any non-numeric in column 49 through 52
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT3)

REPORT4 - Title: Sale Amount non-Numeric Error Report
Records with any non-numeric in column 55 through 58 (dollars)
Records with any non-numeric in column 60 through 61 (cents)
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT4)



REPORT5 - Title: Merchant Transaction Number non-Numeric Error Report
Records with any non-numeric in column 63 through 67
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT5)

REPORT6 - Title: Date & Time non-Numeric Error Report
Records with any non-numeric in column 69 through 79
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT6)

REPORT7 - Title: Valid Data Report
Records without errors. These are the remaining records
These are the remaining records excluded from the error reports
Write to aaaaa.aaaaaa.aaaaaa.aaaaa(REPORT7)

Re: Syntax Error

PostPosted: Wed Dec 22, 2010 2:01 am
by Frank Yaeger
I already explained about the ambiguity in an earlier post where I also asked for more information that you didn't suply. I'm on vacation, so I'm trying not to work much.

To repeat:

However, in either case, now that I look at your "rules", they're rather ambiguous. For example, where does a record go if it has 'XF' in 1-2, a non-numeric in 6-19 and a non-numeric in 69-80?

You need to do a better job of explaining the rules if you want me to show you how to do what you want to do. Also show an example of the records in your input file and expected output for each rule, and give the RECFM and LRECL of the input file.


Do you expect to have a particular record in more than one output file?

If SAVE isn't giving you what you want for REPORT07, then I need to see a good example of the records in your input file and the records you're getting in the output file including an example of a record that should go into REPORT07, but isn't going there.

I can't read your mind or that of your manager.

Re: Syntax Error

PostPosted: Wed Dec 22, 2010 8:32 am
by xboss
Thank you very much Frank for being there even on your vacation.
I hope I did not ruin your vacation. :x
Finally, I got it. I made logical mistake while excluding '#F' and '?' in report1.

Mary Christmas :)

Re: Syntax Error

PostPosted: Wed Dec 22, 2010 10:41 pm
by Frank Yaeger
No, you certainly didn't ruin my vacation. I don't mind spending a little time on the boards each day.

I'm glad you figured out your problem (feels good, doesn't it?).

Happy Holidays to you too.