An application process acquires at least a share lock on the current row of every cursor.

Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.

Any row changed by another application process can be read, even if the change has not been committed by that application process.

An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.

The next value will be 0 and the sequence will never use the values 101 to 105.

The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

MQT

Trigger

Read Only Cursor

Stored Procedure

REVOKE SELECT FROM user2 ON TABLE org.tab1

REVOKE SELECT ON TABLE org.tab1 FROM user2

REVOKE READ ACCESS FROM user2 ON TABLE org.tab1

REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

SORT BY age ASC, last_name

SORT BY age DESC, last_name

ORDER BY age DESC, last_name

ORDER BY age ASC, last_name

Alias

View

Schema

Trigger

0

1

3

6

20

25

50

55

CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );

CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );

CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );

CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );

Flat earth

3-D Square

Trapezoidal

Round earth