KNTA_PREPARED_COMMANDS

This table stores the commands that have been parsed and are ready for execution. Runtime tokens cannot be parsed prior to execution. These conditions are stored in this table and can be evaluated by Command Execution Engine during execution. For each row in the KNTA_COMMANDS table, there is one row in this table for a given command provided the command condition is true or can only be determined at run-time.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_COMMANDS

COMMAND_ID

COMMAND_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PREPARED_COMMAND_ID

NOT NULL

NUMBER

System-generated identifier

GROUP_ID

NOT NULL

NUMBER

System-generated group identifier

SEQ

NOT NULL

NUMBER

Sequence in which the commands are executed

CONDITION

NULLABLE

VARCHAR2(4000)

Contains the parsed command condition to be evaluated at run-time. This field is blank for conditions that have been evaluated to true at time of parsing.

COMMAND_ID

NOT NULL

NUMBER

Identifier for the command that is being parsed

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PREPARED_COMMANDS_N1

NONUNIQUE

1

GROUP_ID

KNTA_PREPARED_COMMANDS_U1

UNIQUE

1

PREPARED_COMMAND_ID

Sequences

Sequence Name

Sequence Type

KNTA_EXEC_GROUP_IDS_S

GROUP_ID

KNTA_PREPARED_COMMANDS_S

PREPARED_COMMAND_ID