Properties

Name: QQQ_STAFF_MQT 
Schema: USER 
Cached schema: USER 
Cached table: USER.QQQ_STAFF 
Tablespace: QQQ_STAFF_MQT_TS 
Definer: USER 
Readonly:  
Valid:  
Qualifier: USER 
Description:  

Columns

Name Type Length Scale Codepage Nulls Description
  ID  SMALLINT     
  NAME  VARCHAR  1251     
  DEPT  SMALLINT     
  JOB  CHARACTER  1251     
  YEARS  SMALLINT     
  SALARY  DECIMAL     
  COMM  DECIMAL     
Total: 7 column(s)

Depend on objects

Name
  USER.QQQ_STAFF 
Total: 1 object(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE 
Total: 1 autherisation(s)

SQL

CREATE TABLE USER.QQQ_STAFF_MQT AS (SELECT * FROM "USER".QQQ_STAFF) DATA INITIALLY DEFERRED REFRESH DEFERRED MAINTAINED BY FEDERATED_TOOL IN QQQ_STAFF_MQT_TS

See Also

List of materialised views