# empdelr

    EMPDELR(1)                                                          EMPDELR(1)

    NAME
           empdelr  -  selectively  deletes  records  from  a  table in an Empress
           database.

    SYNOPSIS
           empdelr database table ["where_clause"]

    DESCRIPTION
           This command selectively deletes records from tables and  releases  the
           file  space.   The  database name, the table name and an optional WHERE
           clause are parameters to the  utility.  If  the  WHERE  clause  is  not
           included  all  records  will  be  deleted;  if  it  is included it will
           restrict the deletion to only records in the set.  The WHERE clause may
           be  any  valid  WHERE  clause as described in the Empress SQL Reference
           Manual.

           The user must have delete and alter permissions on the table.

           Note: During the  space  reclaimation  phase  the  table  must  not  be
           accessed  by other users. If the database administrator is running this
           command, (s)he may use the 'empadm  dbamode'  command  to  disable  the
           database from other users before running the command.

           Note: After running empdelr, inserts into the table will perform slower
           than if the records had been  deleted  with  a  regular  SQL  statement
           "delete  from table ...".  Because empdelr has reclaimed the file space
           taken up by the deleted records, new record  inserts  must  extend  the
           file.   Therefore it is advised that this utility be used only if space
           is very limited and if inserts will not be made immediately.

    FILES
           EMPRESS database files.

    SEE ALSO
           empident(1)

    DIAGNOSTICS
           Error diagnostics are printed if no database or table  name  is  speci-
           fied,  if  the database or table are not found or are not valid, 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.                  EMPDELR(1)