Re: OPNQRYF - Sort by a calculated field

["Peter Vidal" <Peter_Vidal@xxxxxxxx>]

"Is the mapfield OBPCT a field in the format, which seems to be file MEINVDTL.
Or in other words: is OBPCT a field in the file itself? If not, map the field to
an existing field in the file, that is not used in the processing of that file."

No, this field is not in the file.  I tried what you said:

/=================================================/
OPNQRYF FILE((MEINVDTL)) QRYSLT('OBQTY *GT 0')
KEYFLD((OQTYW1))
MAPFLD((OQTYW1 '(OBSTKVAL/OSTKVAL)*100')))
/=================================================/

But no matter if the key field qualifier is *MAPFLD or a number to specify the
file number or
nothing to specify the current file, I have this message:

Message ID . . . . . . :   CPD3108       Severity . . . . . . . :   30
Message type . . . . . :   Diagnostic
Date sent  . . . . . . :   12/17/02      Time sent  . . . . . . :   09:27:16

Message . . . . :   Qualifier for field OBSTKVAL/OSTKVAL not found.
Cause . . . . . :   If the qualifier value OBSTKVAL for field OBSTKVAL/OSTKVAL
  that was specified on the MAPFLD parameter is a file name, the file is not
  one that was specified on the FILE parameter.  If the qualifier value
  OBSTKVAL is a number, its value is larger than the number of entries
  specified on the FILE parameter.
Recovery  . . . :   Either specify a qualifier value that is the file name, or
  a number for one of the entries that was specified on the FILE parameter.
  Then try the request again.

After all this strugle, I have simply decided to add this field to the record
and do the calculation in the RPG program.  Then I will do a simple sort here.

Thank you guys for all your help and have a Merry Christmas and a blessed 2003
filled with love, peace and health for you and your whole family (This goes for
everybody as well!)

Peter Vidal
Pall Aeropower Corp. / SR Programmer Analyst
www.pall.com  /  Peter_Vidal@Pall.com
727-539-8448, x2414