|
Thanks Rob. As I said to Vern, I may have mis-phrased my request. I'm looking for non-5250 tools to allow a non-AS/400 developer access SQL data on the iSeries, a la Query manager. Thankfully this is an actual SQL database with relationships. I'm trying to avoid command line training if possible. Loyd Goodbar Senior programmer/analyst BorgWarner E/TS Water Valley 662-473-5713 -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx Sent: Monday, September 12, 2005 11:47 To: Midrange Systems Technical Discussion Subject: RE: Data access for non-AS400 devs? 5250 supports: STRSQL. (as others have commented) Providing you have 57##ST1 loaded on your system. RUNSQLSTM (store your SQL source, like CREATE PROCEDURE, in a source member and execute it with RUNSQLSTM). I use this for where I used to use QDDSSRC. No additional program products needed. STRQMQRY. Store your SQL source in a source member. Run CRTQMQRY on it to "compile" it. Execute it with STRQMQRY. No additional software needed. STRQM. Provides a method to do prompted (like Query/400) or SQL method. If you had a choice between purchasing Query/400 or 57##ST1, buy 57##ST1 to also get the imbedded SQL capability. Imbedded SQL. Needs 57##ST1 loaded on your system. And some HLL compiler. Allows you to imbed SQL in a HLL program. For instance, if you wanted to write a RPG program and have it return a result set as a SQL stored procedure, comes in mighty handy. SQL CLI. Compiler of choice needed. Much more work than imbedded SQL. Has some minor capabilities not available to imbedded SQL. Only people who use it are: - Those who get a testosterone rush out of doing things the hard way. - Those who will not upgrade to V5R3 which fixed many of the limitations of the imbedded SQL precompiler - Those who do not have the means to purchase 57##ST1. - Those who need that one or two obscure little feature not supported by imbedded SQL. (See the sorcerers guide for more information.) But, for ad hoc, iSeries Navigator isn't bad. Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
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.