DB2

              


, , ( ) - .

1. , , :

CREATE VIEW _

AS SELECT _, ,

,

FROM S

WHERE = '';

(, , , , ) S.

2. , ( ):

CREATE VIEW _

AS SELECT _, ,

FROM S;

(, , , ) S.

3. , , :

CREATE VIEW __

AS SELECT _, ,

FROM S

WHERE = '';

S.

4. , . . SYSTABLES, , :

CREATE VIEW _

AS SELECT *

FROM SYSIBM.SYSTABLES

WHERE CREATOR = USER;

USER() , . SELECT, WHERE, SET UPDATE, INSERT. , SELECT WHERE ( UPDATE INSERT), . , , , , , . , , xyz :