Re: Product Structure files (BOM) and RPG programs

[sjones@xxxxxxxxxxxxxx]

Do you have a "K" coded on your F-spec?  Like this one:

FMYFILEUF  E           K        DISK

Steve Jones


                                                                                
                   
                    "McCready, Joan"                                            
                   
                    <Joan.McCready@metalt        To:     "MAPICS-List (E-mail)" 
                   
                    ekint.com>                   <MAPICS-L@midrange.com>        
                   
                    Sent by:                     cc:                            
                   
                    owner-mapics-l@midran        Fax to:                        
                   
                    ge.com                       Subject:     Product Structure 
files (BOM) and    
                                                 RPG programs                   
                   
                                                                                
                   
                    11/02/00 03:32 PM                                           
                   
                    Please respond to                                           
                   
                    MAPICS-L                                                    
                   
                                                                                
                   
                                                                                
                   



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