|
Today, all of the query tools use the QQQUERY engine, so they should all perform equally. Al Barsa, Jr. Barsa Consulting Group, LLC 400>390 914-251-1234 914-251-9406 fax http://www.barsaconsulting.com http://www.taatool.com Buck Calabro <Buck.Calabro@comms To: midrange-l@midrange.com oft.net> cc: Sent by: Subject: RE: AS/400 STILL wearing the undeserved "closed system" midrange-l-admin@mi moniker ( was PC connection via twinax ?) drange.com 08/20/01 09:47 AM Please respond to midrange-l >>>Can you write a 3rd party query tool that has the >>>same performance as RunQry? >>I have a command line interactive SQL. >>Does that count? >How does it work? Fundamentally, it uses a QMQRY template that is composed of all "substitution variables", a la &A&B&C&D&E... The command processor takes the single input (SQLSTM) and breaks it into the individual substitution variables, then passes the lot to STRQMQRY. >Does it call the undocumented qdm* pgms that rpg400 calls? Nope. Not even an API - it uses standard OS/400 commands wrapped with a little homegrown CL. >Is performance comparable to opnqryf and query? Exactly the same, because each of these (QMQRY, QRY/400 and OPNQRYF) use the same underlying DB support. >>>Could a 3rd party odbc driver be written for the 400? >>Already exist. >I assume the lack of documentation on this subject is >the smoke of the "interface not available" fire. I gather you haven't looked at the API manuals lately... >ps: I am aware of the qqquery api. But I could not figure it out >when I read it and did not see any reference to setll, >updat, add, etc. SETLL, UPDAT, ADD, etc. are RPG operation codes. Why would you expect to see information about these in the QQQQRY API reference? >>>If you write a 3rd party programming language, how do get >>>the objects referenced in a pgm written in that language >>>to be included in dsppgmref? >>Read Leif's MI book. > >I have. What page? All of them, sort of. Chapters 5, 7, 15 and 31 all have pertinent information. And just because I personally can't write say, a MIXAL compiler, that doesn't mean that it cannot be done. To extend that thought, just because nobody else has done it, that doesn't mean that it cannot be done. Most of us are application programmers - we write tools that help us generate applications. I'm quite convinced that several people on this very list have the skills and the internals knowledge to write a compiler, but they're probably busy with other stuff. That sounds cheeky, but it isn't. The point is that as a business machine, there are relatively few AS/400s in the hands of "casual machine level programmers." Buck _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com
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.