User`s guide

Organization Of The Post-Export Parameter File
Exporting To Other Databases Data Export User’s Guide
E-2 Version 5.0rev1
Organization Of The Post-Export Parameter File
The .sprm file contains the following items, each on a separate line:
Output directory path The location of any output generated during
export. For ASCII exports, this is the location of
the ASCII delimited files.
Database name (Blank if none)
For each selected data type, the following fields are included:
Spectrum exported One of the following: Events, Statistics,
data type Model-Types, MT-Hierarchy, Models, Attributes,
Associations, Relations, Rules, Ext-Attributes.
Destination name Where the output resides. For ASCII output, this
is the name of the ASCII file in the Output
directory path. For SQL output, this is the name
of the table in the database. For SAS output, this
is the name of the dataset in the output directory.
For Events or Statistics exports, the following lines are also included:
Output Mode Whether the new data is to overwrite or be
appended to an existing table.
Data Range Start Beginning date/time for the requested data range.
This date/time is in mm/dd/yy hh:mm:ss format.
Data Range End Ending date/time for the requested data range.
This date/time is in mm/dd/yy hh:mm:ss format.
For example, an export of Relations and Models may have the following post-
export parameter file:
/usr/data/spectrum output directory path (where ASCII files reside)
ctrondb database name
Relations data type
relation destination name (file name for ASCII)
Models data type
model destination name (file name for ASCII)
A post-export parameter file for a Statistics export may look like this:
/usr/data/spectrum output directory path (where ASCII files reside)
ctrondb database name
Statistics data type
stat destination name (file name for ASCII)
append output mode
04/17/94 08:00:00 data range start
04/20/94 17:00:00 data range end