re: multiRow Fetch

I have done this as a MODS.  Simply add the rows returned as a parm like:


  D  Result_Data_Ptr...
  D                                     VALUE
  D                                     LIKE(StdPtr)
  D  Result_Data_I_Ptr...
  D                                     VALUE
  D                                     LIKE(StdPtr)
  D  Rows_Returned...
  D                                     LIKE(StdIntSml)
  D  Last_Row...
  D                                     LIKE(StdLgl)


What I would LIKE to do is put this into a array so that I can take advantage 
of dynamic array handling.  My current method has a predefined size for the 
OCCUR

You sound like you have solved this!  Would you mind sharing?



>>> MWalter@hanoverwire.com 04/08/02 12:31PM >>>

Andrew,

I've already changed the program to use a MODS instead of an array. I still
have the same problem. I still can't determine the acutal number of rows
returned.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Andrew Lutz"
                    <alutz@pmigroup.c        To:     <rpg400-l@midrange.com>
                    om>                      cc:
                    Sent by:                 Subject:     re: multiRow Fetch
                    rpg400-l-admin@mi
                    drange.com


                    04/08/02 03:21 PM
                    Please respond to
                    rpg400-l






Mark,

Not the answer to your question..

I have always used a multi-occurrence data structure.  How are you defining
the fields in the array?



>>> MWalter@hanoverwire.com 04/08/02 11:45AM >>>
Hello all,

I've tried to go about this in a different manor. What I'm trying is to
return a pointer to an array of Rows. I have a 'main' procedure that
defines a based array that is the same length of the record. In my SQL
procedure I also have a based array. I issue a select count(*) into :count
from the file and allocate the memory for the array using the count * the
size of the array. I then open a cursor and run through the cursor and load
the array. Then I return the pointer to the array.

Now, in my calling program, I can see the correct data in the array. The
problem is that the number of elements being allocated is the number on the
DIM statement. Not the actual number of elements being filled.

How do I determine the number of actual elements in the array?


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.