Nickname: USER.NICK_STAFF

Properties

Name: NICK_STAFF 
Schema: USER 
Wrapper: CONNECT 
Remote server: TEST 
Remote schema: USER 
Remote table: STAFF 
Readonly:  
Cached:  
Materialised view: USER.NICK_STAFF_MQT 
Status: NORMAL 
Create time: 01.07.2006 
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default 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)

Indexes

Name Unique rule Type Colnames Description
  USER.CC11517556264220  PRIMARY  REGULAR  ID   
Total: 1 index(s)

Dependent objects

Name
  USER.NICK_STAFF_MQT 
Total: 1 dependent 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)

See Also

List of nicknames