Answer Posted / s
Audit records the SQL statement executed against the table,
the AUTHID and the timestamp. AUDIT ALL records INSERT,
UPDATE, DELETE, SELECT. AUDIT CHANGES records INSERT,
UPDATE, DELETE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a dbrm in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
can all users have the privilage to use the sql statement select * (dml)?
What is a buffer in memory?
What is nvl in db2?
Explain packages.
What is the syntax for seeing the columns and data types of a table in the db2 database?
Is db2 a mainframe?
What is view db2?
What is the latest version of ibm db2?
What are the 2 sqlcodes that are returned?
How do you select a row using indexes in db2?
What is access path in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?