Re: Closed system (was: PC connection via twinax ?)

R
Hello Steve,

You wrote:
>What api's do they call?

<---- stuff deleted ---->

>Is that documented?  How is that space built?

So you want me to do the investigation for you ... :)

There are the SQL CLI, SQL APIs, and the QQQQRY API for the adventurous.
The input to QQQQUERY is a Query Definition Template or QDT.  This is
exactly the same structure that is used by Rochester, and some vendors, to
get the query engine to do its work (Query/400, OPNQRYF, etc).  Rochester
have said that this API will not be enhanced to handle new DB features so
that leaves the CLI and the various SQL APIs for those wanting access to the
DB.  You could also use SQL directly.

The where-used space is not publicly documented (as far as I know) but it is
part of the Object Information Repository (OIR).

I think Leif may have written something about this space in his book (which
I don't have 'cause I'm waiting for the Australian exchange rate to improve
-- it might be a long wait :), however it's not difficult to decipher the
where-used space from a program dump.  It's basically a count of references
as a BIN(2), followed by an array of objects in the form: object name as
CHAR(10), a CHAR(1), object library as CHAR(10), another CHAR(1), object
type as CHAR(1), and object subtype as CHAR(1).

If you want to know more than that you'll have to do your own research.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\   «»
«» Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /   «»
«»                                                           X    «»
«»               ASCII Ribbon campaign against HTML E-Mail  / \   «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»