INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

You have different databases where an object exists. In some
databases this object is a view and in other databases this is a
table.
In the SQL update scripts to change this object to a table you
want to execute:

DROP TABLE IF EXISTS object_name;
DROP VIEW IF EXISTS object_name;
CREATE TABLE object_name;

You expect that the query should not generate any (error)
message following the documented specification of this
functionality... so that the construction with "IF EXISTS"
should be possible.

In our documentation we state the following:

1)
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com
.ibm.sqls.doc/ids_sqs_0744.htm - DROP VIEW statement:
   "If you include the optional IF EXISTS keywords, the database
server takes no action (rather than sending an exception to the
application) if no view of the specified name is registered in
the current database".

2)
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com
.ibm.sqls.doc/ids_sqs_0736.htm - DROP TABLE statement:
   "If you include the optional IF EXISTS keywords, the database
server takes no action (rather than sending an exception to the
application) if no table of the specified name is registered in
the current database".

a) Running the following query:

          create view 'informix'.test1 (tabid) as select tabid
from systables where tabid = 1;
          create table test2 (col1 int);
          drop view if exists test2; --test2 is a table

   You get the error "394: View (informix.test2) not found".

b) Running the following query:

          create view 'informix'.test1 (tabid) as select tabid
from systables where tabid = 1;
          create table test2 (col1 int);
          drop table if exists test1; --test1 is a view

   You get the error "523: Can only recover, repair, truncate of
drop table".

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Drop table/view with 'IF EXISTS' resulting in error          *
* -523/-394 when view/table name given.                        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.12.2018
03.10.2019
03.10.2019

12.10.xC13