Home > IT Answers > Development > Sql Query in AS400
Mr. SEA
130 pts.
 Sql Query in AS400
SQL Query, SQL query optimization
I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

Software/Hardware used:
ASKED: July 20, 2009  7:21 AM
UPDATED: July 20, 2009  3:35 PM
RELATED QUESTIONS
Answer Wiki:
What does it say in the joblog? in QHST? use the query debugging tools What state is thge data in? What access paths exist / are being created? The joblog is your friend
Last Wiki Answer Submitted:  July 20, 2009  3:35 pm  by  Yorkshireman   5,505 pts.
All Answer Wiki Contributors:  Yorkshireman   5,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _