I use a 2 different options for SQL on the 400.
1) STRSQL from an AS/400 command line takes you into an interactive SQL
session allowing you to select/update/delete/insert records in a file.  The
prerequisite is licensed program 57xxST1 (DB2 Query Mgr and SQL DevKit for
AS/400).  You'll know if you have based on whether or not the STRSQL
command even exists.  By the way, library and file names are specified they
way we know and love LIBRARY/FILE.  Results are brought back to the green

2) In AS/400 operations navigator, under your AS400 connection, if you
click on Database, an icon (blue with spreadsheet and gears) appears across
the toolbar area that allows for running of interactive  SQL statements.
That will open a window where you can run any SQL statement against any
file on the 400.  This works regardless of whether you have the above
mentioned licensed program.  In this SQL environment, the library and file
names are specified as LIBRARY.FILE.  Results are brought back in a
spreadsheet type window that allows for easy cut and paste into Excel.

Be careful with SQL as you can easily destroy the contents of a file in one

If you ever hear someone say oops while doing SQL, it is not a good thing!

Happy SQLing!
Nathan Quinones
Custom Systems Corp
973-726-0202 x213

                    "McCready, Joan"
                    <Joan.McCready@metalt        To:     "MAPICS-List (E-mail)" 
          >                   cc:
                    Sent by:                     Subject:     SQL and MAPICS

                    02/22/2002 05:14 PM
                    Please respond to


I have just finished Intro to, Intermediate Applications of and Adv Appls
SQL through our local univeristy continuing ed program. I am now thoroughly

What tool do those of you who use SQL use with MAPICS / AS/400? We don't
have (and really don't need) MS SQL Server. Any suggestions?

I've played with Access today, and can query MAPICS files, but can't update
- or at least I haven't found the magic button yet.

Have a good weekend  -- Joan

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International               fax:  636-479-3399
The Carondelet Division   
8600 Commercial Blvd
Pevely, MO  63070

This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

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