JOB_DEFINITION_REFS_V

The JOB_DEFINITION_REFS_V view displays information about the job streams in which a job appears.
Table 1. The JOB_DEFINITION_REFS_V view
Column name Description Type Length
Job_stream_wks_identifier The identifier of the workstation where the job streams in which the job appears are defined. character 16
Job_stream_wks_name The name of the workstation where the job streams in which the job appears are defined. string 16
Job_stream_folder_id The identifier of the folder containing the job stream in which the job appears. character 16
Job_stream_folder_name The name of the folder containing the job stream in which the job appears. string 801
Job_stream_identifier The identifier of the job stream in which the job appears. character 16
Job_stream_name The name of the job stream in which the job appears. string 16
Job_stream_valid_from The starting date from which the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Job_stream_valid_to The last date that the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Job_wks_identifier The identifier of the workstation where the job specified in the Job_definition_identifier column is defined. character 16
Job_wks_name The name of the workstation where the job specified in the Job_name column is defined. string 16
Job_folder_id The identifier of the folder containing the job. character 16
Job_folder_name The name of the folder containing the job. string 801
Job_name The name of the job that appears in the job stream. string 40
Job_definition_identifier The identifier of the job definition of the job specified in the Job_name column. character 16
Job_definition_name The name of the job definition of the job specified in the Job_name column. string 40
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's job stream. string 801
Job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job's job stream. string 16
Job_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job specified in the Job_name column. character 16
Job_wks_folder_name The name of the folder in which the workstation is defined. The workstation is of the job specified in the Job_name column. string 801
Job_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job specified in the Job_name column. string 16