|
Can I access member RETURN of file ESN via SQL embedded in RPG/400? Scenario: File ESN has different kinds of notes for different kinds of BPCS files & I am finding some notes apparently exist in member ESN of file ESN for customer orders etc. that do not exist any more, and I am working on doing something about that. RMA;s (Return Material Authorization) stored in member RETURN of various files whose *FIRST member is for standard new customer orders. I was wondering if the kind of analysis I doing in each *FIRST to find old garbage records we not need any more could also be done against member RETURN of these files. I know I can do it with RPG/400. I was wondering if SQL embedded in RPG/400 can access by member or if this is outside of SQL reality. I am trying to clean up garbage from our data base, in which initial step is get a handle on where it is, then next step is best software tools to get the job done, possibly different techniques for different scenarios. MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac) BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated http://www.globalwiretechnologies.com = new name same quality wire engineering company: fax # 812-424-6838
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.