These scripts are a useful tool for verifying the process of creating usedsets. They take the input of PROCESS_NAME, PASSNAME, a run list and a table list, and output the cid's for each run for these tables. A new run is only printed on the output if its cid's for these tables differ from the last one.

Limitations as of Feb 6th 2004 : Max number of tables in one execution of the script is 10. Max number of files encompassed in the runlist file is appx 2000.

Documentation is mainly in the scripts themselves (especially the .bash script). Start with the README file which is bascially reproduced below

Links to the Files in this direcotory:

• get_cid_tables.bash : Parent bash script (make sure bash is in the place where this script assumes on the first line)
• addRuns.perl : perl script which builds the pl/sql script out of the runlist (make sure perl is where this script assumes it is on the first line)
• analyse_sql.perl : perl script which analyses the output to the pl/sql script (make sure perl is where this script assumes it is on the first line)
• get_cid_tables_template.sql : pl/sql template for the dbase queries.
• runlist.txt : example runlist file
• tablelist.txt: example table list file.
• scripts.tar : tar ball of all the above files.

Example output:

=================================================
Results (not including runs where no cids changed)
Format is Run in left column, then cids for tables
in the columns under the respective table names
=================================================


Run:                TSUALL              TSUCHANNEL          WHAEFFICIENCY       WHALINERESPONSE     WHAOFFLER           WHAPMTDEADCHANNELS  WHASLEWING

155150              56723               56725               102492              77710               188904              181119              102486

152747              56723               56725               102492              77710               188904              181117              102486