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)" <email@example.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-Lfirstname.lastname@example.org 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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.