Locating the Optical Volume Where TEXT and BYTE Data Is Stored

You can use the FAMILY() and VOLUME() function expressions in a SELECT statement to obtain the family name and volume number where a TEXT and BYTE data object is stored. The SELECT statement in the following example produces a list of the optical volumes that hold pictures of bicycle helmets (stock_num = 110):

SELECT FAMILY(cat_picture), VOLUME(cat_picture)
   FROM catalog
   WHERE stock_num = 110