ODBC Programmer Reference › Procedures › Using Table Procedures

Using Table Procedures

An application normally uses a table procedure as if it were a table or view, by executing SQL SELECT, INSERT, UPDATE, and DELETE statements. The effect of these statements depends on how the table procedure is implemented. If an application uses a CALL statement to invoke a table procedure, only the first row of the result set is returned. You can alter this behavior if required for compatibility with an existing application.