Syntax Error



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: Syntax Error

Postby Frank Yaeger » Tue Dec 21, 2010 10:41 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Re: Syntax Error

 

Re: Syntax Error

Postby xboss » Wed Dec 22, 2010 12:20 am

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)
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Syntax Error

Postby Frank Yaeger » Wed Dec 22, 2010 2:01 am

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Syntax Error

Postby xboss » Wed Dec 22, 2010 8:32 am

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 :)
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Syntax Error

Postby Frank Yaeger » Wed Dec 22, 2010 10:41 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post