Re: accessing db2/400 data and issues with Packed fields

 There should be no problem accessing the data with
either JDBC or the RLA classes. Both of these methods
treat the Packed Numeric data as a java BigDecimal.
The calls look like this.

  JDBC---------------------------------------------
    BigDecimal someField =
rset.getBigDecimal(columnIndex);

  RLA----------------------------------------------
    
    BigDecimal someField = (BigDecimal)
record.getField("COLUMN_NAME");

I hope this helps. If you are going to be useing the
JDBC stuff check out what AS/400 datatypes map to what
JDBC field types in the Java Toolbox for AS400
programmers manual. It should help you out quite alot.







--- Jack Levin <jlevin@icubed.com> wrote:
> Hello,
> 
> I am an AS/400 newbie and am looking into accessing
> data on the as/400 from a remote application (Java
> app on an App server).  Not sure which development
> platform we are going to use.  Mabye VAJ or
> JBuilder.
> 
> Anyway, the data I will be accessing (db2/400 data)
> is of the packed type.  Do I need to be concerned
> about this? In other words, do I need to do any
> special programming for that or is there a way to be
> abstracted from it?
> 
> Also, I was thinking of using DB2 Connect so I could
> have JDBC access to the data.  If I use DB2 connect,
> will that abstract me from the packed data issue?
> 
> If there is a better way, please share.
> 
> Any advice is so appreciated.
> 
> Thanks.
> --
> Jack Levin, jlevin@icubed.com
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---