Re: SQL and MAPICS

[nathan.quinones@xxxxxxxxxx]

Joan,

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

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

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
http://www.cussys.com



                    "McCready, Joan"
                    <Joan.McCready@metalt        To:     "MAPICS-List (E-mail)" 
<mapics-l@midrange.com>
                    ekint.com>                   cc:
                    Sent by:                     Subject:     SQL and MAPICS
                    mapics-l-admin@midran
                    ge.com


                    02/22/2002 05:14 PM
                    Please respond to
                    mapics-l






Hi!

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

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             www.metaltekint.com
8600 Commercial Blvd
Pevely, MO  63070

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