Uncataloging an image means removing entries for the image from a QBIC catalog. Use the QbUncatalogImage API to uncatalog an image. You cannot uncatalog an image by command, because there is no way to identify the individual image on the command line. When you use the API, specify the catalog handle and the image handle (you can retrieve the image handle from the user table). The QBIC catalog must be open for update before you uncatalog an image.
For example, the following statements retrieve an image handle from a user table and then uncatalog the image:
/* Retrieve the image handle */ EXEC SQL BEGIN DECLARE SECTION; char Img_hdl[251]; EXEC SQL END DECLARE SECTION; QbCatalogHandle CatHdl; EXEC SQL SELECT PICTURE INTO :Img_hdl FROM EMPLOYEE WHERE NAME='Anita Jones'; /* Uncatalog the image */ rc=QbUncatalogImage( CatHdl, /* catalog handle */ Img_hdl); /* image handle */