Re: BOM Explosion

Bob, you get SQL for free with iSeries Navigator. You don't get the green screen STRSQL, but you can develop and use SQL through Navigator.

Sent via my BlackBerry - sorry for my thick-thumbed typos!

-----Original Message-----
From: Bob Voltz <bob.voltz@xxxxxxxxxx>

Date: Thu, 14 May 2009 17:04:01
To: 'MAPICS ERP System Discussion'<mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] BOM Explosion


SQL is not free. My predecessor did not buy it. Now we are cash-strapped
and I can't buy it either.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of CRPence
Sent: Thursday, May 14, 2009 4:38 PM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] BOM Explosion

My browser is unavailable, but what about searching the web for
examples of recursive SQL queries to do that? I seem to recall
running across one or two when trying to learn about recursive
queries. SQL is available on all IBM i & i5/OS; later releases
support recursive queries [with restriction to the SQL Query Engine;
SQE, which means query of the physical file(s) only]. HTH.

Regards, Chuck

Bob Voltz wrote:

<<SNIP>>

I am looking for a program that will do a BOM Explosion and
produce results that match MAPICS Inquiry AMEC72.

It needs to output to a file.

Someone did send me a program that will blow through the BOM,
but the quantities don't match the MAPICS Inquiry AMEC72.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.