{ ************************************************************************* }
{                                                                           }
{  Licensed Materials - Property of IBM and/or HCL                                     }
{                                                                           }
{  IBM Informix Dynamic Server                                              }
{  (c) Copyright IBM Corporation 2003, 2006 All rights reserved.            }
{  (c) Copyright HCL Technologies Ltd. 2017.  All Rights Reserved.             }
{                                                                           }
{   Title:      meta_drop.sql                                               }
{                                                                           }
{   Description:                                                            }
{       script to drop metadata procs for a 10.00 database                  }
{                                                                           }
{ ************************************************************************* }
{                                                                           }
{  ** IMPORTANT - PLEASE READ                                               }
{                                                                           }
{     All types and routines referenced in this file must be prefixed       }
{     with the user name "informix". E.g., use "informix.boolean"           }
{     and not "boolean"                                                     }
{                                                                           }
{     Also, please follow the formatting conventions!!!                     }
{                                                                           }
{     Please ensure that the identifiers that you choose are <= 18          }
{     characters in length. Otherwise the changes would affect database     }
{     reversion.                                                            }
{                                                                           }
{ ************************************************************************* }

drop function informix.open_new_cur (informix.lvarchar, informix.lvarchar);
drop function informix.find_token(informix.lvarchar, informix.lvarchar);
drop function informix.find_int_token(informix.lvarchar, informix.lvarchar, integer);
drop procedure informix.strtok(varchar(254), integer);
drop procedure informix.get_taboptions(varchar(254));
drop function SYSIBM.__SQLColPrivileges(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLColPrivileges( varchar(128), varchar(128),varchar(128), varchar(128), char(4000));
drop function informix.schema_ids2db2(smallint, smallint);
drop procedure informix.schema_coltype(smallint, smallint);
drop procedure informix.schema_maxlen(smallint, smallint);
drop procedure informix.schema_bufflen(smallint, smallint);
drop procedure informix.schema_numscale(smallint, smallint);
drop procedure informix.schema_numprecradix( smallint);
drop procedure informix.schema_isnullable(smallint);
drop procedure informix.schema_nullable(smallint);
drop procedure informix.schema_datetype(smallint, smallint);
drop function SYSIBM.__SQLColumns(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLColumns( varchar(128), varchar(128),varchar(128), varchar(128), char(4000));
drop procedure SYSIBM.PseudoSQLColumns( varchar(128), varchar(128),varchar(128), varchar(128), char(4000));
drop function SYSIBM.__SQLForeignKeys(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLForeignKeys( varchar(128), varchar(128), varchar(128), varchar(128), varchar(128), varchar(128),char(4000));
drop function informix.schema_db2ids(smallint);
drop function informix.schema_keywords(smallint);
drop function informix.schema_case_sensitive(smallint);
drop function informix.schema_searchable(smallint);
drop function informix.schema_unsigned_attribute(smallint);
drop function informix.schema_auto_increment(smallint);
drop procedure SYSIBM.SQLGetTypeInfo(smallint, char(4000));
drop function SYSIBM.__SQLPrimaryKeys(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLPrimaryKeys( varchar(128), varchar(128), varchar(128), char(4000));
drop function SYSIBM.__SQLProcedureCols(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLProcedureCols( varchar(128), varchar(128),varchar(128), varchar(128), char(4000));
drop function SYSIBM.__sqlprocedures(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLProcedures( varchar(128), varchar(128),varchar(128), char(4000));
drop function SYSIBM.__SQLStatistics(informix.lvarchar ,informix.lvarchar); 
drop procedure SYSIBM.SQLStatistics( varchar(128), varchar(128),varchar(128), smallint, smallint, char(4000));
drop function SYSIBM.__SQLTablePrivileges(informix.lvarchar ,informix.lvarchar);
drop procedure SYSIBM.SQLTablePrivileges( varchar(128), varchar(128),varchar(128), char(4000));
drop procedure SYSIBM.SQLTables( varchar(128), varchar(128),varchar(128), char(4000), char(4000));
drop procedure informix.is_pattern_arg(varchar(255), char(4000));
drop function SYSIBM.__SQLSpecialColumns(informix.lvarchar,informix.lvarchar);
drop procedure SYSIBM.SQLSpecialColumns( smallint, varchar(128), varchar(128), varchar(128), smallint, smallint, char(4000));
drop function SYSIBM.__getFragType(informix.lvarchar,informix.lvarchar);
drop procedure SYSIBM.SQLCAMessageCCSID( integer, smallint, varchar(70), char(8), integer, integer, integer, integer, integer, integer, char(11), char (5), varchar(20), varchar(33), lvarchar(4096), integer, integer);
drop procedure SYSIBM.METADATA(integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, lvarchar(4096), varchar(100), varchar(100),varchar(100), varchar(100), varchar(25), varchar(25), integer, integer, integer, varchar(255), integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, varchar(50), varchar(50), varchar(50), integer, varchar(50), integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, varchar(50), integer, integer, integer, integer, varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), integer, integer, integer, integer, integer, integer);
