Re: Exposing existing ISeries Queries in JAVA

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hi Eddie,

> Is there a process of exposing legacy Iseries Queries in Java?

    I don't think anyone will be able to give a good answer without more
information like: from a QRYDFN or ...?  Do you want to process the report,
the data - what is the output needed?

    The simplest way to get to the output is to RUNQRY with output to disk,
then read the file with the Java program.  That's probably unacceptable,
unless you can live with a snapshot, because of the process, write, read,
process time.

    RUNQRY only offers output to the display, printer or to a file.  Query
Management allows embedding in native ( non-Java ) programs, but
"does not pass back data to the program", so in the sense of getting and
processing the data, queries aren't "exposed" to any language on the '400.

    It is possible to convert QRYDFN *selections*, including joins and on
the fly field defintions to SQL - although they may be incomplete - and run
that from a Java app to get and process the data.  While in some sense it is
possible to get the report formatting, the meaning of the formatting data is
not openly documented by IBM, to my knowledge.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO         -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?             http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Urfer, Eddie" <UrferE@xxxxxxxxxxxxxx>
To: <JAVA400-L@xxxxxxxxxxxx>
Sent: Monday, July 12, 2004 12:01 PM
Subject: Exposing existing ISeries Queries in JAVA


>
>
> Is there a process of exposing legacy Iseries Queries in Java?
>
>
> Thanks
>
> Eddie Urfer
>