|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2007-07-29 08:15 UTC] sam at zend dot com
Description: ------------ Stored procedure in i5/OS has a parameter as a DATE type. PHP extension IBM_DB2 running on i5/OS can not call this procedure. We are getting following SQL error in i5/OS SQL0180: Syntax of date, time, or timestamp value not valid. The problem appears only when using db2_bind_param function. Reproduce code: --------------- db2_autocommit( $conn, DB2_AUTOCOMMIT_OFF ); $sql = "CALL louisa.test_a1(?)"; $val = ''; $stmt= db2_prepare($conn_resource, $sql); db2_bind_param($stmt,1,"val", DB2_PARAM_IN); $result = db2_execute($stmt); Expected result: ---------------- The call to stored procedure should not get any SQL errors Actual result: -------------- We are getting following SQL error in i5/OS SQL0180: Syntax of date, time, or timestamp value not valid. The problem appears only when using db2_bind_param function. PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 05:00:01 2025 UTC |
Invalid issue: DB2 does not allow '' as date STRSQL > select cast('' as date) from sysibm.sysdummy1 Argument 1 of function CAST not valid.