ODBC Multiple Datasets

HCL Domino Domino Forum
1

Hi

Is it possible to return all datasets from an ODBCresultset. We have a SQL200 Stored Proc which returns multiple datasets, however, LS seems only able to fetch the first one. (I have tried using ODBCResultset.execProcedure and ODBCResultset.execute).

I can break down the SP into two different procs, but would rather not complicate the issue.

Is it possible, or is this a limitation of Notes LS or even ODBC?

TIA

2

Subject: ODBC Multiple Datasets

I believe you can process multiple datasets in Lotussscript if you use ADO?

dim rs as variant

set conn = CreateObject(“ADODB.Connection”)

…

set cmd = CreateObject(“ADODB.Command”)

…

cmd.CommandType = 1

…

conn.ConnectionTimeout = 600

conn.Open(“your-connection-string”)

…

set rs = cmd.Execute()

while not rs.EOF

…’ process this data set

Doevents

rs.MoveNext

wend

Though Lotusscript does not have any dataset equivalent datatype, you should still be able to process multiple result sets from the sp.