Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

(post comments) Trouble Shooting blog #10

Open
rbheemana opened this issue Aug 17, 2016 · 4 comments
Open

(post comments) Trouble Shooting blog #10

rbheemana opened this issue Aug 17, 2016 · 4 comments
Labels
post comments These issues are opened for discussion on gh-pages

Comments

@rbheemana
Copy link
Owner

No description provided.

@rbheemana rbheemana added the post comments These issues are opened for discussion on gh-pages label Feb 6, 2019
@vchiluvu
Copy link

vchiluvu commented Apr 5, 2019

Thanks for the Serde so far!!! It is working for most of the scenarios. However, I am getting an error when I have a copybook similar to below.
ERROR 1:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x_fbs_waive_entry_mtd_oc1 in the table definition.
FAILED LAYOUT:
10 FILLER REDEFINES X-FBS-MTD-WAIVE-AREA.
15 X-FBS-MTD-WAIVE-TABLE-1A-AREA OCCURS 3 TIMES.
20 X-FBS-MTD-WAIVE-TABLE-1B-AREA OCCURS 7 TIMES.
25 X-FBS-WAIVE-ENTRY-MTD PIC S9(05) COMP-3.
ERROR 2:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x56288_chgoff_bank_n in the table definition.
FAILED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF.
10 X56288-FRAUD-CHRG OCCURS 5 TIMES.
15 X56288-CHGOFF-AMT PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE PIC XX.
15 X56288-CHGOFF-BANK PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK.
20 X56288-CHGOFF-BANK-N PIC S9(4) COMP.
15 X56288-CHGOFF-GL PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG PIC X.
15 X56288-CHGOFF-ID PIC X(008).
15 X56288-CHGOFF-DTE PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME PIC 9(007) COMP-3.
ERROR 3:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x56288_hchgoff_tran_code_n in the table definition
FAILED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF-HISTORY.
10 X56288-HFRAUD-CHRG OCCURS 17 TIMES.
15 X56288-HCHGOFF-AMT PIC S9(11)V99 COMP-3.
15 X56288-HCHGOFF-TRAN-CODE PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE.
20 X56288-HCHGOFF-TRAN-CODE-N PIC S9(04) COMP.
15 X56288-HCHGOFF-REASON-CODE PIC XX.
15 X56288-HCHGOFF-BANK PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-BANK.
20 X56288-HCHGOFF-BANK-N PIC S9(4) COMP.
15 X56288-HCHGOFF-GL PIC 9(007) COMP-3.
15 X56288-HCHGOFF-COST-CENTER PIC 9(007) COMP-3.
15 X56288-HCHGOFF-AVOID-FLG PIC X.
15 X56288-HCHGOFF-ID PIC X(008).
15 X56288-HCHGOFF-DTE PIC 9(007) COMP-3.
15 X56288-HCHGOFF-TME PIC 9(007) COMP-3.

@rbheemana
Copy link
Owner Author

rbheemana commented Apr 5, 2019 via email

@vchiluvu
Copy link

vchiluvu commented Apr 5, 2019

