• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 998
  • Last Modified:

Informix dbexport error

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
COS_IT_AU
Asked:
COS_IT_AU
  • 3
1 Solution
 
jhp333Commented:
I think you probably already tried this:

DROP TABLE "1450";

The double-quotation marks are necessary.
0
 
COS_IT_AUAuthor Commented:
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
 
COS_IT_AUAuthor Commented:
Hi,
I have managed to fix the issue.
0
 
COS_IT_AUAuthor Commented:
I have managed to fix the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now