Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Informix dbexport error

Posted on 2012-09-13
4
Medium Priority
?
991 Views
Last Modified: 2013-12-25
Hi Team,

I am getting a error while doing a dbexport with informix database.

I could able to see table named '1450' creating a problem and tried to remove table database and can't able to delete it.
Also,I have tried to remove the table row from systables but can't able to do it.

Error:
-201 - A syntax error has occurred.

Kindly let me know how to fix this issue.

Regards,
Sarvan,N
0
Comment
Question by:COS_IT_AU
  • 3
4 Comments
 
LVL 7

Expert Comment

by:jhp333
ID: 38402440
I think you probably already tried this:

DROP TABLE "1450";

The double-quotation marks are necessary.
0
 

Author Comment

by:COS_IT_AU
ID: 38404013
Hi JH,

I have already tried with the above query and it throws error.
Kindly let me know how to fix this issue.

Thanks,
Sarvan.N
0
 

Accepted Solution

by:
COS_IT_AU earned 0 total points
ID: 38412075
Hi,
I have managed to fix the issue.
0
 

Author Closing Comment

by:COS_IT_AU
ID: 38426062
I have managed to fix the issue.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question