Unanswered: IQ - Weird issue when doing a create or replace view
I'm having a really weird issue with IQ.
I'm trying to run a "create or replace" script on a view.
When I run the script, I get an error saying that there is already an object "MY_VIEW", here is the message:
Error during Execute
S0001(-110)[Sybase][ODBC Driver][Sybase IQ]Item 'MY_VIEW' already exists
If I try to drop the view with a DROP VIEW command, I get the error that the table does not exist.
I know my script is correct, I have no issues creating (or "create or replace") with a different name.
It's like this object is "stock" in the metadata or something like that.