OUTREC HAS OVERLAPPING COLUMNS SPECIFIED



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

Postby thotlma » Tue Feb 12, 2019 1:38 pm

Hi All

iam using below code to get header records in out put file but getting overlapping columns issue
could you please review let me know where i did wrong?

OPTION COPY                                                    
 OUTFIL FNAMES=OUTPUT1,                                        
 HEADER1=(1:C'ACC NO',17:C'PRD CODE',21:C'CLSS',24:C'TYPE',    
          28:C'DES',59:C'PLC DATE',68:C'EXP DATE',85:C'PLG AMT',
          95:C'COMMENTS',141:C'BANK')                          
 OUTREC FIELDS=(1:1,14,2X,17:17,3,1X,21:21,1,2X,24:24,2,2X,    
                28:28,20,10X,59:59,8,1X,68:68,8,                
                10X,85:85,7,2X,95:95,7,38X,141:141,4,56X)      
 


Please use the code tags for presenting code, data etc. Not quote tags.
thotlma
 
Posts: 25
Joined: Tue Sep 18, 2018 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

Postby Garry F Carroll » Tue Feb 12, 2019 1:57 pm

OPTION COPY
OUTFIL FNAMES=OUTPUT1,
HEADER1=(1:C'ACC NO',17:C'PRD CODE',21:C'CLSS',24:C'TYPE',
28:C'DES',59:C'PLC DATE',68:C'EXP DATE',85:C'PLG AMT',
95:C'COMMENTS',141:C'BANK')
OUTREC FIELDS=(1:1,14,2X,17:17,3,1X,21:21,1,2X,24:24,2,2X,
28:28,20,10X,59:59,8,1X,68:68,8,
10X,85:
85,7,2X,95:95,7,38X,141:141,4,56X)

In your header, the field starting at position 21 overlaps the 8 byte field starting at position 17.

In your OUTREC the field at position 85 overlaps the preceding field by one byte. (68+8+10 = 86).

Garry.
Garry F Carroll
 
Posts: 28
Joined: Wed Sep 19, 2018 8:20 pm
Has thanked: 0 time
Been thanked: 1 time

Re: OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

Postby sergeyken » Fri Aug 16, 2019 1:04 am

Try to code it in a more accurate manner. It would save you a lot of time in further debugging.
 OPTION COPY
 OUTREC FIELDS=(1:1,14,2X,
               17:17,3,1X,
               21:21,1,2X,
               24:24,2,2X,
               28:28,20,10X,
               59:59,8,1X,
               68:68,8,10X,
               85:85,7,2X,
               95:95,7,38X,
              141:141,4,56X)
 OUTFIL FNAMES=OUTPUT1,
        HEADER1=(1:C'ACC NO',
                17:C'PRD CODE',
                21:C'CLSS',
                24:C'TYPE',
                28:C'DES',
                59:C'PLC DATE',
                68:C'EXP DATE',
                85:C'PLG AMT',
                95:C'COMMENTS',
               141:C'BANK')
 
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post