如何知道语句执行成功与否？

一个菜鸟

我的系统是NT4.0、IDS7.3
我用select dbinfo('sqlca.sqlcode') from systables where tabid=1;它老是报错提示‘Unknown first argument of dbinfo('sqlca.sqlcode')’，那该怎么用？谢谢了

wenlq

dbinfo 的参数 是有限制的。

DBINFO ('dbhostname')
DBINFO ('version', 'server-type')
DBINFO ('version', 'major')
DBINFO ('version', 'minor')
DBINFO ('version', 'os')
DBINFO ('version', 'level')
DBINFO ('version', 'full')
DBINFO ('utc_to_datetime',
DBINFO ('utc_current')
DBINFO ('get_tz')
DBINFO ('sessionid')
DBINFO ('dbspace',
DBINFO ('sqlca.sqlerrd1')
DBINFO ('sqlca.sqlerrd2')

wenlq

http://bbs.chinaunix.net/viewthread.php?tid=683953

一个菜鸟

谢谢，我用DBINFO ('sqlca.sqlerrd2') 时有这样的情况
select * from operater  //实际有120条
用DBINFO ('sqlca.sqlerrd2') 显示1
select * from operater where code_dep='0001' //实际有20条
用DBINFO ('sqlca.sqlerrd2') 显示20

不知何故？

wenlq

from iiug faq

6.13 Is the number of rows processed in the SQLERRD structure accurate?
... or is it just an estimate?

The info in the SQLERRD item is only filled in after you've processed the last row. It therefore isn't much help in the context of SELECT.

It is very useful in the context of:

DELETE FROM Table WHERE ...
UPDATE Table SET .... WHERE ...
INSERT INTO Table SELECT ...
SELECT .... INTO TEMP Table
In all cases, it is an exact number.

With the more recent Engines, the estimates of the cost and number of rows to be returned are also available. For more information look in the Informix Guide to SQL Reference Manuals under 'Error checking with SQLCA' (or under 6.0, the individual ESQL manuals).