在informix中,674和111错误是什么意思?

[cdqy]

在informix中,674和111错误是什么意思?
select count(*) from jbby_lb where trim(lb_name) matches '0%'

报这种错!!!

[wenlq]

-674 Procedure procedure-name not found.
-111 ISAM error: no record found.
你的是什么版本？ 我认为该版本不认 trim 函数，把它当存储过程来看了。

[cdqy]

$ finderr 674
-674 Routine <routine-name> can not be resolved.

You called a routine that does not exist in the database, or you do not have
permission to execute the routine. If you invoke a routine and your
application or another application drops the routine before you execute a
prepared statement, you receive this error.

Check that the name of the routine is correct and that you have permission
to execute the routine. For a prepared statement that refers to the routine,
make sure that it is still running when you execute the statement.


$ finderr 111
-111 ISAM error: no record found.

The ISAM processor cannot locate the requested record. For C-ISAM
programs, no record was found with the requested index value or record
number, depending on the retrieval mode in use. Make sure that the
correct index is in use. For SQL products, see the SQL error message or
return code. Probably no row was found for this query.

[sharpen]

-674 未发现常式的 routine_name.

所呼叫的常式不在资料库中. 如果您启动常式, 在你执行准备的叙述之前, 你的
应用程式或另一个应用程式将常式移除, 就会得到这个错误.

-111 ISAM 错误: 找不到记录.

ISAM 处理器无法找到要求的记录. 对 C-ISAM 程式, 依据使用中的读取
模式, 找不到具有要求的索引值或记录号码的记录. 请确认使用中的索引
是正确的. 对 SQL 产品而言, 叁阅SQL 错误讯息或传回码. 可能是这次的
查询并没有找到符合的列.