Re: A critical Query on OPNQRYF

I think your key on the OPNQRYF should be:

CHANGE DATE, CHANGE TIME, EMPLOYEE#, CHANGE CODE.

This is important to keep the before- and after-images of the records of the 
same employee#  read sequentially.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 8-7-05 at 4:09 Vijaykrishna_Malladi wrote:

>Hi,
>
>I have a tricky situation:
>I have a employee history file in which, EMPLOYEE#, CHANGE DATE, CHANGE
>TIME are key fields. Now if I use OPNQRYF with CHANGE DATE and CHANGE TIME
>as key fields, In the RPGLE program, will I retrieve the records in the
>Arrival sequence order for the same values of the CHANGE DATE and CHANGE TIME?
>
>This order is very important to me because we have a field - change code
>which as 'B' or 'C' values for before image and after images. We have to
>compare these records by reading the file sequentially for the same value
>of Date and Time. Any solutions would be highly appreciated.