|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.