{ ************************************************************************* } { } { 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);