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