empexpt

EMPEXPT(1)                                                          EMPEXPT(1)



NAME
       empexpt - export an EMPRESS database

SYNOPSIS
       empexpt  [-notable] [-nomodule] [-demvx] [-h user_label_string] outfile
       database [ [-table] table ... } ] [ -module module ... ]


DESCRIPTION
       Empexpt exports tables from an EMPRESS database.  A list of tables sep-
       arated by spaces specifies the tables to be exported.  If no tables are
       specified, all tables in the database are exported.  Indices, lock lev-
       els, comments, range checks and privilege information are exported with
       each table.

       The output is written to the specified "outfile".  If this is "-"  out-
       put is written to standard output.

       You  should not attempt to explicitly export data from the data dictio-
       nary tables.  However, you may export comments, lock levels and indices
       from them (using the -d option).

       You  must  have EMPRESS "display" privilege to export a table's defini-
       tion, amd both "display" and "select" privileges to export its data.

       The program may not be interrupted  during  critical  phases;  pressing
       interrupt several times will usually stop the program.

       -notable  Suppresses exporting of all table definitions, comments, lock
                 levels, indices, range checks, referential checks and data.

       -nomodule Suppresses exporting all module definition.

       -d        Suppresses exporting of the data.   Only  table  definitions,
                 comments, lock levels, indices and range checks are exported.

       -e        Ignore errors and continue with  exporting.   Default  is  to
                 report and stop whenever an error is encountered.

       -h        Put  a  user  information string into export file header.  An
                 example of its usage is

                      -h "This is a user information string"

                 The string is displayed when the import utility  is  used  to
                 display the header only.

       -m        Suppresses exporting of trigger definition.

       -v        Causes execution in verbose mode.  Verbose messages are writ-
                 ten to standard output.  Otherwise execution is silent except
                 for table names and error messages written to standard error.

       -x        Do not perform checksum calculation on export data.   Default
                 is  to perform checksum on the table data exported.  A check-
                 sum is always performed on primary header of the export file.

       -table    When  this  is  specified,  only tables provides in the table
                 list will be exported.

       -module   When this is specified, only modules provided in  the  module
                 list will be exported.

FILES
       EMPRESS database files

SEE ALSO
       empimpt(1)

       Empress: Database Administrator's Guide


DIAGNOSTICS
       Error  diagnostics  are  printed  if  no  database is specified, if the
       database is not in EMPRESS format, or if execution errors are detected.

HISTORY
       Written  by  Empress  Software  Inc..   All material is copyrighted and
       licensed.  Use on non-licensed CPUs is prohibited.



Empress 8.62                 Empress Software Inc.                  EMPEXPT(1)