No data returned on OUTPUT and INPUT_OUTPUT parameters

For IBM i Access ODBC: SQLBindParameter problem when no data returned

This problem could be caused by any of the following:

  • The ODBC SQLBindParameter API incorrectly specified fParamType as SQL_PARAM_INPUT.
  • DECLARE PROCEDURE was used instead of CREATE PROCEDURE, and extended dynamic support is disabled.
  • The programmer incorrectly declared a parameter as IN on the CREATE or DECLARE PROCEDURE.
  • The stored procedure program incorrectly returned the parameter.