How to solve B063 easytrieve error



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

How to solve B063 easytrieve error

Postby sathyasri » Wed Oct 10, 2007 7:32 pm

how to solve b063 easytrieve error
sathyasri
 
Posts: 11
Joined: Tue Oct 09, 2007 6:06 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to solve b063 easytrieve error

Postby CICS Guy » Thu Oct 11, 2007 2:12 pm

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?
CICS Guy
 
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: how to solve b063 easytrieve error

Postby sathyasri » Fri Oct 12, 2007 9:59 pm

I solved my problem.thanks..........
sathyasri
 
Posts: 11
Joined: Tue Oct 09, 2007 6:06 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to solve b063 easytrieve error

Postby dick scherrer » Sat Oct 13, 2007 4:14 am

Thank you for posting your success :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to solve B063 easytrieve error

Postby macnano » Tue Nov 04, 2014 4:35 am

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
macnano
 
Posts: 9
Joined: Wed Feb 06, 2013 3:07 am
Has thanked: 1 time
Been thanked: 0 time

Re: How to solve B063 easytrieve error

Postby BillyBoyo » Tue Nov 04, 2014 5:04 am

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to solve B063 easytrieve error

Postby macnano » Tue Nov 04, 2014 5:30 am

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)                               
                                                                               
macnano
 
Posts: 9
Joined: Wed Feb 06, 2013 3:07 am
Has thanked: 1 time
Been thanked: 0 time

Re: How to solve B063 easytrieve error

Postby NicC » Tue Nov 04, 2014 6:47 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to solve B063 easytrieve error

Postby macnano » Tue Nov 04, 2014 8:05 pm

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

Thanks.
macnano
 
Posts: 9
Joined: Wed Feb 06, 2013 3:07 am
Has thanked: 1 time
Been thanked: 0 time


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post