KENV_MAINFRAME_PARAMS

This table is only used to store the Mainframe Parameters for JCL executions. Information from the Mainframe Data tab on an environment is stored here. A parameter is used to dynamically change the contents of a JCL script. It converts a template JCL script into something usable for submission.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KENV_ENVIRONMENTS	ENVIRONMENT_ID	ENVIRONMENT_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PARAMETER_ID	NOT NULL	NUMBER	System-generated identifier
ENVIRONMENT_ID	NOT NULL	NUMBER	Environment associated with this parameter
TOKEN	NOT NULL	VARCHAR2(30)	Not used. Reserved for future use
EXPRESSION	NULLABLE	VARCHAR2(200)	Regular expression to search for
SUBSTITUTION	NULLABLE	VARCHAR2(200)	Substitution text
GLOBAL_FLAG	NOT NULL	VARCHAR2(1)	IF 'Y', the substitution is a global one for the entire line
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record

Indexes

Index Name	Index Type	Sequence	Column Name
KENV_MAINFRAME_PARAMS_U1	UNIQUE	1	PARAMETER_ID

Sequences

Sequence Name	Sequence Type
KENV_MAINFRAME_PARAMS_S	PARAMETER_ID