on 07-14-2011 1:06 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.