Server (Cells) Architecture Home
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

The information related to the status of the query is stored in the QT_QUERY_INSTANCE table.

QT_QUERY_INSTANCE

 

 

 

Key

Column Name

Column Definition

Nullable?
(Default = YES)

PK

QUERY_INSTANCE_ID

Unique id for the query

NO

FK

QUERY_MASTER_ID

Many to one reference to the query master table

NO

 

USER_ID

The user's login id

NO

 

GROUP_ID

The project id

NO

 

BATCH_MODE

The name of the queue in which the query is running or last ran

YES

 

START_DATE

The date the query was started (run)

YES

 

END_DATE

The date the query finished running

YES

 

DELETE_FLAG

A flag that denotes whether or not the query was deleted. (Y / N)

NO

FK

STATUS_TYPE_ID

Reference to the QT_STATUS_TYPE table

NO

 

Message

To store the query error message, warning, etc.

YES



  • No labels