Accessing collection data

To access the elements of a collection column, you must fetch the collection into a collection variable and modify the contents of the collection variable. Collection variables can be either of the following types:

• Variables in an SPL routine

  For more information, see the HCL Informix Guide to SQL: Tutorial.

• Host variables in IBM® Informix® ESQL/C programs

  For more information, see the HCL Informix Enterprise Replication Guide.

You can also use nested dot notation to access collection data. For more about accessing elements of a collection, see the HCL Informix Guide to SQL: Tutorial.