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

This is the code...

if ( $oDB = db2_pconnect( '', '', '', array( 'i5_naming' => DB2_I5_NAMING_OFF ) ) )
{
// Save Data And Retrieve Auto Incremented ID
$sQry = 'SELECT ID FROM FINAL TABLE( INSERT INTO MyLibrary.zTest ( METHOD, AGENT, IP ) VALUES ( 'GET', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0', '76.187.52.97' ) ) ;' ;

$sRes = db2_exec( $oDB, $sQry ) ;
db2_close( $oDB ) ;
}

All I get in the error log is:

[04-Dec-2015 11:26:24 EST] PHP Warning: db2_exec(): Statement Execute Failed in /Test.php on line 51


In SiN:

[Fri Dec 04 16:05:26 GMT 2015 ] Run All

> SELECT ID FROM FINAL TABLE( INSERT INTO MyLibrary.zTest ( Method, Agent, IP ) VALUES ( 'GET', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0', '76.187.52.97' ) )

Statement ran successfully (141 ms)

The table was created from:

CREATE TABLE MyLibrary.zTest (
ID bigint GENERATED ALWAYS AS IDENTITY ( START WITH 1, INCREMENT BY 1, NO CYCLE ),
When timestamp WITH DEFAULT CURRENT TIMESTAMP,
Method varchar(4),
Agent varchar(255),
IP varchar(15),
Request xml,
PRIMARY KEY ( ID )
) ;

I am ready for my beating....

Thanks,
rob

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus