Correction to sp_iqemptyfile procedure [CR #639511]

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.