Page 1 of 1

OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

PostPosted: Tue Feb 12, 2019 1:38 pm
by thotlma
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.

Re: OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

PostPosted: Tue Feb 12, 2019 1:57 pm
by Garry F Carroll
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.

Re: OUTREC HAS OVERLAPPING COLUMNS SPECIFIED

PostPosted: Fri Aug 16, 2019 1:04 am
by sergeyken
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')