Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is Informix® ESQL/C?
Complex data typesThese topics explain how to use collection and row data types in the Informix® ESQL/C program.
Access a collection
Operate on a collection variable
The collection-derived table clause on collectionsThe collection-derived table clause allows you to specify a collection host variable as a table name.

The collection-derived table clause on collections

The collection-derived table clause allows you to specify a collection host variable as a table name.

This clause has the following syntax:

TABLE(:coll_var)

In this example, coll_var is a collection host variable. It can be either a typed or untyped collection host variable, but it must be declared and have memory allocated in the Informix® ESQL/C application before it appears in a collection-derived table clause.

For more information about the syntax of the collection-derived table clause, see the description of the collection-derived table segment in the Informix Guide to SQL: Syntax.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.