Re: Largest Inventory Quantity of a Part

I do this often when writing some new program ... how large do I need to
make some print field ... get largest YTD and add a space or two.

On command line RUNQRY then F4 ... you can select *N for the query
definition, specify a file to run Query/400 against and YES for the
selection criteria.

I have this on a BPCS menu, already setup to DUMP the file of choice at run
time. In your case - IIM IWI ILI ... select the field OPENING BALANCE ...
seek to dump on screen, all those GE 100000 or some reasonable high figure,
then sideways to find some high value, then F12 and GE that high value, then
repeat, and soon you'll see what's the biggest you currently have, for any
item.

In SQL/400 you can search a field to get some value like MAX
Meaning the largest value in that field, of the records you looked at.
So you could have SQL embedded in RPG, looking at one item # at a time, then
for that item, seek MAX value of all the values in IWI or ILI.

-
Al Mac
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Bailey, Dick
Sent: Monday, October 31, 2011 10:37 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Largest Inventory Quantity of a Part


There is a need here to identify the warehouse location of each part that
contains the largest quantity of that part.

Using AS400 IBM Query Language.

Anyone have a suggestion as to how?

We are on BPCS LX.

Dick Bailey
MCFA, Inc.