| |
The schema utility is used to define the database and its structure in the system catalog.
After checking the syntax and validity of the specified schema file, the schema processor
uploads the catalog information to the database server. As of Eloquence B.08.20 a successful
schema upload also performs the dbcreate step, allocating resources for dataset storage.
usage: schema [options] file
options:
-help - show usage (this list)
-u user - set user name
-p pswd - set password
-h host - host to contact
-s service - service name or or port number
-d flgs - debug flags
-b name - specify database name
-l - output source listing (LIST)
-n - no root file, only check syntax (NOROOT)
-t - output set table (TABLE)
-e cnt - Abort after cnt error messages (ERRORS=)
-T - TurboIMAGE compatibility mode
-W width - Limit line length to width
-L - Add line number to source listing
-w id[,id] - Suppress specified warning messages
The options are:
- -help
- The -help option displays a brief help text.
- -u user
- The -u option specifies the database user (or a file
holding the database user and/or password).
Defaults to the dba user unless a default user is
specified with the EQ_DBUSER
environment variable.
- -p password
- The -p option may be used to specify the password
for the database user (or a file holding the password).
If not specified, the password is obtained using the
EQ_DBUSER
and/or EQ_DBPASSWORD
environment variables.
- -h host[:service]
- The -h option may be used to specify the database server host
name (or IP address) and service name (or TCP port number).
Defaults to localhost:eloqdb unless a default instance is specified
with the EQ_DBSERVER environment
variable.
- -s service
- The -s option may be used to specify the service name or TCP port
number of the database server.
Defaults to eloqdb unless a default instance is specified
with the EQ_DBSERVER environment
variable.
- -d flags
- The -d option specifies debug flags and is normally not used.
- -b name
- The -b option allows to specify a database name (overriding the schema file).
- -l
- The -l option displays a listing of the schema analysis to stdout.
- -n
- The -n option tells the schema program not to generate the database catalog.
This option is useful for performing a syntax check of the schema file.
- -t
- The -t option displays a table of sets (summary of info about the datasets).
- -e cnt
- The -e option sets the number of errors allowed before schema processing aborts.
- -T
- The -T option enables TurboIMAGE compatibility mode for schema processing.
This mode is useful for databases migrated from HP 3000 systems to Eloquence and
alters the rules for schema syntax, item types and item size units.
- -W width
- The -W option specifies the maximum line length of the listing output, if any.
- -L
- The -L option adds line numbers to the listing output, if any.
- -w id[,id ...]
- The -w option may be used to suppress the specified warning messages.
- As of Eloquence B.08.20 the dbcreate step is no longer required. A successful
run of schema or dbschema also performs the corresponding resource allocation.
The following example invokes the schema processor in "dry run" mode to only check the
syntax and validity of the file MyDB.sch and uses the -t option to also display a table
with dataset summary information. Then it invokes the schema processor without the -n
option to actually upload the catalog info to the database server, overriding the database
name in the schema file by specifying the -b option on the command line:
schema -n -t MyDB.sch
schema -b TestDB MyDB.sch
dbschema,
dbcreate,
dberase,
dbpurge,
prschema.
Database Definition chapter in Eloquence Database Manual.
Eloquence TurboIMAGE compatibility
|
|
