Hi there,
In the IBM sample file (see /opt/IBM/db2/V8.1/samples/cpp),
spserver.sqC, it implemented a routine called two_result_sets(...). In
spclient.sqC, callTwoResultSets(...) is supposed to show how to call
two_result_sets() and how to use the returned record sets, but it is
not implemented. In other words, in the spserver.sqC code, it
commented: '// Leave cursors open to return result sets', but there is
no further example on how to use these two cursors from the client
application. The same goes for one_result_set_to_client(...) (in
spserver.sqC) and callOneResultSet(...) (in spclient.sqC). Can anyone
tell me how to use the record sets that are returned from
spserver.sqC? To be more specific, how do I define these two cursors
in a client app?
Thanks.

You cannot process the result set from an embedded app...look at:
cli/spclient.c
or
java/jdbc/SpClient.java

For how to use them from cli or jdbc apps.

minjie wrote:

Sean McKeough <mckeough (AT) nospam (DOT) ca.ibm.com> wrote

Thanks a lot for your reply. I need some more info in this case, for
the following situation: I already developed the code (using embedded
SQL with C++) - on the client side - for getting two linked lists: the
column names and the column values from a table. I was thinking of
moving most of the embeded SQL code into the server side and make it
into a library, so other app can use it as well. If a routine could
return linked lists, then there would be no problem in moving the code
into the server side and make it a routine, but it seemed to me a
routine is not allowed to return linked lists. So I was thinking of
letting the routine return the record sets and having the client build
the two linked lists from the record sets, which was why I asked the
original question. Now if this is not possible, and if I do not use
CLI, does that mean I HAVE TO use a fat client (meaning I have to
leave the code in the client app)?
Thanks for any help.

Sean McKeough <mckeough (AT) nospam (DOT) ca.ibm.com> wrote

Thanks again. I'll try to push this requirement through your normal
channel. Is it possible for you to provide a link on how to get there?
Will I get informed if it's implemented eventually?