HCL Workload Automation, Version 9.4

PROMPT_REFS_V

The PROMPT_REFS_V view displays information about jobs and job streams that depend on a prompt.
Table 1. The PROMPT_REFS_V view
Column name Description Type Length
Prompt_identifier The identifier of the prompt on which the jobs and job streams depend. character 16
Prompt_name The name of the prompt on which the jobs and job streams depend. string 148
Prompt_text The text associated with the prompt. string 200
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the prompt specified in the Prompt_identifier column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the prompt specified in the Prompt_name column is defined. string 16
Dep_job_stream_identifier The identifier of the job stream that depends on the prompt specified in the Prompt_identifier column. string 16
Dep_job_stream_name The name of the job stream that depends on the prompt specified in the Prompt_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 prompt specified in the Prompt_identifier column is defined. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the prompt specified in the Prompt_name column is defined. string 16
Dep_job_name The name of the job that depends on the prompt specified in the Prompt_name column. string 40
Dep_job_identifier The identifier of the job that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_definition_identifier The identifier of the job definition that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_definition_name The name of the job definition that depends on the prompt specified in the Prompt_name column. string 40