Select from a collection column

To select all elements in a collection column, specify the collection column in the select list of the SELECT statement. If you put a collection host variable in the INTO clause of the SELECT statement, you can access these elements from the Informix® ESQL/C application. For more information, see Initialize a collection variable. For an example that uses a collection variable to select and display the elements of a collection, see The collect.ec program.