By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Getting exception in Java application with error code "DB2 SQL error: SQLCODE: -901"

P: 1
Hi,
Need help for this as i have been looking for it but could not get any results.
We are using java as front end and DB2 as backend, i m getting the exception while executing a particular query with following error description:

DB2 SQL error: SQLCODE: -901, SQLSTATE: 58004, SQLERRMC: sqlno_itr_plan::next [300]:rc( 0)

SQLCODE: -901 this error code says "Non severe System error"

This query was working fine till now but recently it has started throwing error.
My query is a search query and it works fine for blank search but as we enter any search criteria it gives the above error.
Query is some what like this:

SELECT * FROM ( SELECT TEMP1.*,ROW_NUMBER() OVER() AS ROW_NUM FROM ( select distinct
------------- some more AND conditions -----------------)
AND exists (SELECT 1 FROM SESSION.tmpDepartment WHERE divisioncode = A.divisioncode AND loccd = A.loccd AND dptcd = A.dptcd) AND ltrim(rtrim(UPPER(A.dptcd))) like '%abc%' order by 1 ASC ) AS TEMP1 ) AS TEMP2 WHERE ((ROW_NUM -1) /5) + 1 = 1

Need your help.
Thanks to all those who will be replying.
Apr 30 '07 #1
Share this Question
Share on Google+
1 Reply


P: 20
Hi,
Need help for this as i have been looking for it but could not get any results.
We are using java as front end and DB2 as backend, i m getting the exception while executing a particular query with following error description:

DB2 SQL error: SQLCODE: -901, SQLSTATE: 58004, SQLERRMC: sqlno_itr_plan::next [300]:rc( 0)

SQLCODE: -901 this error code says "Non severe System error"

This query was working fine till now but recently it has started throwing error.
My query is a search query and it works fine for blank search but as we enter any search criteria it gives the above error.
Query is some what like this:

SELECT * FROM ( SELECT TEMP1.*,ROW_NUMBER() OVER() AS ROW_NUM FROM ( select distinct
------------- some more AND conditions -----------------)
AND exists (SELECT 1 FROM SESSION.tmpDepartment WHERE divisioncode = A.divisioncode AND loccd = A.loccd AND dptcd = A.dptcd) AND ltrim(rtrim(UPPER(A.dptcd))) like '%abc%' order by 1 ASC ) AS TEMP1 ) AS TEMP2 WHERE ((ROW_NUM -1) /5) + 1 = 1

Need your help.
Thanks to all those who will be replying.

Is there an abend? A -901 error is normally caused by a prior error that prevents the current SQL being executed. Check to make sure there are no resources locked or pending commits.
May 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.