RE: Generic java class that will allow RPG/RPGSQLE program toaccess non-iSeries Data

I've got an idea, Lim.  How about defining a data structure that you pass a
pointer to.  The data structure looks like this:

d SQLVar          ds                                   
d   vartype                      3u 0                  
d   alphavar                    64                     
d   binary                      20u 0 overlay(alphavar)
d   decimal                     30s15 overlay(alphavar)
d   logical                       n   overlay(alphavar)

Your getColumn routine would take a pointer to this data structure, and then
would load the data depending on the column type.  The vartype field would
get set to identify the type of data coming back.

Obviously my little data structure has some specific limitations, such as a
maximum alpha field size of 64.  You'd have to set the limits as you saw
fit.  You might also want to have an error code field just in case (for
example, if you had a data type such as BLOB that you couldn't handle or if
the data exceeded your limits).

This is about the cleanest way I can figure out how to do this.  Your
application would call the service program's getColumn method with the
column index (or name) and a pointer to this structure.  Your service
program would be responsible for passing the data structure to the Java
method as an array of 3u0 bytes, and the Java method would get the column
value into a Java variable using standard JDBC routines and then use an
appropriately initialized AS400Structure object to convert the Java variable
(along with the varitype field and any other information) into the array of
bytes.

Joe
 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
> Sent: Friday, December 30, 2005 11:26 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Generic java class that will allow RPG/RPGSQLE program
> toaccess non-iSeries Data
> 
> - My plan is to create a java class as mentioned in the original thread.
> - I'll then create a RPG service program with all the necessary export
> procedures to access all those java methods.  This will hide the complex
> coding needed to call java method.
> 
> ***
> The biggest concern is column mapping.  I have no clue as how to create
> a generic getColumn() that convert the coulmn data into a RPG variable.
> 
> 
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of David Gibbs
> Sent: Friday, December 30, 2005 10:55 AM
> To: Java Programming on and around the iSeries / AS400
> 
> Another possibility ... and I have *ZERO* idea how hard this would be to
> implement .. would be to try and do the JDBC request to the other
> database directly from RPG using prototyped java calls.
> 
> Just a thought.
> 
> david
> 
> --
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/java400-l.
> 
> 
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.