RE: AS/400 STILL wearing the undeserved "closed system" moniker ( was PCconnection via twinax ?)

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