Informix Database-958 error code temporary table repeat __ Error note

Source: Internet
Author: User
Tags informix

Turn from: 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 of is shown, but a temporary table with that name already exists. Only one temporary table and a given name can exist in a session.

Check the spelling of the name. If the name is spelled as your 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 <tabl e-name>;
End If


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.