Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I get multiple rows back from a Sybase or SQL Server stored procedure? How do get different result sets?

April 26, 2017different procedure rows SQL Server stored Sybase

0

Posted

How do I get multiple rows back from a Sybase or SQL Server stored procedure? How do get different result sets?

1 Answer

0

Posted

To get rows from the stored procedure, use VTXOPEN with the following SQL statement syntax: select_storedprocedurename Then use VTXMOVE. Check sqlcode for TDB_ARS_ROWS (1) and TDB_ARS_COMPUTE (2) to determine what is going on.