Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
sp_iqemptyfile empties a dbfile. The dbspace must be read-only before you can execute the sp_iqemptyfile procedure. The procedure moves the objects in the file to another available read-write dbfile in the same dbspace. If there is no other read-write dbfile available, then Sybase IQ displays an error message.
In a multiplex environment, you can run sp_iqemptyfile only on the coordinator. There must be one read-write dbspace available for the procedure to succeed.