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)