Re: Query Fails In PHP db2_exec But Is Good in System I Navigator.

On 12/4/2015 11:34 AM, Rob wrote:

if ( $oDB = db2_pconnect( '', '', '', array( 'i5_naming' =>
DB2_I5_NAMING_OFF ) ) )

Very often, newcomers to our platform are surprised by journaling and
commitment control. Rather, they are surprised at the lack thereof. It
is possible that iNavigator is set to COMMIT(*NONE), but I don't see
anything like that in the PHP connexion string, so the default would be
to perform table I/O under commitment control. If MyLibrary.zTest is
not journaled, then it is impossible to perform I/O to it under
commitment control.

The typical choices are:
1) Journal the table so COMMIT and ROLLBACK work as expected.
2) Tell PHP that you want to operate with no commitment control, so
INSERT ... WITH NC