System Procedures > System stored procedures > sp_iqemptyfile procedure is updated as follows:
Function – Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace.
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.