Sql Server 2005 Cursor Issue Problem

[Former Member]

Hi All,

I declared a cursor in SAP MII 12.1 which can hold three rows

but when i displayed the cursor ,it returns me only one row

Sample Query:

DECLARE emp_cursor CURSOR FOR

SELECT Employee.EmpName from Employee //It will hold me three rows

OPEN emp_cursor;

FETCH NEXT FROM emp_cursor;

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM emp_cursor;

END

CLOSE emp_cursor;

DEALLOCATE emp_cursor;

How to display all the rows using cursor in SAP MII

Any Option need to Set here

Please help me

Thank You

[Former Member]

Hi Subhanim,

There is an example of using a with MII in the old version 11.5 help documentation. Maybe this will be helpful:

[IDBC User's Guide|http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm]

Scrolled down to the "FixedQueryWithOutput" section.

Kind Regards,

Diana Hoppe