RE: Product Structure files (BOM) and RPG programs

["McCready, Joan" <Joan.McCready@xxxxxxxxxxxxxxx>]

Sorry   -   I got it resolved!   Ye olde COBOL programmer  -- Joan McCready

-----Original Message-----
From: McCready, Joan [mailto:Joan.McCready@metaltekint.com]
Sent: Thursday, November 02, 2000 2:32 PM
To: MAPICS-List (E-mail)
Subject: Product Structure files (BOM) and RPG programs


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
+---
+---
| 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
+---