Re: OPNQRYF - Sort by a calculated field

[Dan <dbcemid@xxxxxxxxx>]

Just for future reference, the error message you're getting on this is
treating "OBSTKVAL/OSTKVAL" as a qualified field name, i.e., field
OSTKVAL in record format (file???) OBSTKVAL.  See what happens if you
use a space before and after the '/'.

You have already said that you dropped the OPNQRYF.  But, if you've got
a moment, could you check out my theory and see what happens?

Is OQTYW1 a numeric 9,3 field, like in your original MAPFLD defn?  I
know the technique I used in my original post to guarantee that you
don't divide by zero "works" in Query, but you have to expect a
calculated result that is outside a reasonable range.  Implications to
consider: overflow and precision bombs.

HTH, Dan

--- Peter Vidal <Peter_Vidal@pall.com> wrote:
>
> "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

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com