With EZT R11.6, I am using an indexed field as a KEY on the JOB INPUT statement and getting a compile error EZTC0062E. What causes this?

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

Summary: 

The following will produce an Easytrieve Compile error:

          1  FILE PERSNL VS
                  2  REC150              001  150 A  INDEX REC150-IDX
                  3  EMPNUM   REC150    +009  005 A
                  4  *
                  5  JOB INPUT (PERSNL KEY EMPNUM)
EZTC0062E >>>                        $ cannot be an INDEXed field
                  6       DISPLAY EMPNUM

 Instructions: 

With Easytrieve r11.6, additional error logic was added to ensure a key field can't be varying, indexed, or subscripted.

The following is why the additional error checking was added to the Easytrieve r11.6 compiler:

• For the JOB INPUT (filename KEY key-fieldname) statement, using an indexed field could cause errors and/or improper references
• The key-fieldname may not be referenced from the same location in the record, when looping back to the JOB statement for the next record, producing inconsistent results.

   

Additional Information: 

For additional details, please see the Easytrieve Programmers Guide under Chapter 3: with regards to File processing, and Synchronized File Processing.

 

 

Environment

Release: EDBMSU00200-11.6-Easytrieve-Report Generator-Option for DB2-MSU
Component: