analytics/informix/extend/excompat.1.0/objects.sql

-- Generated by BladeSmith 4.20.TC1  DO NOT MODIFY. --

execute procedure ifx_allow_newline('t');

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 0, "dbms_alert_table_create",
	"%SYSBLDUSER%", 0,
	"create table if not exists DBMS_ALERT_EVENTS
( event_id SERIAL unique,
  event_name VARCHAR(30) primary key
);

create table if not exists DBMS_ALERT_REGISTERED
( session_id INTEGER,
  event_id INTEGER references DBMS_ALERT_EVENTS(event_id)
);

create unique index if not exists DBMS_ALERT_SESIDX
  on DBMS_ALERT_REGISTERED (session_id, event_id);

create table if not exists DBMS_ALERT_SIGNALED
( event_id INTEGER references DBMS_ALERT_EVENTS(event_id),
  session_id INTEGER,
  signal_time DATETIME year to second,
  alert_msg LVARCHAR
);

",
	"f",
	"drop table if exists DBMS_ALERT_EVENTS;
drop table if exists DBMS_ALERT_REGISTERED;
drop table if exists DBMS_ALERT_SIGNALED;
",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 7, "utl_file_file_type",
	"%SYSBLDUSER%", 0,
	"create distinct type utl_file_file_type as integer;

",
	"f",
	"drop type utl_file_file_type restrict;

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 71, "utl_file_file_type",
	"%SYSBLDUSER%", 0,
	"grant usage on type utl_file_file_type to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	71, "utl_file_file_type",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 7, "dbms_output_chararr",
	"%SYSBLDUSER%", 0,
	"create distinct type dbms_output_chararr as lvarchar;

",
	"f",
	"drop type dbms_output_chararr restrict;

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 71, "dbms_output_chararr",
	"%SYSBLDUSER%", 0,
	"grant usage on type dbms_output_chararr to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	71, "dbms_output_chararr",
	"%SYSBLDUSER%",
	7, "dbms_output_chararr",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"create function utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)
returns utl_file_file_type
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fopen)"" language c;

",
	"f",
	"drop function utl_file_fopen (lvarchar,lvarchar,lvarchar,integer);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	5, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"alter function utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fopen)"");

",
	"f",
	"alter function utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)
	with (Modify External Name = ""utl_file_fopen"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%",
	5, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function utl_file_fopen (lvarchar,lvarchar,lvarchar,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%",
	5, "utl_file_fopen (lvarchar,lvarchar,lvarchar,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"create function utl_file_is_open (utl_file_file_type)
returns boolean
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_is_open)"" language c;

",
	"f",
	"drop function utl_file_is_open (utl_file_file_type);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	5, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"alter function utl_file_is_open (utl_file_file_type)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_is_open)"");

