RE: CPD4365 -- Query resource limit exceeded.

David,

Does this query by chance use a User defined table function?

They have there own time-out.

Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David Gibbs
Sent: Monday, July 09, 2007 4:19 PM
To: Midrange Systems Technical Discussion
Cc: Java Programming on and around the iSeries / AS400
Subject: CPD4365 -- Query resource limit exceeded.

Folks:

I've got a rather complex sql statement that's getting an
error when it's processed through JDBC.

The error that is being returned is SQL0901, but the
QZDASOINIT job's joblog has CPD4365 in it with a reason code
of 8. RC8 means "The processing of a subselect exceeded the
allowable time. ".

Does anyone know of a way, either through Java or a system
value, to adjust the amount of time a sub-select is allowed
to process?

Thanks!

david

--
System i ... for when you can't afford to be out of business
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please reply
to the message immediately by informing the sender that the message was
misdirected. After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting this
error is appreciated.