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)