update_db_tool

Usage: update_db_tool -r resource_file_name -t data_id ipppssoot

Normal operational procedure should be to run the command in pipeline mode. In interactive mode the user must specify the task resource file, the data id, and the ipppssoot name.

Inputs

For interactive mode only, the data id, the ipppssoot, and the task resource file which contains the SQL statements must be specified.

Successful completion of the command will run the SQL statements in the resource file on the target database specified in the resource and path files.

tufnel> update_db_tool -r hkp_sci -t wf2 u5js0404r

2004181132109-I-INFO Starting processing. (1)

2004181132109-I-INFO Opus_env::get_path_override -OK_TO_UPDATE_DATABASE value substituted with a global value in /home/heller/opus/def/null.path: TRUE (1)

2004181132109-I-INFO Initialized OPUS environment. (1)

2004181132109-I-INFO Opus_env::get_res_item ARCH_DB substituted with path value dadsopscopy (1)

2004181132109-I-INFO Opus_env::get_res_item OPUS_DB substituted with path value opusdev3 (1)

2004181132109-I-INFO Registered callbacks. (1)

2004181132109-I-INFO QUERY.03.ZERO_RECORDS_ALLOWED not specified (1)

2004181132109-I-INFO 1 records updated for

update dadsopscopy..science set

sci_generation_date = ads_generation_date,

sci_release_date = ads_release_date

from dadsopscopy..archive_data_set_all

where sci_data_set_name = "U5JS0404R" and

ads_data_set_name = "U5JS0404R" and

ads_archive_class="CAL" and

ads_best_version="Y"

(1)

2004181132109-I-INFO QUERY.04.ZERO_RECORDS_ALLOWED not specified (1)

2004181132109-I-INFO 1 records updated for

update dadsopscopy..archive_data_set_all set

ads_instrument = sci_instrume,

ads_program_id = sci_program_id,

ads_obset_id = sci_obset_id,

ads_obsnum=sci_obsnum,

ads_pep_id=sci_pep_id,

ads_start_time = sci_start_time,

ads_end_time=sci_stop_time

from dadsopscopy..science

where sci_data_set_name = "U5JS0404R" and

ads_data_set_name = "U5JS0404R" and

ads_archive_class="CAL" and

ads_best_version="Y"

(1)

2004181132109-I-INFO 0 records updated for

update dadsopscopy..archive_data_set_all set

ads_instrument = null,

ads_program_id = null,

ads_obset_id = null,

ads_obsnum= null,

ads_pep_id= null,

ads_start_time = null,

ads_end_time = null

from dadsopscopy..science

where sci_data_set_name = "U5JS0404R" and

ads_data_set_name = "U5JS0404R" and

ads_archive_class="CAL" and

ads_best_version != "Y"

(1)

A valid resource file, ipppssoot, and data id are supplied in the command line.

ipppssoot

The ipppssoot used in the query.

$ update_db_tool -r hkp_sci -t wf2 u5js0404r
This command will run the SQL statements for data id, wf2, in the resource file, hkp_sci.resource. The rootname, u5js0404r, will be used as part of the query's where statement.