RE: AS400 Query Question

Thanks so much!  I have looked around for something like that!

The document from MAPICS (Doc ID# 373300) is severely inadequate for the 
task, but
I was forced to do some things the hard way to get MAINCOR functioning.

Thanks again - this HAS been a great thread!






"Ron Hankey/PEMSTAR Inc" <Ron.Hankey@xxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
04/11/2003 02:10 PM
Please respond to MAPICS ERP System Discussion
 
        To:     mapics-l@xxxxxxxxxxxx
        cc: 
        Subject:        RE: AS400 Query Question


You don't need SQL400 to run SQL statements. Here is the URL for a
command called EXCSQLSTM which you can download and compile
on your AS/400: http://www.mcpressonline.com/ftp/prog/94/b941207.txt

It allows you to run just about any SQL statement. Since it's not SQL400 
you don't get 
the ability to embed SQL in RPG/COBOL programs or create stored procedures 

or prompt for field names. 
(Here's a nice tool for displaying field names 
http://www.bvstools.com/lstffd.html )
I used the EXCSQLSTM command for several years before we finally got the 
SQL400 product. 
There's also an option to print if you need to create a report.


Strange, Tim wrote:
>Some of us don't have SQL400....


Ron Hankey - CPIM
Applications Programmer
_______________________________________________
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.