There were no duplicates in my copybook. It worked after manually expanding the OCCURS clause in the sections of the copybook I mentioned. It would be nice if it can be handled through the program. The issue seems to occur when only three layers of occurs or redefines in the same section. I had to manually modify the above sections of the copybook as follows.
ERROR 1:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x_fbs_waive_entry_mtd_oc1 in the table definition.
FAILED LAYOUT:
10 FILLER REDEFINES X-FBS-MTD-WAIVE-AREA.
15 X-FBS-MTD-WAIVE-TABLE-1A-AREA OCCURS 3 TIMES.
20 X-FBS-MTD-WAIVE-TABLE-1B-AREA OCCURS 7 TIMES.
25 X-FBS-WAIVE-ENTRY-MTD PIC S9(05) COMP-3.
MODIFIED LAYOUT:
10 FILLER REDEFINES X-FBS-MTD-WAIVE-AREA.
15 X-FBS-MTD-WAIVE-TABLE-1A-AREA-OC1.
20 X-FBS-MTD-WAIVE-TABLE-1B-AREA.
25 X-FBS-WAIVE-ENTRY-MTD-01 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-02 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-03 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-04 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-05 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-06 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-07 PIC S9(05) COMP-3.
15 X-FBS-MTD-WAIVE-TABLE-1A-AREA-OC2.
20 X-FBS-MTD-WAIVE-TABLE-1B-AREA.
25 X-FBS-WAIVE-ENTRY-MTD-08 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-09 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-10 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-11 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-12 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-13 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-14 PIC S9(05) COMP-3.
15 X-FBS-MTD-WAIVE-TABLE-1A-AREA-OC3.
20 X-FBS-MTD-WAIVE-TABLE-1B-AREA.
25 X-FBS-WAIVE-ENTRY-MTD-15 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-16 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-17 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-18 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-19 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-20 PIC S9(05) COMP-3.
25 X-FBS-WAIVE-ENTRY-MTD-21 PIC S9(05) COMP-3.

ERROR 2:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x56288_chgoff_bank_n in the table definition.
FAILED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF.
10 X56288-FRAUD-CHRG OCCURS 5 TIMES.
15 X56288-CHGOFF-AMT PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE PIC XX.
15 X56288-CHGOFF-BANK PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK.
20 X56288-CHGOFF-BANK-N PIC S9(4) COMP.
15 X56288-CHGOFF-GL PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG PIC X.
15 X56288-CHGOFF-ID PIC X(008).
15 X56288-CHGOFF-DTE PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME PIC 9(007) COMP-3.
MODIFIED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF.
10 X56288-FRAUD-CHRG-OC1.
15 X56288-CHGOFF-AMT-01 PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE-01 PIC XX.
15 X56288-CHGOFF-BANK-01 PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK-01.
20 X56288-CHGOFF-BANK-N-01 PIC S9(4) COMP.
15 X56288-CHGOFF-GL-01 PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER-01 PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG-01 PIC X.
15 X56288-CHGOFF-ID-01 PIC X(008).
15 X56288-CHGOFF-DTE-01 PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME-01 PIC 9(007) COMP-3.
10 X56288-FRAUD-CHRG-OC2.
15 X56288-CHGOFF-AMT-02 PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE-02 PIC XX.
15 X56288-CHGOFF-BANK-02 PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK-02.
20 X56288-CHGOFF-BANK-N-02 PIC S9(4) COMP.
15 X56288-CHGOFF-GL-02 PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER-02 PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG-02 PIC X.
15 X56288-CHGOFF-ID-02 PIC X(008).
15 X56288-CHGOFF-DTE-02 PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME-02 PIC 9(007) COMP-3.
10 X56288-FRAUD-CHRG-OC3.
15 X56288-CHGOFF-AMT-03 PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE-03 PIC XX.
15 X56288-CHGOFF-BANK-03 PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK-03.
20 X56288-CHGOFF-BANK-N-03 PIC S9(4) COMP.
15 X56288-CHGOFF-GL-03 PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER-03 PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG-03 PIC X.
15 X56288-CHGOFF-ID-03 PIC X(008).
15 X56288-CHGOFF-DTE-03 PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME-03 PIC 9(007) COMP-3.
10 X56288-FRAUD-CHRG-OC4.
15 X56288-CHGOFF-AMT-04 PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE-04 PIC XX.
15 X56288-CHGOFF-BANK-04 PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK-04.
20 X56288-CHGOFF-BANK-N-04 PIC S9(4) COMP.
15 X56288-CHGOFF-GL-04 PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER-04 PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG-04 PIC X.
15 X56288-CHGOFF-ID-04 PIC X(008).
15 X56288-CHGOFF-DTE-04 PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME-04 PIC 9(007) COMP-3.
10 X56288-FRAUD-CHRG-OC5.
15 X56288-CHGOFF-AMT-05 PIC S9(11)V99 COMP-3.
15 X56288-CHGOFF-REASON-CODE-05 PIC XX.
15 X56288-CHGOFF-BANK-05 PIC XX.
15 FILLER REDEFINES X56288-CHGOFF-BANK-05.
20 X56288-CHGOFF-BANK-N-05 PIC S9(4) COMP.
15 X56288-CHGOFF-GL-05 PIC 9(007) COMP-3.
15 X56288-CHGOFF-COST-CENTER-05 PIC 9(007) COMP-3.
15 X56288-CHGOFF-AVOID-FLG-05 PIC X.
15 X56288-CHGOFF-ID-05 PIC X(008).
15 X56288-CHGOFF-DTE-05 PIC 9(007) COMP-3.
15 X56288-CHGOFF-TME-05 PIC 9(007) COMP-3.

