# empimpt

    EMPIMPT(1)                                                          EMPIMPT(1)

    NAME
           empimpt - import an EMPRESS database tables.

    SYNOPSIS
           empimpt  [-codeset  CS] [-notable] [-nomodule] [-cdeghiklmprtvx] infile
           database [[-tables] table ...] [-module module ...]

    DESCRIPTION
           Empimpt imports tables  to  an  EMPRESS  database  (the  database  must
           already  exist -- a database may be created using empmkdb(1)).  The data
           to be imported must be in the format produced by empexpt(1).  A list of
           tables  separated  by spaces specifies tables to be imported (the table
           names must correspond to the names given when the data was  exported.)
           If  no  tables  are  given  all  tables  in the input file "infile" are
           imported.  If this file is "-" input is taken from standard input.

           You should not attempt to explicitly import data to the data dictionary
           tables.  You may, however, import indices, comments and lock levels for
           them.  Imported comments and lock levels will  override  existing  com-
           ments  and  lock  levels.   Attempting  to import an index that already
           exists on a system table causes an error.  The program will not  create
           the index and continue.

           Imported  tables are created in the database directory and are owned by
           the user executing  the  program.   To  import  tables  you  must  have
           "insert"  privilege in the table "sys_tables".  If any of the tables to
           be imported exist, you must have "insert" privilege on them.

           Pressing interrupt will not stop the program  during  critical  phases.
           Pressing the interrupt several times will usually stop the program.

           -codeset CS    treats the nls data in infile as stored in codeset CS in
                     order to translate it into the native codeset  (e.g.  Latin1,
                     EUC-JP).   Avaliable  codeset  (CS) for translation could be,
                     for example, SJIS.

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

           -nomodule Suppresses the import of all module definition.

           -c        Suppresses the import of comments.

           -d        Do not import actual data for tables, only the table informa-
                     tion  is  imported.   Default  is to import actual table data
                     from the export file into the database.

           -e        Import each table within a transaction ( one transaction  per
                     table); if an error occurs, then the transaction is cancelled
                     and a recovery will be attempted to resume importing  at  the
                     next table/view.  Default is not to import tables in transac-
                     tions and attempt to continue on errors.  If the -e option is
                     not used, the following points apply:

                     Indices,  comments, lock levels and range checks are not cre-
                     ated for the table.  No message is printed.

                     If the table has any level of locking defined for it, the ta-
                     ble  is  locked during the insertion.  If the table cannot be
                     locked ( as then it is in use), no insertions  are  attempted
                     for  the  table  and  a message is displayed.  You may try to
                     insert the data for the table later.

                     If the insertion proceeds, records are inserted into the  ta-
                     ble  on  the  basis of attribute names.  The presence of data
                     mapped to non-existent attributes causes the program to  skip
                     to  the  next  table.  Additional attributes in the table are
                     set to null.  If the  first  record  contains  data  that  is
                     incompatible  with the data type of the attribute to which it
                     is mapped, the program will skip to the next  table.   Incom-
                     patible  data  in subsequent records causes the records to be
                     skipped.  If inserting a record  would  cause  the  allowable
                     number  of  duplicate  tuples  to  be exceeded, the record is
                     skipped.  Care should be taken to avoid having  some  records
                     inserted while others are rejected.

           -g        Import  grant  privilege(s)  information.   Default is not to
                     import any grant privilege(s)  information  from  the  export
                     file.

           -h        Displays  the name and number of records of each table in the
                     input stream or file.   A  view  is  indicated  by  the  word
                     "VIEW".   If  this  option  is used, no data is imported.  If
                     this option is given, the database need not be supplied.

           -i        Suppresses the import of indices.

           -k        Suppresses the import of referential constraints.

           -l        Suppresses the import of lock levels.

           -m        Suppresses the import of trigger definition.

           -p        Grants PUBLIC select and display privileges on  all  imported
                     tables.

           -r        Suppresses the import of range checks.

           -t        Do not create tables.  Used when the tables already exists in
                     the destination database.  Default is to create  tables,  and
                     if  the  table  already exists, then import data only for the
                     table.

           -v        Causes execution in  verbose  mode,  otherwise  execution  is
                     silent except for table names and error messages.

           -x        Do  not perform checksum analysis on the imported table data.
                     A checksum analysis is always attempted on the primary header
                     regardless  of this option.  The default is to perform check-
                     sum analysis on the imported table data.

                     Note: if the export file does not contain  checksum  informa-
                     tion,  then  this option does nothing ( for backward compati-
                     bility ).

           -table    When this is specified, only tables  provides  in  the  table
                     list  will be imported. If -notable option is also specified,
                     empimpt will print error message and exit.

           -module   When this is specified, only modules provided in  the  module
                     list  will  be  imported.  If -nomodule option is also speci-
                     fied, empimpt will print error message and exit.

    FILES
           EMPRESS database files

    SEE ALSO
           empexpt(1), empmkdb(1), empdbld(1)

           Empress: Database Administrator's Guide

    DIAGNOSTICS
           Error diagnostics are printed if the database is not in EMPRESS format,
           if  the input is not in the format produced by empexpt(1), or if execu-
           tion 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.                  EMPIMPT(1)