sp_iqemptyfile Procedure

Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace.

Syntax

sp_iqemptyfile ( logical-file--name )

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

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.

Note: 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.

Example

The following empties dbfile dbfile1:

sp_iqemptyfile 'dbfile1'