Method 4: Using prepare and fetch with system descriptors

This method permits varying-list select statements. That is, when you write the application, you need not know the formats and number of items the select statement will return.

Use this method when you cannot define the host variables in advance because you do not know how many variables are needed or of what type they should be.