search

zendtech / IbmiToolkit

PHP frontend to XMLSERVICE for IBM i development.
BSD 3-Clause "New" or "Revised" License
46 stars 34 forks source link

PDO permits output parameters and should use them #126

Closed alanseiden closed 3 years ago

alanseiden commented 4 years ago

https://github.com/zendtech/IbmiToolkit/blob/master/ToolkitApi/PdoSupp.php

Unlike the procedural odbc extension, PDO permits output parameters. It should function more like ibm_db2 in that way than odbc. It can get output params (it doesn't have to use result sets) and therefore use the stored procedures of ibm_db2 that use output params rather than odbc with its result set.

alanseiden commented 4 years ago

A side effect of using result sets instead of output parameters may be this issue, because after a disconnect, result sets cannot be retrieved, whereas an output parameter would return immediately upon execute: https://github.com/zendtech/IbmiToolkit/issues/129

alanseiden commented 3 years ago

Closing issue because #129 was handled in a different manner, and using result sets more portable between PDO_IBM and PDO_ODBC than output parameters would be. Output parameters can be finicky.