Page 1 of 1

How to solve B063 easytrieve error

PostPosted: Wed Oct 10, 2007 7:32 pm
by sathyasri
how to solve b063 easytrieve error

Re: how to solve b063 easytrieve error

PostPosted: Thu Oct 11, 2007 2:12 pm
by CICS Guy
sathyasri wrote: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?

Re: how to solve b063 easytrieve error

PostPosted: Fri Oct 12, 2007 9:59 pm
by sathyasri
I solved my problem.thanks..........

Re: how to solve b063 easytrieve error

PostPosted: Sat Oct 13, 2007 4:14 am
by dick scherrer
Thank you for posting your success :)

d

Re: How to solve B063 easytrieve error

PostPosted: Tue Nov 04, 2014 4:35 am
by 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.

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

Re: How to solve B063 easytrieve error

PostPosted: Tue Nov 04, 2014 5:04 am
by 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.

Re: How to solve B063 easytrieve error

PostPosted: Tue Nov 04, 2014 5:30 am
by macnano
Thanks for your quick response.

Here are the errors:

 
  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)                               
                                                                               

Re: How to solve B063 easytrieve error

PostPosted: Tue Nov 04, 2014 6:47 pm
by 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.

Re: How to solve B063 easytrieve error

PostPosted: Tue Nov 04, 2014 8:05 pm
by macnano
My apology. I posted a different topic for this problem.

Thanks.