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	2	0	0
	NAME	VARCHAR	9	0	1251
	DEPT	SMALLINT	2	0	0
	JOB	CHARACTER	5	0	1251
	YEARS	SMALLINT	2	0	0
	SALARY	DECIMAL	7	2	0
	COMM	DECIMAL	7	2	0

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