Empties a dbspace file and moves the objects in the file to another available read-write dbpace file.
sp_iqemptyfile ( logical-file--name )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
sp_iqemptyfile empties a dbspace file. 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 dbspace file. If there is not other read-write dbspace file 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.
The following empties dbspace dbspace1:
sp_iqemptyfile 'dbspace1'
