• Subject: Product Structure files (BOM) and RPG programs
  • From: "McCready, Joan" <Joan.McCready@xxxxxxxxxxxxxxx>
  • Date: Thu, 2 Nov 2000 14:32:23 -0600

Hi, all!  

I have been tearing my hair out this morning trying to write a couple of
simple RPG programs to update the component item "quantity per" for parent
items that match certain search criteria.  We've got several hundred items
that match the criteria and about an equal number of items that do not match
the criteria, so that rules out (I think) using the mass replace BOM
component routines.  (Besides, I'm changing the quantity of the same item,
not substituting a new item for the old one.)  And I definately do not want
to go through each BOM by hand!

Anyway, I've done this sort of "clean up" RPG program before on other MAPICs
files and never had a problem.  I found the logicals I think I should use
(PSTDTLL5 for the EPDM BOM file and PSTRUCLA for the PDM BOM file).  If I
just start at the beginning of the file and read through it, my programs
work, but they read every record trying to find the "match."  So I tried to
add a "SETLL" or "CHAIN" to the CITEM that I want to change to begin the
sequential read through the files.  When I try to compile the RPG, I get a
QRG7070 error message "The KLIST is invalid with the specified file."  In
the compile report, the diagnostic message is "KLIST not valid with
Pgm-Described or Non-Keyed Ext-Described File."  Yet these ARE keyed logical
files - if I print the file record layout report for them out of CAS, they
show the key; if I go into them using DFU, they are keyed and I can "jump"
to my beginning record.  What is going wrong here????   Anyone??

    A thousand thanks  --  Joan

Joan McCready, IS Manager         phone:  636-479-4499
The Carondelet Corporation           fax:  636-479-3399
8600 Commercial Blvd                  www.metaltekint.com
Pevely, MO  63070                      

| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.