Reading Data from a Blob

Go Up to Blob Data Operations

There are six steps required for reading data from an existing Blob:

1. Create a SELECT statement query that specifies selection of the Blob 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. Fetch the selected rows one by one.
6. Read and processing the Blob data from each row.

Topics

• Creating the SELECT Statement to Read from a Blob
• Preparing the Output XSQLDA to Read Data from a Blob
• Preparing the SELECT Statement to Read Data from a Blob for Execution
• Executing the Statement to Read Data from a Blob
• Fetching Blob Data from Selected Rows
• Reading and Processing the Blob Data