The DB2eStatement class gets and sets certain Statement attributes. To use the DB2eStatement class methods on a Statement object, the Statement object must first be cast to a DB2eStatement object. These methods are implemented by calls to the CLI/ODBC functions SQLGetStmtAttr and SQLSetStmtAttr with the appropriate arguments.
com.ibm.db2e.jdbc package
public class DB2eStatement
implements Statement
Tabelle 108 lists the methods in the DB2eStatement class supported by
DB2 Everyplace.
Tabelle 108. DB2eStatement class methods
| Method return type | Method |
|---|---|
| void | enableDeletePhysicalRemove(boolean enable) Enables or disables physically removing records, regardless of their dirty bit values, in a DELETE SQL statement. |
| void | enableDirtyBitSetByApplication(boolean enable) Enables the application mode if enable is true. Otherwise, enables the system mode. |
| void | enableReadIncludeMarkedDelete (boolean enable) Makes logically deleted records visible or invisible. |
| void | enableReorg (boolean enable) Enables or disables database reorganization by DB2 Everyplace or explicitly by the user with a REORG SQL statement. |
| boolean | isEnabledDeletePhysicalRemove() Will a delete SQL statement physically remove the records regardless of their dirty bit values? Or will the records only be marked as "delete"? |
| boolean | isEnabledDirtyBitSetByApplication() Is the database system in the application mode? Or is it in the system mode? |
| boolean | isEnabledReadIncludeMarkedDelete() Are logically deleted records visible from SQL statements? Or are these records hidden from SQL? |
| boolean | isEnabledReorg() Can database reorganization be done by DB2 Everyplace or explicitly by the user with a REORG SQL statement? Or are REORG SQL statements restricted and is the automatic database reorganization of user-created tables disabled? |
In these examples, st represents a Statement object, and rs represents a ResultSet object.
To physically remove some records from table T ignoring the status of the dirty bits:
DB2eStatement db2e_st = (DB2eStatement) st;
db2e_st.enableDeletePhysicalRemove(true);
st.executeUpdate("DELETE FROM T WHERE X<>0");
To read all records in table T with the dirty bit set, including those with dirty bit marked as DELETE:
DB2eStatement db2e_st = (DB2eStatement) st;
db2e_st.enableReadIncludeMarkedDelete(true);
rs = st.executeQuery("SELECT * FROM T WHERE $dirty<>0");
To clean the dirty bit of a record in table T:
DB2eStatement db2e_st = (DB2eStatement) st;
db2e_st.enableDirtyBitSetByApplication(true);
st.executeUpdate("UPDATE T SET $dirty=0 WHERE $dirty>0");
Zugehörige Tasks
Zugehörige Referenzen