php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #57961 Option 'i5_decimal_sep' for db2_connect
Submitted: 2007-12-11 06:57 UTC Modified: 2009-05-28 08:29 UTC
From: rapha_thioliere at yahoo dot fr Assigned:
Status: Closed Package: ibm_db2 (PECL)
PHP Version: 5.2.1 OS: Windows
Private report: No CVE-ID: None
View Developer Edit
 [2007-12-11 06:57 UTC] rapha_thioliere at yahoo dot fr 
Description:
------------
I want to use the option 'i5_decimal_sep' of the function db2_connect.
My version of the dll ibm_db2 is 1.6.5
I have the following message : Incorrect option setting passed

I don't understand why ?

Thanks for your help.
Raphael

Reproduce code:
---------------
$option = array("AUTOCOMMIT" => DB2_AUTOCOMMIT_OFF, "i5_decimal_sep" => DB2_I5_SEP_PERIOD);
$var_connexion1 = db2_connect("test", "test", "test", $option);

Expected result:
----------------
I want to work with a point as decimal separator ant not a comma

Actual result:
--------------
Notice: Use of undefined constant DB2_I5_SEP_PERIOD - assumed 'DB2_I5_SEP_PERIOD'

Warning: db2_connect() [function.db2-connect]: Incorrect option setting passed in in

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-03-03 05:33 UTC] abhargav at in dot ibm dot com 
Hi,

The option that you have stated here (i5_decimal_sep) is only for iSeries machines. On windows, this particular option won't come into the picture. To see available option, visit http://in2.php.net/manual/en/function.db2-connect.php.

Regards,
Ambrish Bhargava
 [2009-05-28 08:29 UTC] abhargav at in dot ibm dot com 
Thank you for taking the time to write to us, but this is not
a bug.

The option that you have stated here (i5_decimal_sep) is only for iSeries machines. On windows, this particular option won't come into the picture. To see available option, visit http://in2.php.net/manual/en/function.db2-connect.php.

Regards,
Ambrish Bhargava
 [2016-12-07 16:14 UTC] ext dot spancrazi at cma-systems dot com 
Hello,

Is there a workaround for this ?
I work on WAMP, and I have exactly the same issue :

--CODE

$options = array("i5_decimal_sep" => DB2_I5_SEP_PERIOD);
$conndb2 = db2_connect($GLOBALS['base'],$GLOBALS['user'],$GLOBALS['pass'],$options) or die('Failed to connect user '.$GLOBALS['user'].' on '.$GLOBALS['base']);

--ERROR 

Notice: Use of undefined constant DB2_I5_SEP_PERIOD - assumed 'DB2_I5_SEP_PERIOD'
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat Oct 25 01:00:01 2025 UTC