SELECT * FROM BIBLIO.MOBRAS TBMOBRAS
LEFT OUTER JOIN HUMIGES.MOBRASPLUS TBPLUS
TBMOBRAS.OROBR = TBPLUS.OROBR
AND TBMOBRAS.ORTP = ' P'
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.
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?