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 Informix® Guide to SQL: Tutorial.

• Host variables in Informix® ESQL/C programs

  For more information, see the Informix® ESQL/C Programmer's Manual.

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