The Control Table is created first by using the name specified in the control table name variable when the master script workflow name_Run.sql is run
The structure of the Control Table is as follows:
CREATE TABLE "&WORKFLOW_OUTPUT"
(
NODE_ID VARCHAR2(30) NOT NULL,
NODE_NAME VARCHAR2(30) NOT NULL,
NODE_TYPE VARCHAR2(30) NOT NULL,
MODEL_ID VARCHAR2(30),
MODEL_NAME VARCHAR2(65),
MODEL_TYPE VARCHAR2(35),
OUTPUT_NAME VARCHAR2(30) NOT NULL,
OUTPUT_TYPE VARCHAR2(30) NOT NULL,
ADDITIONAL_INFO VARCHAR2(65),
CREATION_TIME TIMESTAMP(6) NOT NULL,
COMMENTS VARCHAR2(4000 CHAR)
)
See Also:
Table 7-2 for more information about the columns in the Control Table, their description and examples.
Parent topic: Control Tables