Re: Inserting packed values into a DB2/400 table via JDBC

[Marshall Dunbar/DPS <marshall@xxxxxxxxxxx>]

You are making things way too difficult.  The SQL processor on the 400 
will take care of packing the data for you.  Just create an SQL string 
containing:

INSERT INTO IT005P (ITEM_NUMBER) VALUES(47001)

and execute it.
===
Marshall Dunbar
DPS, Inc.
marshall@xxxxxxxxxxx
direct:(828)635-5561
main office:(317)574-4300 (800)654-4689
====



EDoxtator <doc6502@xxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/28/2004 10:37 AM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
java400-l@xxxxxxxxxxxx
cc

Subject
Inserting packed values into a DB2/400 table via JDBC






Hi All

I've got a table that has several packed columns.  How do I insert packed
values into this table from a Windows PC via JDBC?  I'm using JTOpen 4.5.

Here is a snippet of the code I'm using to try and create the value:

Connection con = null;
com.ibm.as400.access.AS400PackedDecimal a = new 
     com.ibm.as400.access.AS400PackedDecimal( 7, 0 );

::: snipped connection code :::

   // Create and execute SQL Insert 
   Statement stmt = con.createStatement();
   byte[] b = a.toBytes( new BigDecimal( 47001 ) );
   String value = b.toString();

   String SQLStmt =
                 "INSERT INTO IT005P " +
        "(ITEM_NUMBER) " +
        "VALUES(\"" + value + "\")";

   ResultSet rs = con.execute( SQLStmt );

::: remainder of program snipped :::

Of course, what I see if I log the SQL statement is:

SQL Statement = INSERT INTO IT005P (ITEM_NUMBER) VALUES("[B@16672d6")

Error: [SQL0206] Column "[B@16672d6" not in specified tables.

If anyone has any ideas, I'd really appreciate it.

Thanks!

-Ed


--
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.