php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: rapha_thioliere at yahoo dot fr
New email:
PHP Version: OS:

 

 [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: Thu Jul 03 15:01:34 2025 UTC