JOB_STREAM_DEPS_V

The JOB_STREAM_DEPS_V view displays information about jobs and job streams that depend on a job stream.
Table 1. The JOB_STREAM_DEPS_V view
Column name Description Type Length
Type_of_dependency The type of dependency. Possible values are:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 33
Job_stream_wks_identifier The identifier of the workstation where the job stream on which the jobs or job streams depend is defined. character 16
Job_stream_wks_name The name of the workstation where the job stream on which the jobs or job streams depend is defined. string 16
Job_stream_folder_id The identifier of the folder that includes the job stream on which the jobs and job streams depend. character 16
Job_stream_folder_name The name of the folder that includes the job stream on which the jobs and job streams depend. string 801
Job_stream_identifier The identifier of the job stream on which the jobs and job streams depend. character 16
Job_stream_name The name of the job stream on which the job or job stream depends. string 16

Dep_job_stream_
wks_identifier

 The identifier of the workstation where the job stream that depends on the job stream is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the job stream is defined. string 16
Dep_job_stream_folder_id The identifier of the folder containing the job stream that depends on the job stream. character 16
Dep_job_stream_folder_name The name of the folder containing the job stream that depends on the job stream. string 801
Dep_job_stream_identifier The identifier of the job stream that depends on the job stream. character 16
Dep_job_stream_name The name of the job stream that depends on the job stream. string 16
Dep_job_stream_valid_from The starting date from which the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_stream_valid_to The last date that the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_wks_identifier The identifier of the workstation where the job that depends on the job stream is defined. If this field is not displayed, the job does not depend on any job stream. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the job stream is defined. If this field is not displayed, the job does not depend on any job stream. string 16
Dep_job_identifier The identifier of the job that depends on the job stream. If this field is not displayed, the job does not depend on any job stream. character 16
Dep_job_name The name of the job that depends on the job stream. If this field is not displayed, the job does not depend on any job stream. string 40
Dep_job_critical The job specified in the Dep_job_name column is a critical job. Possible values are:
Y
Yes
N
No
 character 1
Dep_job_folder_id The identifier of the folder containing the job that depends on the job stream. character 16
Dep_job_folder_name The name of the folder containing the job that depends on the job stream. string 801
Dep_job_definition_identifier The identifier of the job definition that depends on the job stream. If this field is not displayed, the job does not depend on any job stream. character 16
Dep_job_definition_name The name of the job definition that depends on the job stream. If this field is not displayed, the job does not depend on any job stream. string 40
Conditional_dep_id The identifier of the dependency where the output conditions are specified. Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 16
Condition_on_success The condition on SUCCESS status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 1
Condition_on_abend The condition on ABEND status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 1
Condition_on_fail The condition on FAIL status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 1
Condition_on_execute The condition on EXECUTE status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Condition_on_suppress The condition on SUPPRESS status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 1
Job_stream_identifier The identifier of the job stream on which the job or job stream depends. character 16
Join_id The identifier of the join containing more than one conditional dependency. Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 character 16
Join_name The name of the join containing more than one conditional dependency. Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 string 16
Join_quantity The number of dependencies that must be satisfied in the join specified by Join_name. Valid only for the Type_of_dependency column:
  • Job dependency
  • Conditional job dependency
  • Job stream dependency
  • Conditional job stream dependency
 integer 5
Job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream. character 16
Job_stream_wks_folder_name The name of the folder containing the workstation of the job stream. string 801
Job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream. string 16
Dep_job_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job stream on which the job or job stream depends. character 16
Dep_job_wks_folder_name The name of the folder in which the workstation is defined. The workstation is of the job stream on which the job or job stream depends. string 801
Dep_job_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream on which the job or job stream depends. string 16
Dep_job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream on which the job or job stream depends. character 16
Dep_job_stream_wks_folder_name The name of the folder containing the workstation of the job stream on which the job or job stream depends. string 801
Dep_job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream on which the job or job stream depends. string 16