# empsdump

    EMPSDUMP(1)                                                        EMPSDUMP(1)

    NAME
           empsdump - utility to dump records into a file from an Empress table.

    SYNOPSIS
           empsdump file_name database table ["where_clause"]

    DESCRIPTION
           This  command  will  select records from a table in an Empress database
           and dump them into a file.  It will either dump all records  or  selec-
           tively dump records based on a WHERE clause search criteria.

           The arguments to empsdump are dump file name, database name, table name
           and optionally a WHERE clause.  If the WHERE clause  is  not  specified
           then the entire file will be dumped.

           The  WHERE  clause  may  be  any valid WHERE clause as described in the
           Empress SQL Reference Manual.

           The specified table must exist in  the  given  database.   The  Empress
           variable  MSVALSEP must be set to a string which can separate attribute
           attribute values in the dump file. Therefore it  must  be  a  character
           that does not appear in the data.

           The user must have select permission on the table.

           Example 1: to dump all records from table 'dept' in database 'db1' to a
           file called 'dumpfile1'

                     empsdump dumpfile1 db1 dept

           Example 2: to dump only those records from table  'parts'  in  database
           'db1' having attribute 'partid' equal to 100 into a file called 'dump2'

                     empsdump dump2 db1 parts "where partid = 100 "

    FILES
           EMPRESS database files.

    SEE ALSO
           empdbld(1), empsql(1)

    DIAGNOSTICS
           Error diagnostics are printed if no database or table  name  is  speci-
           fied, if the database and table do not exist or are invalid, and if the
           WHERE clause is invalid.

    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.                 EMPSDUMP(1)