In This Chapter

The information in this chapter applies only if your database server is IBM Informix Dynamic Server.

Rows and collections are composite values that consist of one or more elements. You can use the SELECT, UPDATE, INSERT, and DELETE statements to access an entire row or collection. However, these SQL statements do not let you access an element that is in a row or collection. To access an element, you need to retrieve the row or collection and then access the element from the local copy of the row or collection.

For more information about rows and collections, see Data Types, the IBM Informix: Guide to SQL Reference, and IBM Informix: User-Defined Routines and Data Types Developer's Guide. For information about the client functions that you use to access rows and collections, see Client Functions.