analytics/informix/etc/boot911u.sql

{ ************************************************************************* }
{                                                                           }
{  Licensed Materials - Property of IBM and/or HCL                                     }
{                                                                           }
{  IBM Informix Dynamic Server                                              }
{  (c) Copyright IBM Corporation 1996, 2004 All rights reserved.            }
{  (c) Copyright HCL Technologies Ltd. 2017.  All Rights Reserved.             }
{                                                                           }
{ ************************************************************************* }
{                                                                           }
{   Title:      boot911u.sql                                                }
{                                                                           }
{   Description:                                                            }
{       Upgrading 9.11 databases to 9.12. All builtin UDRs are dropped      }
{       from the system catalog. They don't need to be there any more.      }
{                                                                           }
{ ************************************************************************* }

drop function informix.equal(informix.boolean, informix.boolean);
drop function informix.notequal(informix.boolean, informix.boolean);
drop function informix.compare(informix.boolean, informix.boolean);
drop function informix.compare(row, row);
drop function informix.equal(row, row);
drop function informix.notequal(row, row);
drop function informix.equal(informix.blob, informix.blob);
drop function informix.equal(informix.clob, informix.clob);
drop function informix.compare(informix.blob, informix.blob);
drop function informix.compare(informix.clob, informix.clob);
drop function informix.equal(char, char);
drop function informix.equal(nchar(1), nchar(1));
drop function informix.equal(varchar(1), varchar(1));
drop function informix.equal(nvarchar(1), nvarchar(1));
drop function informix.equal(smallint, smallint);
drop function informix.equal(int, int);
drop function informix.equal(int8, int8);
drop function informix.equal(decimal, decimal);
drop function informix.equal(real, real);
drop function informix.equal(float, float);
drop function informix.equal(date, date);
drop function informix.equal(datetime year to minute, datetime year to minute);
drop function informix.equal(interval year to month, interval year to month);
drop function informix.equal(money, money);
drop function informix.equal(references text, references text);
drop function informix.equal(references byte, references byte);
drop function informix.notequal(char, char);
drop function informix.notequal(nchar(1), nchar(1));
drop function informix.notequal(varchar(1), varchar(1));
drop function informix.notequal(nvarchar(1), nvarchar(1));
drop function informix.notequal(smallint, smallint);
drop function informix.notequal(int, int);
drop function informix.notequal(int8, int8);
drop function informix.notequal(decimal, decimal);
drop function informix.notequal(real, real);
drop function informix.notequal(float, float);
drop function informix.notequal(date, date);
drop function informix.notequal(datetime year to minute, datetime year to minute);
drop function informix.notequal(interval year to month, interval year to month);
drop function informix.notequal(money, money);
drop function informix.notequal(references text, references text);
drop function informix.notequal(references byte, references byte);
drop function informix.greaterthan(char, char);
drop function informix.greaterthan(nchar(1), nchar(1));
drop function informix.greaterthan(varchar(1), varchar(1));
drop function informix.greaterthan(nvarchar(1), nvarchar(1));
drop function informix.greaterthan(smallint, smallint);
drop function informix.greaterthan(int, int);
drop function informix.greaterthan(int8, int8);
drop function informix.greaterthan(decimal, decimal);
drop function informix.greaterthan(real, real);
drop function informix.greaterthan(float, float);
drop function informix.greaterthan(date, date);
drop function informix.greaterthan(datetime year to minute, datetime year to minute);
drop function informix.greaterthan(interval year to month, interval year to month);
drop function informix.greaterthan(money, money);
drop function informix.greaterthan(references text, references text);
drop function informix.greaterthan(references byte, references byte);
drop function informix.lessthan(char, char);
drop function informix.lessthan(nchar(1), nchar(1));
drop function informix.lessthan(varchar(1), varchar(1));
drop function informix.lessthan(nvarchar(1), nvarchar(1));
drop function informix.lessthan(smallint, smallint);
drop function informix.lessthan(int, int);
drop function informix.lessthan(int8, int8);
drop function informix.lessthan(decimal, decimal);
drop function informix.lessthan(real, real);
drop function informix.lessthan(float, float);
drop function informix.lessthan(date, date);
drop function informix.lessthan(datetime year to minute, datetime year to minute);
drop function informix.lessthan(interval year to month, interval year to month);
drop function informix.lessthan(money, money);
drop function informix.lessthan(references text, references text);
drop function informix.lessthan(references byte, references byte);
drop function informix.greaterthanorequal(char, char);
drop function informix.greaterthanorequal(nchar(1), nchar(1));
drop function informix.greaterthanorequal(varchar(1), varchar(1));
drop function informix.greaterthanorequal(nvarchar(1), nvarchar(1));
drop function informix.greaterthanorequal(smallint, smallint);
drop function informix.greaterthanorequal(int, int);
drop function informix.greaterthanorequal(int8, int8);
drop function informix.greaterthanorequal(decimal, decimal);
drop function informix.greaterthanorequal(real, real);
drop function informix.greaterthanorequal(float, float);
drop function informix.greaterthanorequal(date, date);
drop function informix.greaterthanorequal(datetime year to minute, datetime year to minute);
drop function informix.greaterthanorequal(interval year to month, interval year to month);
drop function informix.greaterthanorequal(money, money);
drop function informix.greaterthanorequal(references text, references text);
drop function informix.greaterthanorequal(references byte, references byte);
drop function informix.lessthanorequal(char, char);
drop function informix.lessthanorequal(nchar(1), nchar(1));
drop function informix.lessthanorequal(varchar(1), varchar(1));
drop function informix.lessthanorequal(nvarchar(1), nvarchar(1));
drop function informix.lessthanorequal(smallint, smallint);
drop function informix.lessthanorequal(int, int);
drop function informix.lessthanorequal(int8, int8);
drop function informix.lessthanorequal(decimal, decimal);
drop function informix.lessthanorequal(real, real);
drop function informix.lessthanorequal(float, float);
drop function informix.lessthanorequal(date, date);
drop function informix.lessthanorequal(datetime year to minute, datetime year to minute);
drop function informix.lessthanorequal(interval year to month, interval year to month);
drop function informix.lessthanorequal(money, money);
drop function informix.lessthanorequal(references text, references text);
drop function informix.lessthanorequal(references byte, references byte);
drop function informix.like(char(1), char(1));
drop function informix.like(nchar(1), nchar(1));
drop function informix.like(varchar(1), varchar(1));
drop function informix.like(nvarchar(1), nvarchar(1));
drop function informix.like(char(1), char(1), char(1));
drop function informix.like(nchar(1), nchar(1), nchar(1));
drop function informix.like(varchar(1), varchar(1), varchar(1));
drop function informix.like(nvarchar(1), nvarchar(1), nvarchar(1));
drop function informix.matches(char(1), char(1));
drop function informix.matches(nchar(1), nchar(1));
drop function informix.matches(varchar(1), varchar(1));
drop function informix.matches(nvarchar(1), nvarchar(1));
drop function informix.matches(char(1), char(1), char(1));
drop function informix.matches(nchar(1), nchar(1), nchar(1));
drop function informix.matches(varchar(1), varchar(1), varchar(1));
drop function informix.matches(nvarchar(1), nvarchar(1), nvarchar(1));
drop function informix.concat(char, char);
drop function informix.concat(nchar(1), nchar(1));
drop function informix.concat(varchar(1), varchar(1));
drop function informix.concat(nvarchar(1), nvarchar(1));
drop function informix.negate(smallint);
drop function informix.negate(int);
drop function informix.negate(int8);
drop function informix.negate(decimal);
drop function informix.negate(real);
drop function informix.negate(float);
drop function informix.negate(money);
drop function informix.minus(smallint, smallint);
drop function informix.minus(int, int);
drop function informix.minus(int8, int8);
drop function informix.minus(decimal, decimal);
drop function informix.minus(real, real);
drop function informix.minus(float, float);
drop function informix.minus(date, date);
drop function informix.minus(datetime year to minute, datetime year to minute);
drop function informix.minus(datetime year to minute, interval year to month);
drop function informix.minus(interval year to month, interval year to month);
drop function informix.minus(money, money);
drop function informix.positive(smallint);
drop function informix.positive(int);
drop function informix.positive(int8);
drop function informix.positive(decimal);
drop function informix.positive(real);
drop function informix.positive(float);
drop function informix.positive(money);
drop function informix.plus(smallint, smallint);
drop function informix.plus(int, int);
drop function informix.plus(int8, int8);
drop function informix.plus(decimal, decimal);
drop function informix.plus(real, real);
drop function informix.plus(float, float);
drop function informix.plus(date, date);
drop function informix.plus(datetime year to minute, interval year to month);
drop function informix.plus(interval year to month, interval year to month);
drop function informix.plus(money, money);
drop function informix.times(smallint, smallint);
drop function informix.times(int, int);
drop function informix.times(int8, int8);
drop function informix.times(decimal, decimal);
drop function informix.times(real, real);
drop function informix.times(float, float);
drop function informix.times(date, date);
drop function informix.times(interval year to month, interval year to month);
drop function informix.times(money, money);
drop function informix.divide(smallint, smallint);
drop function informix.divide(int, int);
drop function informix.divide(int8, int8);
drop function informix.divide(decimal, decimal);
drop function informix.divide(real, real);
drop function informix.divide(float, float);
drop function informix.divide(date, date);
drop function informix.divide(interval year to month, interval year to month);
drop function informix.divide(money, money);
drop function informix.abs(integer);
drop function informix.abs(smallint);
drop function informix.abs(int8);
drop function informix.abs(float);
drop function informix.abs(smallfloat);
drop function informix.abs(decimal);
drop function informix.abs(money);
drop function informix.abs(varchar(1));
drop function informix.abs(char(1));
drop function informix.abs(nvarchar(1));
drop function informix.abs(nchar(1));
drop function informix.exp(integer);
drop function informix.exp(smallint);
drop function informix.exp(int8);
drop function informix.exp(float);
drop function informix.exp(smallfloat);
drop function informix.exp(decimal);
drop function informix.exp(money);
drop function informix.exp(varchar(1));
drop function informix.exp(char(1));
drop function informix.exp(nvarchar(1));
drop function informix.exp(nchar(1));
drop function informix.hex(integer);
drop function informix.hex(smallint);
drop function informix.hex(int8);
drop function informix.hex(float);
drop function informix.hex(smallfloat);
drop function informix.hex(decimal);
drop function informix.hex(money);
drop function informix.hex(varchar(1));
drop function informix.hex(char(1));
drop function informix.hex(nvarchar(1));
drop function informix.hex(nchar(1));
drop function informix.log10(integer);
drop function informix.log10(smallint);
drop function informix.log10(int8);
drop function informix.log10(float);
drop function informix.log10(smallfloat);
drop function informix.log10(decimal);
drop function informix.log10(money);
drop function informix.log10(varchar(1));
drop function informix.log10(char(1));
drop function informix.log10(nvarchar(1));
drop function informix.log10(nchar(1));
drop function informix.logn(integer);
drop function informix.logn(smallint);
drop function informix.logn(int8);
drop function informix.logn(float);
drop function informix.logn(smallfloat);
drop function informix.logn(decimal);
drop function informix.logn(money);
drop function informix.logn(varchar(1));
drop function informix.logn(char(1));
drop function informix.logn(nvarchar(1));
drop function informix.logn(nchar(1));
drop function informix.mod(integer, integer);
drop function informix.mod(smallint, integer);
drop function informix.mod(int8, int8);
drop function informix.mod(float, integer);
drop function informix.mod(smallfloat, integer);
drop function informix.mod(decimal, integer);
drop function informix.mod(money, integer);
drop function informix.mod(varchar(1), integer);
drop function informix.mod(char(1), integer);
drop function informix.mod(nvarchar(1), integer);
drop function informix.mod(nchar(1), integer);
drop function informix.pow(integer, float);
drop function informix.pow(smallint, float);
drop function informix.pow(int8, float);
drop function informix.pow(float, float);
drop function informix.pow(smallfloat, float);
drop function informix.pow(decimal, float);
drop function informix.pow(money, float);
drop function informix.pow(varchar(1), float);
drop function informix.pow(char(1), float);
drop function informix.pow(nvarchar(1), float);
drop function informix.pow(nchar(1), float);
drop function informix.root(integer, float);
drop function informix.root(smallint, float);
drop function informix.root(int8, float);
drop function informix.root(float, float);
drop function informix.root(smallfloat, float);
drop function informix.root(decimal, float);
drop function informix.root(money, float);
drop function informix.root(varchar(1), float);
drop function informix.root(char(1), float);
drop function informix.root(nvarchar(1), float);
drop function informix.root(nchar(1), float);
drop function informix.round(integer, integer);
drop function informix.round(smallint, integer);
drop function informix.round(int8, integer);
drop function informix.round(float, integer);
drop function informix.round(smallfloat, integer);
drop function informix.round(decimal, integer);
drop function informix.round(money, integer);
drop function informix.round(varchar(1), integer);
drop function informix.round(char(1), integer);
drop function informix.round(nvarchar(1), integer);
drop function informix.round(nchar(1), integer);
drop function informix.sqrt(integer);
drop function informix.sqrt(smallint);
drop function informix.sqrt(int8);
drop function informix.sqrt(float);
drop function informix.sqrt(smallfloat);
drop function informix.sqrt(decimal);
drop function informix.sqrt(money);
drop function informix.sqrt(varchar(1));
drop function informix.sqrt(char(1));
drop function informix.sqrt(nvarchar(1));
drop function informix.sqrt(nchar(1));
drop function informix.trunc(integer, integer);
drop function informix.trunc(smallint, integer);
drop function informix.trunc(int8, integer);
drop function informix.trunc(float, integer);
drop function informix.trunc(smallfloat, integer);
drop function informix.trunc(decimal, integer);
drop function informix.trunc(money, integer);
drop function informix.trunc(varchar(1), integer);
drop function informix.trunc(char(1), integer);
drop function informix.trunc(nvarchar(1), integer);
drop function informix.trunc(nchar(1), integer);
drop function informix.cos(integer);
drop function informix.cos(smallint);
drop function informix.cos(int8);
drop function informix.cos(float);
drop function informix.cos(smallfloat);
drop function informix.cos(decimal);
drop function informix.cos(money);
drop function informix.cos(varchar(1));
drop function informix.cos(char(1));
drop function informix.cos(nvarchar(1));
drop function informix.cos(nchar(1));
drop function informix.sin(integer);
drop function informix.sin(smallint);
drop function informix.sin(int8);
drop function informix.sin(float);
drop function informix.sin(smallfloat);
drop function informix.sin(decimal);
drop function informix.sin(money);
drop function informix.sin(varchar(1));
drop function informix.sin(char(1));
drop function informix.sin(nvarchar(1));
drop function informix.sin(nchar(1));
drop function informix.tan(integer);
drop function informix.tan(smallint);
drop function informix.tan(int8);
drop function informix.tan(float);
drop function informix.tan(smallfloat);
drop function informix.tan(decimal);
drop function informix.tan(money);
drop function informix.tan(varchar(1));
drop function informix.tan(char(1));
drop function informix.tan(nvarchar(1));
drop function informix.tan(nchar(1));
drop function informix.acos(integer);
drop function informix.acos(smallint);
drop function informix.acos(int8);
drop function informix.acos(float);
drop function informix.acos(smallfloat);
drop function informix.acos(decimal);
drop function informix.acos(money);
drop function informix.acos(varchar(1));
drop function informix.acos(char(1));
drop function informix.acos(nvarchar(1));
drop function informix.acos(nchar(1));
drop function informix.asin(integer);
drop function informix.asin(smallint);
drop function informix.asin(int8);
drop function informix.asin(float);
drop function informix.asin(smallfloat);
drop function informix.asin(decimal);
drop function informix.asin(money);
drop function informix.asin(varchar(1));
drop function informix.asin(char(1));
drop function informix.asin(nvarchar(1));
drop function informix.asin(nchar(1));
drop function informix.atan(integer);
drop function informix.atan(smallint);
drop function informix.atan(int8);
drop function informix.atan(float);
drop function informix.atan(smallfloat);
drop function informix.atan(decimal);
drop function informix.atan(money);
drop function informix.atan(varchar(1));
drop function informix.atan(char(1));
drop function informix.atan(nvarchar(1));
drop function informix.atan(nchar(1));
drop function informix.atan2(integer, float);
drop function informix.atan2(smallint, float);
drop function informix.atan2(int8, float);
drop function informix.atan2(float, float);
drop function informix.atan2(smallfloat, float);
drop function informix.atan2(decimal, float);
drop function informix.atan2(money, float);
drop function informix.atan2(varchar(1), float);
drop function informix.atan2(char(1), float);
drop function informix.atan2(nvarchar(1), float);
drop function informix.atan2(nchar(1), float);
drop function informix.length(varchar(1));
drop function informix.length(char(1));
drop function informix.length(nvarchar(1));
drop function informix.length(nchar(1));
drop function informix.length(references byte);
drop function informix.length(references text);
drop function informix.octet_length(varchar(1));
drop function informix.octet_length(char(1));
drop function informix.octet_length(nvarchar(1));
drop function informix.octet_length(nchar(1));
drop function informix.octet_length(references byte);
drop function informix.octet_length(references text);
drop function informix.char_length(varchar(1));
drop function informix.char_length(char(1));
drop function informix.char_length(nvarchar(1));
drop function informix.char_length(nchar(1));
drop function informix.char_length(references byte);
drop function informix.char_length(references text);
drop function informix.character_length(varchar(1));
drop function informix.character_length(char(1));
drop function informix.character_length(nvarchar(1));
drop function informix.character_length(nchar(1));
drop function informix.character_length(references byte);
drop function informix.character_length(references text);
drop function informix.equal(informix.lvarchar, informix.lvarchar);
drop function informix.notequal(informix.lvarchar, informix.lvarchar);
drop function informix.greaterthan(informix.lvarchar, informix.lvarchar);
drop function informix.lessthan(informix.lvarchar, informix.lvarchar);
drop function informix.greaterthanorequal(informix.lvarchar, informix.lvarchar) ;
drop function informix.lessthanorequal(informix.lvarchar, informix.lvarchar) ;
drop function informix.compare(informix.lvarchar, informix.lvarchar);
drop specific function ifx_serial_equal;
drop specific function ifx_serial8_equal;
drop specific function ifx_serial_not_equal;
drop specific function ifx_serial8_not_equal;
drop specific function ifx_serial_greater_than;
drop specific function ifx_serial8_greater_than;
drop specific function ifx_serial_less_than;
drop specific function ifx_serial8_less_than;
drop specific function ifx_serial_greater_than_or_equal;
drop specific function ifx_serial8_greater_than_or_equal;
drop specific function ifx_serial_less_than_or_equal;
drop specific function ifx_serial8_less_than_or_equal;
drop specific function ifx_serial_negate;
drop specific function ifx_serial8_negate;
drop specific function ifx_serial_minus;
drop specific function ifx_serial8_minus;
drop specific function ifx_serial_positive;
drop specific function ifx_serial8_positive;
drop specific function ifx_serial_plus;
drop specific function ifx_serial8_plus;
drop specific function ifx_serial_times;
drop specific function ifx_serial8_times;
drop specific function ifx_serial_divide;
drop specific function ifx_serial8_divide;
drop specific function ifx_serial_abs;
drop specific function ifx_serial8_abs;
drop specific function ifx_serial_exp;
drop specific function ifx_serial8_exp;
drop specific function ifx_serial_hex;
drop specific function ifx_serial8_hex;
drop specific function ifx_serial_log10;
drop specific function ifx_serial8_log10;
drop specific function ifx_serial_logn;
drop specific function ifx_serial8_logn;
drop specific function ifx_serial_mod;
drop specific function ifx_serial8_mod;
drop specific function ifx_serial_pow;
drop specific function ifx_serial8_pow;
drop specific function ifx_serial_root;
drop specific function ifx_serial8_root;
drop specific function ifx_serial_round;
drop specific function ifx_serial8_round;
drop specific function ifx_serial_sqrt;
drop specific function ifx_serial8_sqrt;
drop specific function ifx_serial_trunc;
drop specific function ifx_serial8_trunc;
drop specific function ifx_serial_cos;
drop specific function ifx_serial8_cos;
drop specific function ifx_serial_sin;
drop specific function ifx_serial8_sin;
drop specific function ifx_serial_tan;
drop specific function ifx_serial8_tan;
drop specific function ifx_serial_acos;
drop specific function ifx_serial8_acos;
drop specific function ifx_serial_asin;
drop specific function ifx_serial8_asin;
drop specific function ifx_serial_atan;
drop specific function ifx_serial8_atan;
drop specific function ifx_serial_atan2;
drop specific function ifx_serial8_atan2;
drop function informix.like(lvarchar, lvarchar);
drop function informix.like(lvarchar, lvarchar, lvarchar);
drop function informix.matches(lvarchar, lvarchar);
drop function informix.matches(lvarchar, lvarchar, lvarchar);
drop function informix.concat(informix.lvarchar, informix.lvarchar);
drop function informix.length(lvarchar);
drop function informix.octet_length(lvarchar);
drop function informix.char_length(lvarchar);
drop function informix.equal(set, set);
drop function informix.notequal(set, set);
drop function informix.equal(list, list);
drop function informix.notequal(list, list);
drop function informix.equal(multiset, multiset);
drop function informix.notequal(multiset, multiset);

drop function informix.compare(set, set);
drop function informix.compare(multiset, multiset);
drop function informix.compare(list, list);