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.

I have a question concerning Stored Procedures and VTXEXIO: With SYBASE, Stored Procedures may return result sets. Does Vortex offer a possibility to process these result sets?

April 26, 2017procedures Return stored Sybase Vortex

0

Posted

I have a question concerning Stored Procedures and VTXEXIO: With SYBASE, Stored Procedures may return result sets. Does Vortex offer a possibility to process these result sets?

1 Answer

0

Posted

If you expect result sets, use VTXOPEN(). Prefix the stored procedure name with “select_” and check the SQLCA.SQLERRD[0] as described in the VORTEXcli Reference manual available on our Web site (Documentation->Print Documentation).