SQL code -905

 

 
 
 
 
 
 
 
 
 
SQL CODE -905
 
What is Sql code -905 ?
 
Sql code -905 is unsuccessful execution of Sql query due to 
resource limit beign exceeded
 
When does sql code -905 comes?
 
Sqlcode -905 can come if the limit is exceeded for the resource.
 
For example:-  A system has a limit of CPU time alloted for a 
query and if the time taken by a query exceeds this limit than sql code
-905 will come.
 
How does system behave for sql code -905?
 
Execution of the query is terminated.
 
How to resolve sql code of-905?
; ; ; ;
 
You can analyse why the time taken by the query is so much and you may 
want to optimize the query or you can contact your system admin who
takes care of maintaining this resource limit.