# empident

    EMPIDENT(1)                                                        EMPIDENT(1)

    NAME
           empident  - prints information about a table, and optionally select and
           print records from that table.

    SYNOPSIS
           empident database table ["where_clause"]

    DESCRIPTION
           Empident will accept a database name, a table  name,  and  an  optional
           WHERE clause, and in turn will provide the record count and the size in
           bytes of all of the files comprising the table.   This  size  therefore
           includes  the  total  of  the size of the main (rel) file, all text and
           bulk overflow files and all indices associated with the table.

           The utility will use the optional WHERE clause to select  records  from
           the  table.   For  each selected record, the values of the fixed length
           attributes will be printed along with the length of data in  each  bulk
           and  text attribute.  The WHERE clause may be any valid WHERE clause as
           described in the Empress SQL Reference Manual.

           The user must have display and select permissions on the table, as well
           as select priviledges on sys_tables.

           In  addition  if the table resides on a remote node then the total size
           of the table is available only if the user can access the  table  files
           using a remote shell command.

           Example  1:  to  get table information about 'table1' in database 'db1'
           and list all records

                     empident db1 table1

           Example 2: to get table information about 'table1'  in  database  'db1'
           and list all records having NUM > 100 into a file "/tmp/ident1"

                     empident   db1   table1   "where   NUM   >   100   list  into
                     '/tmp/ident1' "

    FILES
           EMPRESS database files.

    SEE ALSO
           empdelr(1)

    DIAGNOSTICS
           Error diagnostics are printed if no database or table is specified,  or
           if  the  database or table are not found or not valid, and if the WHERE
           clause is invalid.  If the size of the table is not  available  due  to
           insufficient  remote  shell  permissions  then a message like "Size not
           available" will be printed.

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