SQl Code -904 with where clause in SQL Query

ksathishkumar83 · New User Joined: 21 Nov 2006 Posts: 50 Location: India

I am getting a SQL code -904 when a Query is executed with where clause.

Select * from t1 where c1='a'

But with out where clause the Quey is successfull.

Select * from t1

wanderer · Posted: Tue May 08, 2007 10:14 pm

How about posting the complete error message?

Perhaps you have a bad index.

Frederic Lavoie · New User Joined: 07 May 2007 Posts: 6 Location: Ottawa

maybe column C1 is part of an index that is stoped or in ut.

rajandhla · Posted: Wed May 09, 2007 10:48 am

Explanation: The SQL statement could not be executed because resource
'resource-name' of type 'resource-type' was not available at the time for
the reason indicated by 'reason-code'. Refer to Table 3 in Appendix B,
"Problem determination" in item PROBLEM_DETERMIN for an explanation of
resource type codes. Refer to "DB2 Codes" for an explanation of the given
reason code.

Regards,
jai

ahr · New User Joined: 24 Apr 2007 Posts: 14 Location: India

Give a complete description whther you are using this SQL statements in a program or in SPUFI.