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