× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Nandagopal,

Actually, Query/400 is an excellent, if somewhat limited, tool.  We use it
VERY extensively, mostly because it's very easy to use (as long as you
avoid COM files!).  I can't even begin to cover all the differences between
SQL and Query - it's like comparing a steak and lobster dinner to a hot dog
and potato chips.  Both are good at the right time.

I agree - the MAPICS thread is an excellent tool!

Dale Gindlesperger
IT Manager
Fleetwood Folding Trailers, Inc.




                                                                                
                                                        
                      "Nandagopal                                               
                                                        
                      Padmanabhan"              To:       "MAPICS ERP System 
Discussion" <mapics-l@xxxxxxxxxxxx>                        
                      <npadmanabhan@xxxx        cc:                             
                                                        
                      as-awt.com>               Subject:  RE: AS400 Query 
Question                                                      
                      Sent by:                                                  
                                                        
                      mapics-l-bounces@x                                        
                                                        
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      04/11/2003 02:38                                          
                                                        
                      PM                                                        
                                                        
                      Please respond to                                         
                                                        
                      MAPICS ERP System                                         
                                                        
                      Discussion                                                
                                                        
                                                                                
                                                        
                                                                                
                                                        




Dale,
Thanks for the attachment you sent me. Hmmm...what can be achieved by a
simple SQL query takes pages to achieve using Query/400!!

What is the difference between AS400 SQL and Query/400? Thanks for all your
help and it's great to be a part of this info bank.

Thanks,
Nandu

-----Original Message-----
From: DaleGindlesperger@xxxxxxxxxxx
[mailto:DaleGindlesperger@xxxxxxxxxxx]
Sent: Friday, April 11, 2003 10:07 AM
To: MAPICS ERP System Discussion
Subject: Re: AS400 Query Question



Nandagopal,

You will be quite disappointed in how limited Query/400 is if you are used
to SQL.  I will do this query for you and e-mail the print definition
directly to your listed e-mail account.  It's actually a very simple query
(easy for me to say!)

I would recommend looking at NGS-IQ as a supplement to using Query/400 -
it's what I feel that Query/400 should have "grown up" into.  And no, I
don't work for NGS, I just am a user that uses both.

Dale Gindlesperger
IT Manager
Fleetwood Folding Trailers, Inc.



                      "Nandagopal

                      Padmanabhan"              To:
<mapics-l@xxxxxxxxxxxx>

                      <npadmanabhan@xxxx        cc:

                      as-awt.com>               Subject:  AS400 Query
Question
                      Sent by:

                      mapics-l-bounces@x

                      idrange.com



                      04/11/2003 01:57

                      PM

                      Please respond to

                      MAPICS ERP System

                      Discussion







Hello Group,
I'm new to MAPICS and AS400 queries, but do have experience writing SQL
queries. I've been working on our MAPICS implementation for the last 4
months and this is the first time I'm writing AS400 queries. Basically, I'm
having trouble trying to incorporate GROUP BY aggregate function in an
AS400 query. I guess I haven't defined my report summary functions and
report breaks the right way. I would like to query ITEMBL file to get a
total on-hand inventory value for all warehouses. The SQL version of this
would look like this:

SELECT HOUSE, Sum(AVCST* MOHTQ) AS INVENTORY_VALUE
FROM ITEMBL
GROUP BY HOUSE

HOUSE = Warehouse
AVCST = Avg Unit Cost
MOHTQ = On Hand Total Quantity

I would like my report to look like this:

Warehouse          INVENTORY_VALUE
PBC                      $107,117.41
PBD                      $157,116.41
PBX                      $257,116.41

Any suggestions on how to accomplish the above will be appreciated. Could
you also point me towards good online documentation/books on AS400 queries.

Thanks,
Nandu
Nandagopal Padmanabhan | Vestas-AWT
(503) 327-2050 | npadmanabhan@xxxxxxxxxxxxxx



_______________________________________________
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.


_______________________________________________
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.






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