HCL Workload Automation, Version 9.4

FILE_REFS_V

The FILE_REFS_V view displays information about jobs and job streams that depend on a file.
Table 1. The FILE_REFS_V view
Column name Description Type Length
Workstation_identifier The identifier of the workstation where the file is defined. character 16
Workstation_name The name of the workstation where the file is defined. string 16
File_identifier The identifier of the file on which jobs and job streams depend. character 16
File_name The name of the file on which jobs and job streams depend. string 148
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the file specified in the File_name column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the file specified in the File_name column is defined. string 16
Dep_job_stream_identifier The identifier of the job stream that depends on the file specified in the File_identifier column. character 16
Dep_job_stream_name The name of the job stream that depends on the file specified in the File_name column. 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 file specified in the File_identifier column is defined. If this field is not displayed, the job does not depend on any file. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the file specified in the File_name column is defined. If this field is not displayed, the job does not depend on any file. string 16
Dep_job_identifier The identifier of the job that depends on the file specified in the File_identifier column. If this field is not displayed, the job does not depend on any file. character 16
Dep_job_name The name of the job that depends on the file specified in the File_name column. If this field is not displayed, the job does not depend on any file. string 40
Dep_job_definition_identifier The identifier of the job definition of the job that depends on the file specified in the File_identifier column. If this field is not displayed the job does not depend on a file. character 16
Dep_job_definition_name The name of the job definition of the job that depends on the file specified in the File_name column. If this field is not displayed the job does not depend on a file. string 40