Frank Rocco
|
| Posted: 08/15/2002, 1:19 PM |
|
Hello,
Using CCS and PHP, I have a sql join connection to our AS/400 using ODBC.
I get a query failed error, time limit of 30 seconds exceeded.
Thanks for the help.
Here is my SQL
SELECT DOACCT, DOCDS#, DOORD#, DORDAT, DORDCN,
DORTIM,DOSCCN,DOSCDT,DOSCTM,SEDDIC,SEDTRN,SETIMD,SETIMT,DOPTY,sigdat,sigtim,
meledt,mecen1,mestti,meptyp FROM bsydtad.sesplinx a INNER JOIN
bsydtab.bocmdou1 ON (a.radord = doord# and a.pacct# = doacct and a.sehsp# =
1) INNER JOIN tadata.mrsplinx ON (a.sehsp# = sphsp# and a.setrnt = trntyp
and a.sesplf = splfil) INNER JOIN bsydtab.bxrmmeu ON (a.radord = meord# and
a.pacct# = meacct and a.sehsp# = mehsp#)
|
|
|
 |
RonB
|
| Posted: 08/15/2002, 2:27 PM |
|
in php.ini change maximum time from 30 to 60 seconds. A query taking more
then 30 seconds is a problem in it's own right though, seems hardly usefull.
RonB
"Frank Rocco" <farocco@hotmail.com> schreef in bericht
news:ajh2ci$b92$1@news.codecharge.com...
> Hello,
>
> Using CCS and PHP, I have a sql join connection to our AS/400 using ODBC.
> I get a query failed error, time limit of 30 seconds exceeded.
>
> Thanks for the help.
>
> Here is my SQL
>
> SELECT DOACCT, DOCDS#, DOORD#, DORDAT, DORDCN,
>
DORTIM,DOSCCN,DOSCDT,DOSCTM,SEDDIC,SEDTRN,SETIMD,SETIMT,DOPTY,sigdat,sigtim,
> meledt,mecen1,mestti,meptyp FROM bsydtad.sesplinx a INNER JOIN
> bsydtab.bocmdou1 ON (a.radord = doord# and a.pacct# = doacct and a.sehsp#
=
> 1) INNER JOIN tadata.mrsplinx ON (a.sehsp# = sphsp# and a.setrnt = trntyp
> and a.sesplf = splfil) INNER JOIN bsydtab.bxrmmeu ON (a.radord = meord#
and
> a.pacct# = meacct and a.sehsp# = mehsp#)
>
>
|
|
|
|
Frank Rocco
|
| Posted: 08/15/2002, 3:23 PM |
|
Thanks I found it.
This app runs fine in CC2, but gives me that error after I convert it to
CCS.
Frank
|
|
|
|
|
