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)