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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.