Re: Embedded SQL: appending a subsequent fetch to a host variable data structure

[Booth Martin <booth@xxxxxxxxxxxx>]

I am doing that, as step 1.  It works great.  Its step 2 thats is 
troubling me.

Step 1: gather all records for ItemA1.
Repeat for ItemA2, A3, B5, B8. r8, etc.

In the end I will have gathered 30 to 40 records for each of 10 to 60 
different items.

I expect to have a separate array and keep track of positioning. Then 
add each gathering to the end of the array.  SQL has surprised so often 
with flexibility that I did not expect that it seemed reasonable to ask.

On 2/1/2016 3:53 PM, Charles Wilt wrote:
> Why not just fetch all 1000 at once?
>
> c/exec sql
> c+    fetch myCursor for 1000 rows
> c+      into :myOccursDS
> c/end-exec
>
> c                   eval      wNumRowsRtn = SQLERRD(3)
>
> Charles