ERROR 3:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException:
Duplicate column name x56288_hchgoff_tran_code_n in the table definition
FAILED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF-HISTORY.
10 X56288-HFRAUD-CHRG OCCURS 17 TIMES.
15 X56288-HCHGOFF-AMT PIC S9(11)V99 COMP-3.
15 X56288-HCHGOFF-TRAN-CODE PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE.
20 X56288-HCHGOFF-TRAN-CODE-N PIC S9(04) COMP.
15 X56288-HCHGOFF-REASON-CODE PIC XX.
15 X56288-HCHGOFF-BANK PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-BANK.
20 X56288-HCHGOFF-BANK-N PIC S9(4) COMP.
15 X56288-HCHGOFF-GL PIC 9(007) COMP-3.
15 X56288-HCHGOFF-COST-CENTER PIC 9(007) COMP-3.
15 X56288-HCHGOFF-AVOID-FLG PIC X.
15 X56288-HCHGOFF-ID PIC X(008).
15 X56288-HCHGOFF-DTE PIC 9(007) COMP-3.
15 X56288-HCHGOFF-TME PIC 9(007) COMP-3.
MODIFIED LAYOUT:
05 FILLER REDEFINES X56288-CHARGE-OFF-HISTORY.
10 X56288-HFRAUD-CHRG-OC1.
15 X56288-HCHGOFF-AMT-01 PIC S9(11)V99 COMP-3.
15 X56288-HCHGOFF-TRAN-CODE-01 PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-01.
20 X56288-HCHGOFF-TRAN-CODE-N-01 PIC S9(04) COMP.
15 X56288-HCHGOFF-REASON-CODE-01 PIC XX.
15 X56288-HCHGOFF-BANK-01 PIC XX.
15 FILLER REDEFINES X56288-HCHGOFF-BANK-01.
20 X56288-HCHGOFF-BANK-N-01 PIC S9(4) COMP.
15 X56288-HCHGOFF-GL-01 PIC 9(007) COMP-3.
15 X56288-HCHGOFF-COST-CENTER-01 PIC 9(007) COMP-3.
15 X56288-HCHGOFF-AVOID-FLG-01 PIC X.
15 X56288-HCHGOFF-ID-01 PIC X(008).
15 X56288-HCHGOFF-DTE-01 PIC 9(007) COMP-3.
15 X56288-HCHGOFF-TME-01 PIC 9(007) COMP-3.

           10  X56288-HFRAUD-CHRG-OC2.                  
             15  X56288-HCHGOFF-AMT-02       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-02    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-02.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-02 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-02 PIC XX.                 
             15  X56288-HCHGOFF-BANK-02          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-02.       
                 20  X56288-HCHGOFF-BANK-N-02 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-02          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-02 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-02   PIC X.                
             15  X56288-HCHGOFF-ID-02          PIC X(008).           
             15  X56288-HCHGOFF-DTE-02         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-02         PIC 9(007) COMP-3.
       
           10  X56288-HFRAUD-CHRG-OC3.                  
             15  X56288-HCHGOFF-AMT-03       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-03    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-03.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-03 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-03 PIC XX.                 
             15  X56288-HCHGOFF-BANK-03          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-03.       
                 20  X56288-HCHGOFF-BANK-N-03 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-03          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-03 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-03   PIC X.                
             15  X56288-HCHGOFF-ID-03          PIC X(008).           
             15  X56288-HCHGOFF-DTE-03         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-03         PIC 9(007) COMP-3.
          
           10  X56288-HFRAUD-CHRG-OC4.                  
             15  X56288-HCHGOFF-AMT-04       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-04    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-04.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-04 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-04 PIC XX.                 
             15  X56288-HCHGOFF-BANK-04          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-04.       
                 20  X56288-HCHGOFF-BANK-N-04 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-04          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-04 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-04   PIC X.                
             15  X56288-HCHGOFF-ID-04          PIC X(008).           
             15  X56288-HCHGOFF-DTE-04         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-04         PIC 9(007) COMP-3.
        
           10  X56288-HFRAUD-CHRG-OC5.                  
             15  X56288-HCHGOFF-AMT-05       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-05    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-05.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-05 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-05 PIC XX.                 
             15  X56288-HCHGOFF-BANK-05          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-05.       
                 20  X56288-HCHGOFF-BANK-N-05 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-05          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-05 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-05   PIC X.                
             15  X56288-HCHGOFF-ID-05          PIC X(008).           
             15  X56288-HCHGOFF-DTE-05         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-05         PIC 9(007) COMP-3.
          
           10  X56288-HFRAUD-CHRG-OC6.                  
             15  X56288-HCHGOFF-AMT-06       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-06    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-06.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-06 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-06 PIC XX.                 
             15  X56288-HCHGOFF-BANK-06          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-06.       
                 20  X56288-HCHGOFF-BANK-N-06 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-06          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-06 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-06   PIC X.                
             15  X56288-HCHGOFF-ID-06          PIC X(008).           
             15  X56288-HCHGOFF-DTE-06         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-06         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC7.                  
             15  X56288-HCHGOFF-AMT-07       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-07    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-07.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-07 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-07 PIC XX.                 
             15  X56288-HCHGOFF-BANK-07          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-07.       
                 20  X56288-HCHGOFF-BANK-N-07 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-07          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-07 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-07   PIC X.                
             15  X56288-HCHGOFF-ID-07          PIC X(008).           
             15  X56288-HCHGOFF-DTE-07         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-07         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC8.                  
             15  X56288-HCHGOFF-AMT-08       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-08    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-08.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-08 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-08 PIC XX.                 
             15  X56288-HCHGOFF-BANK-08          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-08.       
                 20  X56288-HCHGOFF-BANK-N-08 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-08          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-08 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-08   PIC X.                
             15  X56288-HCHGOFF-ID-08          PIC X(008).           
             15  X56288-HCHGOFF-DTE-08         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-08         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC9.                  
             15  X56288-HCHGOFF-AMT-09       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-09    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-09.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-09 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-09 PIC XX.                 
             15  X56288-HCHGOFF-BANK-09          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-09.       
                 20  X56288-HCHGOFF-BANK-N-09 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-09          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-09 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-09   PIC X.                
             15  X56288-HCHGOFF-ID-09          PIC X(008).           
             15  X56288-HCHGOFF-DTE-09         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-09         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC10.                  
             15  X56288-HCHGOFF-AMT-10       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-10    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-10.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-10 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-10 PIC XX.                 
             15  X56288-HCHGOFF-BANK-10          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-10.       
                 20  X56288-HCHGOFF-BANK-N-10 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-10          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-10 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-10   PIC X.                
             15  X56288-HCHGOFF-ID-10          PIC X(008).           
             15  X56288-HCHGOFF-DTE-10         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-10         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC11.                  
             15  X56288-HCHGOFF-AMT-11       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-11    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-11.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-11 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-11 PIC XX.                 
             15  X56288-HCHGOFF-BANK-11          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-11.       
                 20  X56288-HCHGOFF-BANK-N-11 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-11          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-11 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-11   PIC X.                
             15  X56288-HCHGOFF-ID-11          PIC X(008).           
             15  X56288-HCHGOFF-DTE-11         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-11         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC12.                  
             15  X56288-HCHGOFF-AMT-12       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-12    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-12.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-12 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-12 PIC XX.                 
             15  X56288-HCHGOFF-BANK-12          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-12.       
                 20  X56288-HCHGOFF-BANK-N-12 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-12          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-12 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-12   PIC X.                
             15  X56288-HCHGOFF-ID-12          PIC X(008).           
             15  X56288-HCHGOFF-DTE-12         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-12         PIC 9(007) COMP-3.
         
           10  X56288-HFRAUD-CHRG-OC13.                  
             15  X56288-HCHGOFF-AMT-13       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-13    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-13.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-13 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-13 PIC XX.                 
             15  X56288-HCHGOFF-BANK-13          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-13.       
                 20  X56288-HCHGOFF-BANK-N-13 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-13          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-13 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-13   PIC X.                
             15  X56288-HCHGOFF-ID-13          PIC X(008).           
             15  X56288-HCHGOFF-DTE-13         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-13         PIC 9(007) COMP-3.

           10  X56288-HFRAUD-CHRG-OC14.                  
             15  X56288-HCHGOFF-AMT-14       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-14    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-14.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-14 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-14 PIC XX.                 
             15  X56288-HCHGOFF-BANK-14          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-14.       
                 20  X56288-HCHGOFF-BANK-N-14 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-14          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-14 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-14   PIC X.                
             15  X56288-HCHGOFF-ID-14          PIC X(008).           
             15  X56288-HCHGOFF-DTE-14         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-14         PIC 9(007) COMP-3.
  
           10  X56288-HFRAUD-CHRG-OC15.                  
             15  X56288-HCHGOFF-AMT-15       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-15    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-15.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-15 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-15 PIC XX.                 
             15  X56288-HCHGOFF-BANK-15          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-15.       
                 20  X56288-HCHGOFF-BANK-N-15 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-15          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-15 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-15   PIC X.                
             15  X56288-HCHGOFF-ID-15          PIC X(008).           
             15  X56288-HCHGOFF-DTE-15         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-15         PIC 9(007) COMP-3.
     
           10  X56288-HFRAUD-CHRG-OC16.                  
             15  X56288-HCHGOFF-AMT-16       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-16    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-16.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-16 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-16 PIC XX.                 
             15  X56288-HCHGOFF-BANK-16          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-16.       
                 20  X56288-HCHGOFF-BANK-N-16 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-16          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-16 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-16   PIC X.                
             15  X56288-HCHGOFF-ID-16          PIC X(008).           
             15  X56288-HCHGOFF-DTE-16         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-16         PIC 9(007) COMP-3.
      
           10  X56288-HFRAUD-CHRG-OC17.                  
             15  X56288-HCHGOFF-AMT-17       PIC S9(11)V99 COMP-3.
             15  X56288-HCHGOFF-TRAN-CODE-17    PIC XX.    
             15  FILLER REDEFINES X56288-HCHGOFF-TRAN-CODE-17.   
                 20 X56288-HCHGOFF-TRAN-CODE-N-17 PIC S9(04) COMP.    
             15  X56288-HCHGOFF-REASON-CODE-17 PIC XX.                 
             15  X56288-HCHGOFF-BANK-17          PIC XX.       
             15  FILLER REDEFINES X56288-HCHGOFF-BANK-17.       
                 20  X56288-HCHGOFF-BANK-N-17 PIC S9(4) COMP.     
             15  X56288-HCHGOFF-GL-17          PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-COST-CENTER-17 PIC 9(007) COMP-3.    
             15  X56288-HCHGOFF-AVOID-FLG-17   PIC X.                
             15  X56288-HCHGOFF-ID-17          PIC X(008).           
             15  X56288-HCHGOFF-DTE-17         PIC 9(007) COMP-3.
             15  X56288-HCHGOFF-TME-17         PIC 9(007) COMP-3.

@rbheemana
Copy link
Owner Author

rbheemana commented Apr 7, 2019 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
post comments These issues are opened for discussion on gh-pages
Projects
None yet
Development

No branches or pull requests

2 participants