Please use CVS Head and let me know if this fixes your issue.

kfbombar, what do you mean with using CVS Head?, I have Zend Core for IBM installed and i do want to avoid a version conflict

By CVS HEAD I meant the latest ibm_db2 code from CVS.

I looked into this exact bug a while back and found that when using the correct user the output from the stored procedure was correct.  Although I had to add a small fix for the truncated output.  If at all possible, use the latest ibm_db2 code.  Also please check the user that is calling the stored procedure to make sure you are expected the correct output.  Let us know if you have any other issues.

Hi kfbombar,

thanx for your extremly fast reply! I?ve updated Zend Core f?r IBM with the setup tool, all the newest versions of the extensions are installed.
The scripts of the stored procedures are run with the correct apache user, and the strange thing is, one of the procedures works correct (the one i?ve cited above) with this new version, the other one gives still unreadable output. Both procedures are written in RPG and they work perfectly fine with the DBD::DB2 module of perl, so i?m sorry to say, but i?m sure, that this is a PHP problem! In a couple of days the server is online and then i can provide you the source code of the procdures and a link for displaying the output. If it is helpful i can provide the source code of the procedures too.

Please find attached the source code of the second procedure:


Best regards Karl Prinz

   $multdiv = 'a';
   $rabatt  = 0.00;

   $database = 'S65BAD1A';
   $user = 'freshpr';
   $password = 'fresh1912';

   $sql = "CALL PMNLIB.PREISHOLEN(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
   $conn = db2_connect($database, $user, $password);
   $stmt = db2_prepare($conn, $sql);

   db2_bind_param($stmt, 1, "leer", DB2_PARAM_INOUT, 1);
   db2_bind_param($stmt, 2, "lafirm", DB2_PARAM_INOUT, 2);
   db2_bind_param($stmt, 3, "saij", DB2_PARAM_INOUT, 4);
   db2_bind_param($stmt, 4, "sais", DB2_PARAM_INOUT, 2);
   db2_bind_param($stmt, 5, "lasain", DB2_PARAM_INOUT, 3);
   db2_bind_param($stmt, 6, "lamodn", DB2_PARAM_INOUT, 7);
   db2_bind_param($stmt, 7, "customer_id", DB2_PARAM_INOUT, 7);
   db2_bind_param($stmt, 8, "ek", DB2_PARAM_INOUT, 7);
   db2_bind_param($stmt, 9, "ekwaeh", DB2_PARAM_INOUT, 3);
   db2_bind_param($stmt,10, "vk", DB2_PARAM_INOUT, 7);
   db2_bind_param($stmt,11, "vkwaeh", DB2_PARAM_INOUT, 3);
   db2_bind_param($stmt,12, "kurs", DB2_PARAM_INOUT, 10);
   db2_bind_param($stmt,13, "multdiv", DB2_PARAM_INOUT,1);
   db2_bind_param($stmt,14, "rabatt", DB2_PARAM_INOUT, 4);

   db2_execute($stmt);
   return $ek."#".$ekwaeh."#".$vk."#".$vkwaeh."#".$rabatt;
}

echo "<h1>".fetch_price(26,2006,'FS',1,11247,0004711)."</h1>";

Dear kfbombar,

the Zend support told me that i should inform you, that the small fix is included in the latest version of Zend Core for IBM. If it?s helpful, a could provide you the data of the Zend support ticket..

Best regards

Karl Prinz

Since the fix is already in Zend Core, I would really consider the problem to be with the user that is running the stored procedure.  If you believe this is not the issue, you can send us the info when you get it set up for looking at your problem more personally.

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

Hi kfbombar,

the last notices were sent to your collegue, because you were in holidays. The last one i?ve sent to you as cc. And by the way the problem isn?t solved at all!

Here is an extract of the e-mail communication:

1. calling the stored procedures with different connections:

i?ve tested the stored procedures with the uncatalogued connections, the result was different, but not correct. I?ve changed the lang variable in the PHP script with no effect (setlocale(LC_CTYPE, 'de_DE.UTF-8');).
 
So if it helps i could send you the source code of the procedure written in RPG.

2. testing the CVS Head:

i?ve forgotten to mention that i?ve tested the CVS HEAD of ibm_db2 and the problems are more or less the same. The formatting of the output is better (now the correct codepage is used), but the return values of the stored procedures are still wrong or empty...

best regards

Karl Prinz

The PHP version was changed a month ago and the problems are still the same.

And by the way, the procedures are working with perl and a DB2 Connect Personal Edition without problems !!

Regards Karl

Hi,

I have just fixed a IN/OUT param related bug in CVS which could be the cause of the data corruption you are facing. Can you please try the latest version of the driver from CVS and let me know if you still face the problem. Thanks

Dear Kraman,

thanks for the hint, I?m using Zend Core, so i?ll ask the Zend guys for the latest CVS.

As i wrote kfbombar via email we have problems running test stored procedures on the server of our customer, but if the stored procedures still fails after teh latest CVS update i could provide you the source code of the stored procedures (RPG), if you like...

Best regards 
Karl Prinz

sorry, but i can?t recompile Zend on a production server of our customer...

sorry, but i can?t recompile Zend on a production server of our customer... so i?m waiting for a regular ZEND update...

Thanx Karl

Changing status to awaiting feedback due to the wait on Zend update for latest status.