Previous Topic: SYSTEM.RESOURCEAUTHNext Topic: #SATTDS


SYSTEM.RESOURCEGROUP

Purpose

A row of this table represents an SQL schema resource group. A row of this table is stored when one of these events occurs:

Columns

Column name

Data type

Description of contents

RESOURCETYPE

CHAR(4)

The code for the resource group:

  • 'QSCH'—SQL schema

RESOURCENAME

CHAR(60)

The schema name.

OWNER

CHAR(18)

The authorization ID of the user or group who owns the schema.

CATEGORYNO

SMALLINT

(Not applicable—initialized to zero.)

FUNCTIONASSIGNMT

BINARY(1)

(Not applicable—initialized to space.)

CTIME

TIMESTAMP

Time created.

UTIME

TIMESTAMP

Time of the last update.

CUSER

CHAR(18)

ID of the user who created the resource group.

UUSER

CHAR(18)

ID of the user who last updated the resource group.

FILLER

BINARY(19)

(Reserved—initialized to spaces.)