Reading Data from an Array

Go Up to Accessing Array Data

There are seven steps required for reading data from an array or slice of an array:

1. Create a SELECT statement that specifies selection of the array column (and any other columns desired) in the rows of interest.

2. Prepare an output XSQLDA structure to hold the column data for each row that is fetched.

3. Prepare the SELECT statement for execution.

4. Execute the statement.

5. Populate an array descriptor with information describing the array or array slice to be retrieved.

6. Fetch the selected rows one by one.

7. Read and process the array data from each row.

Topics

• Creating the SELECT Statement to Read from an Array
• Preparing the Output XSQLDA to Read Data from an Array
• Preparing the SELECT Statement to Read Data from an Array for Execution
• Executing the Statement to Read Data from an Array
• Populating the Array Descriptor
• Fetching Array Data from Selected Rows
• Reading and Processing the Array Data