contact contact

schema utility

» Usage | Notes | Examples | See also
  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
 -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:
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).

The -l option displays a listing of the schema analysis to stdout.

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.

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.

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.

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

See also

dbschema, dbcreate, dberase, dbpurge, prschema.

Database Definition chapter in Eloquence Database Manual.

Eloquence TurboIMAGE compatibility

  Privacy | Webmaster | Terms of use | Impressum Revision:  2014-08-14  
  Copyright © 2012-2014 Marxmeier Software AG