×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Don't see how Query alone can do it, but a simple RPG batch program which reads ILI and writes records to a temp file, replacing the location code and qty when a duplicate part# is found with a GREATER QTY. Then, you can Query that file.
See: www.Exact-IT-Systems.info
If you don't behave as you believe, you will end by believing as you behave. --Abp. Fulton J. Sheen
--- On Mon, 10/31/11, Bailey, Dick <Dick.Bailey@xxxxxxxx> wrote:
From: Bailey, Dick <Dick.Bailey@xxxxxxxx>
Subject: [BPCS-L] Largest Inventory Quantity of a Part
To: "bpcs-l@xxxxxxxxxxxx" <bpcs-l@xxxxxxxxxxxx>
Date: Monday, October 31, 2011, 10:37 AM
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
