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

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.