I have created a table on the AS400 via OpenOffice using a JDBC connection. The table has a primary key.
the problem is that the table shows as read-only in OpenOffice data source view, but when I use SQL... from OpenOffice I can issue insert statements and insert data into the table.
any ideas? anyone able to work with OpenOffice+JDBC on AS400 tables.