Table-valued parameters let you pass a collection of table rows as a parameter to your stored procedure. The benefit of passing table rows is you can short circuit some of the stored procedure code ...

Prepared statements avoid the process of compiling, parsing and running a stored procedure or inline SQL statement in your code. The PHP prepared statement function speeds up the application ...

Next, you must add the SQL code specifically for a stored procedure, and it must look similar to the first example above. You see, if the stored procedure is to receive parameters, add the ...

Stored procedures that do not return values can be executed directly by using the Informix SQL EXECUTE statement. Stored procedure execution is initiated with the Informix EXECUTE PROCEDURE statement.

Any return code or message that is generated by the DBMS is available in the macro variables SQLXRC and SQLXMSG after the statement executes. See SQL Procedure Pass-Through Facility Return Codes for ...