How to solve B063 easytrieve error

[sathyasri]

how to solve b063 easytrieve error

[CICS Guy]

how to solve b063 easytrieve error

First, look up the error...

B063 FIELD REFERENCED WAS - field-name
This message always accompanies the B062 message and identifies which field(s) were referenced in the unavailable file.

Then follow the advice...

B062 FIELD REFERENCED IN UNAVAILABLE FILE - file-name
One or more fields were referenced in the identified file, but the file is not used within the job activity. This is a deferred message which is generated at the end of each job activity. This message is always accompanied by one or more B063 messages that identify which fields were referenced in the unavailable file.

Simple, right?

[sathyasri]

I solved my problem.thanks..........

[dick scherrer]

Thank you for posting your success

d

[macnano]

Hi Sathysari - I was searching for this error which I just encountered today. Do you mind if you can share with me your solution? I already looked into the details of the error but I can't still resolve my problem.

I'm matching 3 temporary/virtual files I created in the previous job of my easytrieve. I matched, I'm populating the fields of my output file using the fields from these virtual files. The OUTFILE is defined in FILE statement and has DD statement in my JCL. TRLR01, TRLR02, TRLR49 are the virtual files I created in the previos jobs.

Code: Select all

JOB INPUT (TRLR01   KEY   TRLR01-FILE-KEY    +     
           TRLR02   KEY   TRLR02-FILE-KEY    +     
           TRLR49   KEY   TRLR49-FILE-KEY)         
                                                   
 IF  MATCHED TRLR01, TRLR02, TRLR49     
    O-POLICY     =  TRLR01-FILE-KEY     
    O-STATUS     =  TRLR01-STAT         
    O-CLASSPLAN  =  TRLR02-CLASSPLAN   
    O-AGENT      =  TRLR49-AGENT       
    O-SIT        =  TRLR49-AGENT-SIT   
    O-AGENCY     =  TRLR49-AGENCY       
    O-CRF-KEY    =  TRLR49-CRF-KEY     
    O-KEY        =  TRLR49-KEY         
    PUT OUTFILE
ELSE                                                 
    IF  MATCHED TRLR02, TRLR49                       
        O-CLASSPLAN  =  TRLR02-CLASSPLAN             
        O-AGENT      =  TRLR49-AGENT                 
        O-SIT        =  TRLR49-AGENT-SIT             
        O-AGENCY     =  TRLR49-AGENCY               
        O-CRF-KEY    =  TRLR49-CRF-KEY               
        O-KEY        =  TRLR49-KEY                   
        PUT OUTFILE                                 
    ELSE                                             
        IF  TRLR02                                   
            O-CLASSPLAN  =  TRLR02-CLASSPLAN         
            PUT OUTFILE                             
        ELSE                                         
             IF  TRLR49                                   
                  O-AGENT   =  TRLR49-AGENT               
                  O-SIT     =  TRLR49-AGENT-SIT           
                  O-AGENCY  =  TRLR49-AGENCY               
                  O-CRF-KEY =  TRLR49-CRF-KEY             
                  O-KEY     =  TRLR49-KEY                 
                 PUT OUTFILE                             
             END-IF                                       
        END-IF                                           
   END-IF                                               
                   
END-IF

Thanks.

Code'd

[BillyBoyo]

We need to see the error messages and where they were produced.

Please be aware of the Code tags. For anything which requires the preservation of spacing, highlight the text and click the Code button. Use Preview to see what the post will look like, make further changes if necessary.

If you can't see the Code button, click on the Full Editor button.

[macnano]

Thanks for your quick response.

Here are the errors:

Code: Select all

 
  561 ************************************************************************
  562 ***                         JOB ACTIVITY - PART 2                    ***
  563 ************************************************************************
      *******B062 FIELD REFERENCED IN UNAVAILABLE FILE - OUTFILE               
      *******B063 FIELD REFERENCED WAS - O-KEY                                 
      *******B063 FIELD REFERENCED WAS - O-CRF-KEY                             
      *******B063 FIELD REFERENCED WAS - O-AGENCY                             
      *******B063 FIELD REFERENCED WAS - O-SIT                                 
      *******B063 FIELD REFERENCED WAS - O-AGENT                               
      *******B063 FIELD REFERENCED WAS - O-CLASSPLAN                           
      *******B063 FIELD REFERENCED WAS - O-STATUS                             
      *******B063 FIELD REFERENCED WAS - O-POLICY                             
  564 JOB INPUT (TRLR01   KEY   TRLR01-FILE-KEY    +                           
                 TRLR02   KEY   TRLR02-FILE-KEY    +                           
                 TRLR49   KEY   TRLR49-FILE-KEY)                               
                                                                               

[NicC]

The original topic is 7 years old! You should not tailgate old topics but create a new topic. You can always provide a link back to the old topic for reference.

[macnano]

My apology. I posted a different topic for this problem.

Thanks.