These scripts were designed for verifying the results of the streams testing in Feb 2004. The way the streams were tested was to run the calibration simulation on the integration database and then this was streamed accross to cdfrep23 (another database on a different machine).

Then what these scripts do is take the process_run list (stored in a file called runfile output by the calibration simulation) and execute an sql script for each one. The README file tells you more about it.

The main complication with this pl/sql script was that I needed to take a list of table names generated from looking up a list of cid's from CALIBRUNLISTS, and then go and look at these tables.

pl/sql doesn't like to put the names of tables (schema objects) in basic sql queries when you try them as variables.

So you have to make a dynamic sql query.

In addition, if the result is multi-row, you have to loop over it using a cursor. And the way you use a cursor for dynamic sql is different for just the plain old sql...anyway, take a look at the scripts below for more info:

• run_check_sim_results.bash is the parent bash script which iterates over the process_run values in runfile and executes the sql.
• check_sim_results.sql is the actual pl/sql script.
• runfile is an example runfile for executing the bash script with.
• README is a text file with usage information.