informix数据库 -958错误码 临时表重复

转自:http://blog.163.com/hanjh_520/blog/static/2186737220100125245614/


-958    Temp table <table-name> already exists in session.

This statement tries to create a table with the name that is shown, but a temporary table with that name already exists. Only one  temporary table with a given name can exist in a session.

Check the spelling of the name. If the name is spelled as you intended, check that a temporary table with the given name does not exist in the session. To review the names of temporary tables, query the systabnames table as follows:

    SELECT dbsname, tabname FROM sysmaster:systabnames
           WHERE tabname = <table-name>

If the name exists, review this name by querying the systables table in <dbsname>:

    SELECT tabname FROM <dbsname>:systables
           WHERE tabname = <table-name>

If the name does not exist in systables (" No rows found "), this table is a temporary table.


solution:

if exists (SELECT dbsname, tabname FROM sysmaster:systabnames WHERE tabname = <table-name> )
    drop table <table-name>;
end if


阅读更多
个人分类: 错误笔记
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