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

Interesting.  Will check into this.

Fyi:
When I click on "Programmer's Guide' from http://jt400.sourceforge.net/,
I get The page you requested cannot be displayed error.

 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Friday, December 30, 2005 11:52 AM
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: Generic java class that will allow RPG/RPGSQLE program
toaccessnon-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