[lflor]

Just wondering, what version of DB2 do I need to be at to be able to get updateable result sets in the database explorer? Or is this unsupported for DB2?

[support-jeff]

Updating values is a feature of DE. Right-click on a table and select Edit Table Rows and away you go…and of course, doing an UPDATE table SET … from the SQL Editor is just fine too.

To do the Direct Table Edit, you do have to have a JDBC driver that supports RowSets and ResultSet.TYPE_SCROLL_SENSITIVE and ResultSet.CONCUR_UPDATABLE – JDBC 2.0 features. You will need to check your JDBC driver documentation to figure out if it is supported.

[Riyad Kalla]

NOTE: I removed my comment to avoid confusion… with it being totally wrong and all 😉

[Author]

Posts