analytics/informix/etc/boot1000.sql

{ ************************************************************************* }
{                                                                           }
{  Licensed Materials - Property of IBM and/or HCL                                     }
{                                                                           }
{  IBM Informix Dynamic Server                                              }
{  (c) Copyright IBM Corporation 2003, 2004 All rights reserved.            }
{  (c) Copyright HCL Technologies Ltd. 2017.  All Rights Reserved.             }
{                                                                           }
{   Title:      boot1000.sql                                                }
{                                                                           }
{   Description:                                                            }
{       Bootstrapping script for a 10.00 databas                            }
{                                                                           }
{ ************************************************************************* }
{                                                                           }
{  ** 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.                                                            }
{                                                                           }
{ ************************************************************************* }

{  --- Create CDR exposed functions  }

create dba function informix.cdrcmd(informix.integer)
    returns informix.integer
    external name '(cdrcmd_1)'
    language C;

grant execute on function informix.cdrcmd(informix.integer)
    to public as informix;


create dba procedure informix.cdrcmdproc(informix.integer)
    external name '(cdrcmd_1)'
    language C
  end procedure;

grant execute on procedure informix.cdrcmdproc(informix.integer)
    to public as informix;

create dba function informix.cdrcmd(informix.integer, informix.integer)
    returns informix.integer
    external name '(cdrcmd_2)'
    language C;

grant execute on function informix.cdrcmd(informix.integer, informix.integer)
    to public as informix;

create dba function informix.cdrcmd(informix.integer, informix.integer, informix.integer)
    returns informix.integer
    external name '(cdrcmd_3)'
    language C;

grant execute on function informix.cdrcmd(informix.integer, informix.integer, informix.integer) to public as informix;


create dba function informix.cdrcmd(informix.integer, informix.lvarchar)
    returns informix.integer
    external name '(cdrcmd_4)'
    language C;

grant execute on function informix.cdrcmd(informix.integer, informix.lvarchar)
    to public as informix;