",
	"f",
	"alter function utl_file_is_open (utl_file_file_type)
	with (Modify External Name = ""utl_file_is_open"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%",
	5, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"grant execute on function utl_file_is_open (utl_file_file_type) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%",
	5, "utl_file_is_open (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_fclose (utl_file_file_type)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fclose)"" language c;

",
	"f",
	"drop procedure utl_file_fclose (utl_file_file_type);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_fclose (utl_file_file_type)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fclose)"");

",
	"f",
	"alter procedure utl_file_fclose (utl_file_file_type)
	with (Modify External Name = ""utl_file_fclose"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_fclose (utl_file_file_type) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_fclose (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_get_line (utl_file_file_type,out lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_get_line)"" language c;

",
	"f",
	"drop procedure utl_file_get_line (utl_file_file_type,lvarchar);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_get_line (utl_file_file_type,lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_get_line)"");

",
	"f",
	"alter procedure utl_file_get_line (utl_file_file_type,lvarchar)
	with (Modify External Name = ""utl_file_get_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%",
	6, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_get_line (utl_file_file_type,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%",
	6, "utl_file_get_line (utl_file_file_type,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_put (utl_file_file_type)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_put)"" language c;

",
	"f",
	"drop procedure utl_file_put (utl_file_file_type);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_put (utl_file_file_type)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_put)"");

",
	"f",
	"alter procedure utl_file_put (utl_file_file_type)
	with (Modify External Name = ""utl_file_put"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_put (utl_file_file_type) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_put (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_new_line (utl_file_file_type,integer default 1)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_new_line)"" language c;

",
	"f",
	"drop procedure utl_file_new_line (utl_file_file_type,integer);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_new_line (utl_file_file_type,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_new_line)"");

",
	"f",
	"alter procedure utl_file_new_line (utl_file_file_type,integer)
	with (Modify External Name = ""utl_file_new_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%",
	6, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_new_line (utl_file_file_type,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%",
	6, "utl_file_new_line (utl_file_file_type,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_put_line (utl_file_file_type)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_put_line)"" language c;

",
	"f",
	"drop procedure utl_file_put_line (utl_file_file_type);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_put_line (utl_file_file_type)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_put_line)"");

",
	"f",
	"alter procedure utl_file_put_line (utl_file_file_type)
	with (Modify External Name = ""utl_file_put_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_put_line (utl_file_file_type) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_put_line (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar default NULL,lvarchar default NULL,lvarchar default NULL,lvarchar default NULL,lvarchar default NULL)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_putf)"" language c;

",
	"f",
	"drop procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_putf)"");

",
	"f",
	"alter procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)
	with (Modify External Name = ""utl_file_putf"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%",
	6, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 54, "Alter-HandleNul-utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)
	with (add handlesnulls);

",
	"f",
	"alter procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	54, "Alter-HandleNul-utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%",
	6, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%",
	6, "utl_file_putf (utl_file_file_type,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_fflush (utl_file_file_type)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fflush)"" language c;

",
	"f",
	"drop procedure utl_file_fflush (utl_file_file_type);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%",
	7, "utl_file_file_type",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_fflush (utl_file_file_type)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fflush)"");

",
	"f",
	"alter procedure utl_file_fflush (utl_file_file_type)
	with (Modify External Name = ""utl_file_fflush"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_fflush (utl_file_file_type) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%",
	6, "utl_file_fflush (utl_file_file_type)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "utl_file_fclose_all ()",
	"%SYSBLDUSER%", 0,
	"create procedure utl_file_fclose_all ()
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fclose_all)"" language c;

",
	"f",
	"drop procedure utl_file_fclose_all ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-utl_file_fclose_all ()",
	"%SYSBLDUSER%", 0,
	"alter procedure utl_file_fclose_all ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(utl_file_fclose_all)"");

",
	"f",
	"alter procedure utl_file_fclose_all ()
	with (Modify External Name = ""utl_file_fclose_all"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-utl_file_fclose_all ()",
	"%SYSBLDUSER%",
	6, "utl_file_fclose_all ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "utl_file_fclose_all ()",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure utl_file_fclose_all () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "utl_file_fclose_all ()",
	"%SYSBLDUSER%",
	6, "utl_file_fclose_all ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_enable (integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_enable (integer default 20000)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_enable)"" language c;

",
	"f",
	"drop procedure dbms_output_enable (integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_enable (integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_enable (integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_enable)"");

",
	"f",
	"alter procedure dbms_output_enable (integer)
	with (Modify External Name = ""dbms_output_enable"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_enable (integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_enable (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_enable (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_enable (integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_enable (integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_enable (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_disable ()",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_disable ()
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_disable)"" language c;

",
	"f",
	"drop procedure dbms_output_disable ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_disable ()",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_disable ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_disable)"");

",
	"f",
	"alter procedure dbms_output_disable ()
	with (Modify External Name = ""dbms_output_disable"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_disable ()",
	"%SYSBLDUSER%",
	6, "dbms_output_disable ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_disable ()",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_disable () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_disable ()",
	"%SYSBLDUSER%",
	6, "dbms_output_disable ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_put (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_put (lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_put)"" language c;

",
	"f",
	"drop procedure dbms_output_put (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_put (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_put (lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_put)"");

",
	"f",
	"alter procedure dbms_output_put (lvarchar)
	with (Modify External Name = ""dbms_output_put"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_put (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_output_put (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_put (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_put (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_put (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_output_put (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_put_line (lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_put_line)"" language c;

",
	"f",
	"drop procedure dbms_output_put_line (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_put_line (lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_put_line)"");

",
	"f",
	"alter procedure dbms_output_put_line (lvarchar)
	with (Modify External Name = ""dbms_output_put_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_put_line (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_output_put_line (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_new_line ()",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_new_line ()
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_new_line)"" language c;

",
	"f",
	"drop procedure dbms_output_new_line ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_new_line ()",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_new_line ()
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_new_line)"");

",
	"f",
	"alter procedure dbms_output_new_line ()
	with (Modify External Name = ""dbms_output_new_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_new_line ()",
	"%SYSBLDUSER%",
	6, "dbms_output_new_line ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_new_line ()",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_new_line () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_new_line ()",
	"%SYSBLDUSER%",
	6, "dbms_output_new_line ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_get_line (out lvarchar,out integer)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_get_line)"" language c;

",
	"f",
	"drop procedure dbms_output_get_line (lvarchar,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_get_line (lvarchar,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_get_line)"");

",
	"f",
	"alter procedure dbms_output_get_line (lvarchar,integer)
	with (Modify External Name = ""dbms_output_get_line"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_get_line (lvarchar,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_get_line (lvarchar,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_output_get_lines (out dbms_output_chararr,out integer)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_get_lines)"" language c;

",
	"f",
	"drop procedure dbms_output_get_lines (dbms_output_chararr,integer);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	6, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%",
	7, "dbms_output_chararr",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_output_get_lines (dbms_output_chararr,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_output_get_lines)"");

",
	"f",
	"alter procedure dbms_output_get_lines (dbms_output_chararr,integer)
	with (Modify External Name = ""dbms_output_get_lines"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_output_get_lines (dbms_output_chararr,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%",
	6, "dbms_output_get_lines (dbms_output_chararr,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_append (blob,blob)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append)"" language c;

",
	"f",
	"drop procedure dbms_lob_append (blob,blob);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_append (blob,blob)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append)"");

",
	"f",
	"alter procedure dbms_lob_append (blob,blob)
	with (Modify External Name = ""dbms_lob_append"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 54, "Alter-HandleNul-dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_append (blob,blob)
	with (add handlesnulls);

",
	"f",
	"alter procedure dbms_lob_append (blob,blob)
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	54, "Alter-HandleNul-dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_append (blob,blob) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (blob,blob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_append (clob,clob)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append)"" language c;

",
	"f",
	"drop procedure dbms_lob_append (clob,clob);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_append (clob,clob)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append)"");

",
	"f",
	"alter procedure dbms_lob_append (clob,clob)
	with (Modify External Name = ""dbms_lob_append"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_append (clob,clob) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (clob,clob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_getlength (blob)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_getlength (blob)
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_getlength)"" language c;

",
	"f",
	"drop function dbms_lob_getlength (blob);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_getlength (blob)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_getlength (blob)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_getlength)"");

",
	"f",
	"alter function dbms_lob_getlength (blob)
	with (Modify External Name = ""dbms_lob_getlength"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_getlength (blob)",
	"%SYSBLDUSER%",
	5, "dbms_lob_getlength (blob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_getlength (blob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_getlength (blob) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_getlength (blob)",
	"%SYSBLDUSER%",
	5, "dbms_lob_getlength (blob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_getlength (clob)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_getlength (clob)
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_getlength)"" language c;

",
	"f",
	"drop function dbms_lob_getlength (clob);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_getlength (clob)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_getlength (clob)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_getlength)"");

",
	"f",
	"alter function dbms_lob_getlength (clob)
	with (Modify External Name = ""dbms_lob_getlength"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_getlength (clob)",
	"%SYSBLDUSER%",
	5, "dbms_lob_getlength (clob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_getlength (clob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_getlength (clob) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_getlength (clob)",
	"%SYSBLDUSER%",
	5, "dbms_lob_getlength (clob)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_compare (blob,blob,integer default 2147483647,integer default 1,integer default 1)
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_compare)"" language c;

",
	"f",
	"drop function dbms_lob_compare (blob,blob,integer,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_compare (blob,blob,integer,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_compare)"");

",
	"f",
	"alter function dbms_lob_compare (blob,blob,integer,integer,integer)
	with (Modify External Name = ""dbms_lob_compare"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_compare (blob,blob,integer,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_compare (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_copy (blob,blob,integer,integer default 1,integer default 1)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_copy)"" language c;

",
	"f",
	"drop procedure dbms_lob_copy (blob,blob,integer,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_copy (blob,blob,integer,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_copy)"");

",
	"f",
	"alter procedure dbms_lob_copy (blob,blob,integer,integer,integer)
	with (Modify External Name = ""dbms_lob_copy"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 54, "Alter-HandleNul-dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_copy (blob,blob,integer,integer,integer)
	with (add handlesnulls);

",
	"f",
	"alter procedure dbms_lob_copy (blob,blob,integer,integer,integer)
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	54, "Alter-HandleNul-dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_copy (blob,blob,integer,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (blob,blob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_copy (clob,clob,integer,integer default 1,integer default 1)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_copy)"" language c;

",
	"f",
	"drop procedure dbms_lob_copy (clob,clob,integer,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_copy (clob,clob,integer,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_copy)"");

",
	"f",
	"alter procedure dbms_lob_copy (clob,clob,integer,integer,integer)
	with (Modify External Name = ""dbms_lob_copy"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 54, "Alter-HandleNul-dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_copy (clob,clob,integer,integer,integer)
	with (add handlesnulls);

",
	"f",
	"alter procedure dbms_lob_copy (clob,clob,integer,integer,integer)
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	54, "Alter-HandleNul-dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_copy (clob,clob,integer,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_copy (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_erase (blob,integer,integer default 1)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_blob_erase)"" language c;

",
	"f",
	"drop procedure dbms_lob_erase (blob,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_erase (blob,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_blob_erase)"");

",
	"f",
	"alter procedure dbms_lob_erase (blob,integer,integer)
	with (Modify External Name = ""dbms_blob_erase"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_erase (blob,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_erase (blob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_erase (clob,integer,integer default 1)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_clob_erase)"" language c;

",
	"f",
	"drop procedure dbms_lob_erase (clob,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_erase (clob,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_clob_erase)"");

",
	"f",
	"alter procedure dbms_lob_erase (clob,integer,integer)
	with (Modify External Name = ""dbms_clob_erase"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_erase (clob,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_erase (clob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_substr (clob,integer default 32767,integer default 1)
returns lvarchar
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_substr)"" language c;

",
	"f",
	"drop function dbms_lob_substr (clob,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_substr (clob,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_substr)"");

",
	"f",
	"alter function dbms_lob_substr (clob,integer,integer)
	with (Modify External Name = ""dbms_lob_substr"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_substr (clob,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_substr (clob,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_instr (clob,lvarchar,integer default 1,integer default 1)
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_instr)"" language c;

",
	"f",
	"drop function dbms_lob_instr (clob,lvarchar,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_instr (clob,lvarchar,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_instr)"");

",
	"f",
	"alter function dbms_lob_instr (clob,lvarchar,integer,integer)
	with (Modify External Name = ""dbms_lob_instr"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_instr (clob,lvarchar,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_instr (clob,lvarchar,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_read (clob,integer,integer,out lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_read)"" language c;

",
	"f",
	"drop procedure dbms_lob_read (clob,integer,integer,lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_read (clob,integer,integer,lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_read)"");

",
	"f",
	"alter procedure dbms_lob_read (clob,integer,integer,lvarchar)
	with (Modify External Name = ""dbms_lob_read"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_read (clob,integer,integer,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_read (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_trim (blob,integer)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_trim)"" language c;

",
	"f",
	"drop procedure dbms_lob_trim (blob,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_trim (blob,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_trim)"");

",
	"f",
	"alter procedure dbms_lob_trim (blob,integer)
	with (Modify External Name = ""dbms_lob_trim"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_trim (blob,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_trim (blob,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_trim (clob,integer)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_trim)"" language c;

",
	"f",
	"drop procedure dbms_lob_trim (clob,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_trim (clob,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_trim)"");

",
	"f",
	"alter procedure dbms_lob_trim (clob,integer)
	with (Modify External Name = ""dbms_lob_trim"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_trim (clob,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%",
	6, "dbms_lob_trim (clob,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_write (clob,integer,integer,lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_write)"" language c;

",
	"f",
	"drop procedure dbms_lob_write (clob,integer,integer,lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_write (clob,integer,integer,lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_write)"");

",
	"f",
	"alter procedure dbms_lob_write (clob,integer,integer,lvarchar)
	with (Modify External Name = ""dbms_lob_write"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_write (clob,integer,integer,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_write (clob,integer,integer,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_new_clob (lvarchar)
returns clob
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_new_clob)"" language c;

",
	"f",
	"drop function dbms_lob_new_clob (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_new_clob (lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_new_clob)"");

",
	"f",
	"alter function dbms_lob_new_clob (lvarchar)
	with (Modify External Name = ""dbms_lob_new_clob"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%",
	5, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 85, "Alter-Variant-dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_new_clob (lvarchar)
	with (add not variant);

",
	"f",
	"alter function dbms_lob_new_clob (lvarchar)
	with (drop not variant);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	85, "Alter-Variant-dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%",
	5, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_new_clob (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%",
	5, "dbms_lob_new_clob (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_lob_append (clob,lvarchar)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append_str)"" language c;

",
	"f",
	"drop procedure dbms_lob_append (clob,lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_append (clob,lvarchar)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_append_str)"");

",
	"f",
	"alter procedure dbms_lob_append (clob,lvarchar)
	with (Modify External Name = ""dbms_lob_append_str"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 86, "Alter-Variant-dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_lob_append (clob,lvarchar)
	with (add not variant);

",
	"f",
	"alter procedure dbms_lob_append (clob,lvarchar)
	with (drop not variant);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	86, "Alter-Variant-dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_lob_append (clob,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_lob_append (clob,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create function dbms_lob_compare (clob,clob,integer default 2147483647,integer default 1,integer default 1)
returns integer
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_compare)"" language c;

",
	"f",
	"drop function dbms_lob_compare (clob,clob,integer,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_lob_compare (clob,clob,integer,integer,integer)
	with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/excompat.bld(dbms_lob_compare)"");

",
	"f",
	"alter function dbms_lob_compare (clob,clob,integer,integer,integer)
	with (Modify External Name = ""dbms_lob_compare"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_lob_compare (clob,clob,integer,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%",
	5, "dbms_lob_compare (clob,clob,integer,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_register (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_register (name lvarchar)
  define evid integer;

  let evid = DBMS_ALERT_GET_EVENT_ID(name);
  insert into DBMS_ALERT_REGISTERED values (DBINFO('sessionid'), evid);

end procedure;

",
	"f",
	"drop procedure dbms_alert_register (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_register (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_register (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_register (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_alert_register (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_alert_get_event_id (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create function dbms_alert_get_event_id (name lvarchar)
returns integer
  define evid integer;

  select event_id into evid from DBMS_ALERT_EVENTS
    where name = event_name;
  if evid IS NULL then
    insert into DBMS_ALERT_EVENTS(event_name) values (name);
    let evid = DBINFO('sqlca.sqlerrd1');
  end if;

  return evid;

end function;

",
	"f",
	"drop function dbms_alert_get_event_id (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_alert_get_event_id (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_alert_get_event_id (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_alert_get_event_id (lvarchar)",
	"%SYSBLDUSER%",
	5, "dbms_alert_get_event_id (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_remove (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_remove (name lvarchar)
  define evid integer;
  define sesid integer;

  let evid = DBMS_ALERT_GET_EVENT_ID(name);
  let sesid = DBINFO('sessionid');
  delete from DBMS_ALERT_REGISTERED where
    (session_id = sesid AND event_id = evid);
  delete from DBMS_ALERT_SIGNALED where
    (session_id = sesid AND event_id = evid);

end procedure;

",
	"f",
	"drop procedure dbms_alert_remove (lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_remove (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_remove (lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_remove (lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_alert_remove (lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_removeall ()",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_removeall ()
  define sesid integer;

  let sesid = DBINFO('sessionid');
  delete from DBMS_ALERT_REGISTERED where
    (session_id = sesid);
  delete from DBMS_ALERT_SIGNALED where
    (session_id = sesid);

end procedure;

",
	"f",
	"drop procedure dbms_alert_removeall ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_removeall ()",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_removeall () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_removeall ()",
	"%SYSBLDUSER%",
	6, "dbms_alert_removeall ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_set_defaults (integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_set_defaults (sensitivity integer)
  define global poll_interval INTEGER DEFAULT 1;
  let poll_interval = sensitivity;

end procedure;

",
	"f",
	"drop procedure dbms_alert_set_defaults (integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_set_defaults (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_set_defaults (integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_set_defaults (integer)",
	"%SYSBLDUSER%",
	6, "dbms_alert_set_defaults (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_alert_get_defaults ()",
	"%SYSBLDUSER%", 0,
	"create function dbms_alert_get_defaults ()
returns integer
  define global poll_interval INTEGER DEFAULT 1;
  return poll_interval;

end function;

",
	"f",
	"drop function dbms_alert_get_defaults ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_alert_get_defaults ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_alert_get_defaults () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_alert_get_defaults ()",
	"%SYSBLDUSER%",
	5, "dbms_alert_get_defaults ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_signal (lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_signal (name lvarchar,message lvarchar)
  define evid integer;
  define cnt integer;
  define signal_time DATETIME year to second;

  let evid = DBMS_ALERT_GET_EVENT_ID(name);
  if evid IS NOT NULL THEN
    let signal_time = CURRENT;
    insert into DBMS_ALERT_SIGNALED
      select evid, session_id, signal_time, message
      from DBMS_ALERT_REGISTERED where (evid = event_id);
  end if;

end procedure;

",
	"f",
	"drop procedure dbms_alert_signal (lvarchar,lvarchar);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_signal (lvarchar,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_signal (lvarchar,lvarchar) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_signal (lvarchar,lvarchar)",
	"%SYSBLDUSER%",
	6, "dbms_alert_signal (lvarchar,lvarchar)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_waitone (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_waitone (name lvarchar,out message lvarchar,out status integer,timeout integer default 86400)
  define global poll_interval INTEGER DEFAULT 1;
  define evid integer;
  define sesid integer;
  define cnt integer;
  define sig_time DATETIME year to second;
  define yet integer;

  let sesid = DBINFO('sessionid');
  let evid = DBMS_ALERT_GET_EVENT_ID(name);
  let status = 2;
  if evid IS NOT NULL THEN
    let status = 1;
    let sesid = DBINFO('sessionid');
    let yet = timeout;
    LOOP
      select count(alert_msg),MAX(signal_time) into cnt,sig_time from DBMS_ALERT_SIGNALED
        where (evid = event_id AND sesid = session_id);
      if cnt > 0 then
        foreach sig_cursor for
        select alert_msg into message from DBMS_ALERT_SIGNALED
            where (evid = event_id AND sesid = session_id AND signal_time = sig_time)
        delete from DBMS_ALERT_SIGNALED
          where current of sig_cursor;
        end foreach;
        let status = 0;
        exit loop;
      elif yet > 0 then
        call DBMS_ALERT_WAIT(poll_interval);
        let yet = yet - poll_interval;
      else
        exit loop;
      end if;
    end loop;
  end if;

end procedure;

",
	"f",
	"drop procedure dbms_alert_waitone (lvarchar,lvarchar,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_waitone (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_waitone (lvarchar,lvarchar,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_waitone (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_alert_waitone (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_waitany (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_waitany (out name lvarchar,out message lvarchar,out status integer,timeout integer default 86400)
  define global poll_interval INTEGER DEFAULT 1;
  define evid integer;
  define sesid integer;
  define cnt integer;
  define sig_time DATETIME year to second;
  define yet integer;

  let sesid = DBINFO('sessionid');
  let name = NULL;

  let status = 1;
  let sesid = DBINFO('sessionid');
  let yet = timeout;
  LOOP
    select count(alert_msg),MAX(signal_time) into cnt,sig_time from DBMS_ALERT_SIGNALED
      where (sesid = session_id);
    if cnt > 0 then
      begin work;
      foreach sig_cursor for
      select alert_msg, event_id into message, evid
        from DBMS_ALERT_SIGNALED
          where (sesid = session_id AND signal_time = sig_time)
      delete from DBMS_ALERT_SIGNALED
        where current of sig_cursor;
      select event_name into name
        from DBMS_ALERT_EVENTS
        where evid = event_id;
      end foreach;
      commit work;
      let status = 0;
      exit loop;
    elif yet > 0 then
      call DBMS_ALERT_WAIT(poll_interval);
      let yet = yet - poll_interval;
    else
      exit loop;
    end if;
  end loop;

end procedure;

",
	"f",
	"drop procedure dbms_alert_waitany (lvarchar,lvarchar,integer,integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_waitany (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_waitany (lvarchar,lvarchar,integer,integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_waitany (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%",
	6, "dbms_alert_waitany (lvarchar,lvarchar,integer,integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_alert_wait (integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_alert_wait (integer default 1)
external name ""(mt_yield)"" language c;

",
	"f",
	"drop procedure dbms_alert_wait (integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 182, "Alter-ExternalName-dbms_alert_wait (integer)",
	"%SYSBLDUSER%", 0,
	"alter procedure dbms_alert_wait (integer)
	with (Modify External Name = ""(mt_yield)"");

",
	"f",
	"alter procedure dbms_alert_wait (integer)
	with (Modify External Name = ""mt_yield"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	182, "Alter-ExternalName-dbms_alert_wait (integer)",
	"%SYSBLDUSER%",
	6, "dbms_alert_wait (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_alert_wait (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_alert_wait (integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_alert_wait (integer)",
	"%SYSBLDUSER%",
	6, "dbms_alert_wait (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_random_initialize (integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_random_initialize (seed integer)
  define global XI bigint default 0;
  let XI = seed * 4294967296;

end procedure;

",
	"f",
	"drop procedure dbms_random_initialize (integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_random_initialize (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_random_initialize (integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_random_initialize (integer)",
	"%SYSBLDUSER%",
	6, "dbms_random_initialize (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_random_seed (integer)",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_random_seed (seed integer)
  define global XI bigint default 0;
  let XI = seed * 4294967296;

end procedure;

",
	"f",
	"drop procedure dbms_random_seed (integer);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_random_seed (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_random_seed (integer) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_random_seed (integer)",
	"%SYSBLDUSER%",
	6, "dbms_random_seed (integer)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_random_random ()",
	"%SYSBLDUSER%", 0,
	"create function dbms_random_random ()
returns integer
  define global XI bigint default 0;
  if XI = 0 then
    let XI = 8589934592;
  end if;
  return dbms_random_jrand48(XI);

end function;

",
	"f",
	"drop function dbms_random_random ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_random_random ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_random_random () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_random_random ()",
	"%SYSBLDUSER%",
	5, "dbms_random_random ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 6, "dbms_random_terminate ()",
	"%SYSBLDUSER%", 0,
	"create procedure dbms_random_terminate ()
  define global XI bigint default 0;
  let XI = 0;


end procedure;

",
	"f",
	"drop procedure dbms_random_terminate ();

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 70, "dbms_random_terminate ()",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure dbms_random_terminate () to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	70, "dbms_random_terminate ()",
	"%SYSBLDUSER%",
	6, "dbms_random_terminate ()",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 5, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%", 0,
	"create function dbms_random_jrand48 (inout bigint)
returns integer
external name ""(jrand48)"" language c;

",
	"f",
	"drop function dbms_random_jrand48 (bigint);

",
	"f"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 181, "Alter-ExternalName-dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_random_jrand48 (bigint)
	with (Modify External Name = ""(jrand48)"");

",
	"f",
	"alter function dbms_random_jrand48 (bigint)
	with (Modify External Name = ""jrand48"");

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	181, "Alter-ExternalName-dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%",
	5, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 55, "Alter-HandleNul-dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%", 0,
	"alter function dbms_random_jrand48 (bigint)
	with (add handlesnulls);

",
	"f",
	"alter function dbms_random_jrand48 (bigint)
	with (drop handlesnulls);

",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	55, "Alter-HandleNul-dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%",
	5, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 69, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%", 0,
	"grant execute on function dbms_random_jrand48 (bigint) to public;

",
	"f",
	"",
	"f"
);

insert into sysbldobjdepends
(
	bld_id,
	obj_kind,
	obj_signature,
	obj_owner,
	need_obj_kind,
	need_obj_signature,
	need_obj_owner)
	values
(
	"%SYSBLDNAME%",
	69, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%",
	5, "dbms_random_jrand48 (bigint)",
	"%SYSBLDUSER%"
);

insert into sysbldobjects
	(bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
	    create_can_fail, drop_sql, drop_can_fail)
values
(
	"%SYSBLDNAME%", 0, "sysbldregistered",
	"%SYSBLDUSER%", 0,
	"insert into sysbldregistered
	(bld_id)
values
(
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldregistered
	where bld_id = ""%SYSBLDNAME%"";

",
	"f"
);