I work whith PHP 4.3.1 and DB2-400

When I execute this query

SELECT * FROM BIBLIO.MOBRAS TBMOBRAS
LEFT OUTER JOIN HUMIGES.MOBRASPLUS TBPLUS
ON
TBMOBRAS.OROBR = TBPLUS.OROBR
WHERE
TBMOBRAS.ORPL='HE'
AND TBMOBRAS.ORSE='HE'
AND TBMOBRAS.ORTP = ' P'
AND TBMOBRAS.OROBR='40500'
AND TBMOBRAS.ORVAR=' 1'

I get this error message...

Warning: SQL error: [IBM][CLI Driver][AS] SQL30040N Execution failed because of unavailable resources that will not affect the successful execution of subsequent commands and SQL statements: Reason "0x0", Type of Resource "0x1409", Resource Name "", Product ID "QSQ04040". SQLSTATE=57012 , SQL state 57012 in SQLExecDirect in /home/httpd/html/sistema/include/dblib.php on line 17

dblib line 17 --> $qid = odbc_exec($conn,$query." with none");

I think this is caused by BLOB field in HUMIGES.MOBRASPLUS table, because when I drop the field the problem is solved.

does any body know where comes the problem from.

Regards
Emilio.

Hi,

In documentation there is a note:
"The application cannot process the command or SQL
statement because the specified resource has run out. The current
transaction is not rolled back and the application remains
connected to the remote database."

Do you have enough resources? Disk space, memory, etc?

Hope this helps,
Grofaty

grofaty thank for your comment, but is not this, I have disk space, memory and all the resources that I need.

I solved the problem clearing the JOIN and doing two SELECT's, I do not like this, but resolve fast

Any think about this is wellcome.

Regards
Emilio

If the tables are large, they can use up a large amount temporary tablespace. Consider making it larger and see what happens. Also look at sort heaps.