######################################################################
#
# Copyright 1997 Petrotechnical Open Software Corporation
#
# POSC grants permission to copy or reproduce this material in its
# original form for internal use only.
#
# This software is subject to the provision of the "POSC Software
# License Agreement" which states in part:
#
# 1) Licensee accepts a non-exclusive, non-transferable, license
# to use, display, modify and distribute works derived from the
# licensed documentation and Software Product.
#
# 2) Licensee shall have no right to distribute in its original
# form any Software Product or documentation licensed under this
# agreement.
#
######################################################################
######################################################################
#
# (c) Copyright 1997 Petrotechnical Open Software Corporation
#
######################################################################

This bin directory contains all database builder and meta data loader scripts
for oracle, sybase and informix. A simple script called Builder is a general
builder for all three kinds of databases. As long as the user sets up the
correct environment variables, this Builder will take care of everything
from dropping tables to loading reference data. In each subdirectory, there
are four common scripts:
  1: pds_drop.csh which drops all tables and views owned by user 
     $POSC_DBUSER. Be sure there are no valuable objects under this user
     when running this script.
     Usage : pds_drop.csh
  2: pds_meta_load.csh is used to load meta data and dstore_uom data.
     It is invoked for each '.dat' file in the pds_root/models/epic.2.2/export
     subdirectory. This same script is used to load the dstore_uom data from
     the file pds_root/pds_data/ref_data/v2.2/dstore_uom/dstore_uom.dat.
     Usage : pds_meta_load.csh <data_file>
  3: pds_refent.csh which is used to load logical reference data using
     refLoadLevelOne and it calls pds_meta_load.csh described above. 
     Usage : pds_refent.csh
  4: Builder calls the above scripts and also sets up the whole data
     store. Actually it will take care of everything from cleaning user tables
     setup new tables of epicentre model and loading meta data and reference 
     data.
     Usage : Builder
In the oracle directory, a script named pds_status.csh is used to inquire the
status of this data store owned by the user of $POSC_DBUSER including tables,
index, constraints, etc. 

[Return to text file]
[Return to Getting Started Introduction]