#19416 [Opn->Bgs]: unproperly use of the ESQL Library?
ID: 19416
Updated by: iliaa@php.net
Reported By: phantom@h07.org
-Status: Open
+Status: Bogus
Bug Type: Informix related
Operating System: Linux
PHP Version: 4.2.2
New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system
is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
Read above message for explanation.
Previous Comments:
------------------------------------------------------------------------
[2002-10-18 08:24:05] cvb@clausvb.de
We had the same problem here once, but in our case it was the
programmers fault.
He didn't know SQL to well and counted the rows using a WHILE loop
instead of "SELECT COUNT(*) ...".
It was a large database and when the script was used often our intranet
site did not respond.
I do not think, that is your problem, but could you post your
- OS
- INFORMIX RDBMS version (IDS, ODS, SE, ...)
- SQL statement that causes the problem?
I think this will help, because we encoutered problems on 7.31.UC7,
which did not occur on IDS 9.2x.y.
Thanks in advance!
Claus
------------------------------------------------------------------------
[2002-09-15 09:51:07] phantom@h07.org
When you do very much querys at the same time (or big querys with
subquerys) Informix reports a Error -439 that means a SQL Query is
currently running and you can`t do your query yet.
Error 439 means:
You attempted to call an SQL routine or attempted to execute an SQL
statement within a signal handling function/routine or a callback
function/procedure. Use only the sqldone() and sqlbreak() library
functions inside your INFORMIX-ESQL/C callback function. Use only the
ECO-SQD and ECO-SQB library routines inside your ESQL/COBOL callback
procedure. In addition, if you want to unregister your callback
function in INFORMIX-ESQL/C, you can invoke the sqlbreakcallback()
callback registration function within your callback procedure. If you
want to unregister your callback procedure in ESQL/COBOL, you can
invoke the ECO-SQBCB callback registration routine within your
callback
procedure.
---snip---
so do you use a false ESQL Function?
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19416&edit=1
Thread (3 messages)