Stored Procedure returning result set to embedded SQL client

[Guido Lamers]

Hi,

I'am developing applications with the help of embedded SQL in C++ language.
I want to use 'select' with more than one result (cursors) inside stored
procedures. Documentation tells me the client can only be in CLI, ODBC, JDBC
or SQLJ language.

Is this true? And what can i do to use cursors in stored procedures called
from a embedded SQL C++ application on Windows NT 4.0.

Thanks,

Guido Lamers

[Zamil]

Guido,
You should be able to do what you are trying to do.

Look at the sample program
..\SQLLIB\samples\cpp\spclient.sqx OR
..\SQLLIB\samples\c\spclient.sqc

These are sample programs that have examples of calls to stored procedures
that return multiple result sets.

Regards,
Zamil

"Guido Lamers" <GuidoLamers@hetnet.nl> wrote:
>
>Hi,
>
>I'am developing applications with the help of embedded SQL in C++ language.
>I want to use 'select' with more than one result (cursors) inside stored
>procedures. Documentation tells me the client can only be in CLI, ODBC,
JDBC
>or SQLJ language.
>
>Is this true? And what can i do to use cursors in stored procedures called
>from a embedded SQL C++ application on Windows NT 4.0.
>
>Thanks,
>
>Guido Lamers
>