analytics/informix/etc/boot910.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:      boot910.sql                                                 }
{                                                                           }
{   Description:                                                            }
{       Bootstrapping script for a 9.1 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!!!                     }
{                                                                           }
{ ************************************************************************* }

-- Define recovery related functions for the rtree access method:
create function informix.rlt_redo(pointer, pointer, int, int)
    returns int
    external name '(rlt_redo)'
    language C;
create function informix.rlt_undo(pointer, pointer, int, int)
    returns int
    external name '(rlt_undo)'
    language C;
create function informix.rlt_commit(int)
    returns int
    external name '(rlt_commit)'
    language C;
create function informix.rlt_abort(int)
    returns int
    external name '(rlt_abort)'
    language C;

-- Add [not] equal function for collections.
create function informix.equal(set, set) returns informix.boolean
        external name '(collequal)' language C not variant;
create function informix.notequal(set, set) returns informix.boolean
        external name '(collnotequal)' language C not variant;

create function informix.equal(list, list) returns informix.boolean 
        external name '(collequal)' language C not variant;
create function informix.notequal(list, list) returns informix.boolean
        external name '(collnotequal)' language C not variant;
 
create function informix.equal(multiset, multiset) returns informix.boolean
        external name '(collequal)' language C not variant; 
create function informix.notequal(multiset, multiset) returns informix.boolean
        external name '(collnotequal)' language C not variant;