CA IDMS r17, or later, supports procedures that return result sets. The application uses the following functions to navigate though any returned result sets:
This function can be used to determine if a procedure returned one or more result sets. After the statement that calls a procedure is executed the function returns the number of columns in the first result set (not the number of output parameters). If there are no returned result sets it returns 0. After SQLGetMoreResults is called it returns the number of columns in the current result set.
Closes the current returned result set and opens the next result set returned by the procedure, if any.
The application uses the normal result set functions to retrieve the column data values.
|
Copyright © 2009 CA.
All rights reserved.
|
|