View previous topic :: View next topic
|
Author |
Message |
saipv
New User
Joined: 15 Apr 2005 Posts: 8
|
|
|
|
I have Variable length file. I need to find the following:
Format
01 Record.
10 Init-data PIC X(10).
10 Variable-CTR PIC 9(4) comp-3.
10 Detail-data OCCURS 0 to 100 TIMES depending on Variable-CTR
15 DATE.
20 Date-CC PIC XX.
20 Date-YY PIC XX.
20 FILLER PIC X.
20 Date-MM PIC XX.
20 FILLER PIC X.
20 Date-DD PIC XX.
a) Records with Date = blank or Zeroes
b) Records with Date > Current Date + 29 days.
Can this done with Syncsort ? |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
pvsuji4,
Which of the 0 to 100 dates do you wish to sort on? |
|
Back to top |
|
|
saipv
New User
Joined: 15 Apr 2005 Posts: 8
|
|
|
|
I need to SORT the first occurance |
|
Back to top |
|
|
saipv
New User
Joined: 15 Apr 2005 Posts: 8
|
|
|
|
1. I am looking for the first occurance of the DATE value = blank or Zeroes
2. first occurance of DATE > current date + 29 days |
|
Back to top |
|
|
saipv
New User
Joined: 15 Apr 2005 Posts: 8
|
|
|
|
hi All,
It's working with the following:
Code: |
//SYSIN DD *
OPTION VLSHRT NOVLSCMP
SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=(128,18,CH,GT,DATE4+29)
//*
|
|
|
Back to top |
|
|
|