The VOLUME() function returns the number of the volume where a TEXT or BYTE data column is stored.
Volumes are filled numerically. Once a volume is filled, or no room is available for a cluster, all subsequent writes occur on volumes with a higher number. When TEXT and BYTE data is stored sequentially, the highest volume number contains the most recently stored objects. However, this generalization is not true for clustered TEXT or BYTE data.
In the following example, the VOLUME() function generates a list of the volumes that contain data for the cat_picture column:
SELECT VOLUME(cat_picture) FROM catalog
For more information on how to use DESCR(), FAMILY(), and VOLUME(), see Using the Optical Subsystem.
For the following information, see the IBM Informix: Guide to SQL Syntax: