Accessing collection data
About this task
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 OneDB™ Guide to SQL: Tutorial.
- Host variables in
programs
For more information, see the HCL OneDB 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 HCL OneDB Guide
to SQL: Tutorial.
Important: Collection data types are not valid as arguments
to functions that are used for functional indexes.