analytics/informix/extend/LLD.1.20.FC2/objects.sql

-- Generated by BladeSmith 3.50.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%", 7, "LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create opaque type LLD_Lob(
	internallength = 76,
	alignment = 8
);

",
	"f",
	"drop type LLD_Lob 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, "LLD_Lob",
	"%SYSBLDUSER%", 0,
	"grant usage on type LLD_Lob 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, "LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobIn (lvarchar)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobIn (lvarchar)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_input)""
language c;

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

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobIn (lvarchar)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobIn (lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobIn (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, "LLD_LobIn (lvarchar)",
	"%SYSBLDUSER%",
	5, "LLD_LobIn (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%", 3, "lvarchar->LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	lvarchar as LLD_Lob
	with  LLD_LobIn
);

",
	"f",
	"drop cast (lvarchar as LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "lvarchar->LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobOut (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobOut (LLD_Lob)
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_output)""
language c;

",
	"f",
	"drop function LLD_LobOut (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobOut (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobOut (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobOut (LLD_Lob) 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, "LLD_LobOut (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LLD_LobOut (LLD_Lob)",
	"%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%", 3, "LLD_Lob->lvarchar",
	"%SYSBLDUSER%", 0,
	"create cast 
(
	LLD_Lob as lvarchar
	with  LLD_LobOut
);

",
	"f",
	"drop cast (LLD_Lob as lvarchar);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "LLD_Lob->lvarchar",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobSend (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobSend (LLD_Lob)
returns sendrecv
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_send)""
language c;

",
	"f",
	"drop function LLD_LobSend (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobSend (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobSend (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobSend (LLD_Lob) 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, "LLD_LobSend (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LLD_LobSend (LLD_Lob)",
	"%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%", 3, "LLD_Lob->sendrecv",
	"%SYSBLDUSER%", 0,
	"create cast 
(
	LLD_Lob as sendrecv
	with  LLD_LobSend
);

",
	"f",
	"drop cast (LLD_Lob as sendrecv);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "LLD_Lob->sendrecv",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobRecv (sendrecv)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_recv)""
language c;

",
	"f",
	"drop function LLD_LobRecv (sendrecv);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobRecv (sendrecv)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobRecv (sendrecv) 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, "LLD_LobRecv (sendrecv)",
	"%SYSBLDUSER%",
	5, "LLD_LobRecv (sendrecv)",
	"%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%", 3, "sendrecv->LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	sendrecv as LLD_Lob
	with  LLD_LobRecv
);

",
	"f",
	"drop cast (sendrecv as LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "sendrecv->LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobImpT (impexp)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_import)""
language c;

",
	"f",
	"drop function LLD_LobImpT (impexp);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobImpT (impexp)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobImpT (impexp) 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, "LLD_LobImpT (impexp)",
	"%SYSBLDUSER%",
	5, "LLD_LobImpT (impexp)",
	"%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%", 3, "impexp->LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	impexp as LLD_Lob
	with  LLD_LobImpT
);

",
	"f",
	"drop cast (impexp as LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "impexp->LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobExpT (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobExpT (LLD_Lob)
returns impexp
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_export)""
language c;

",
	"f",
	"drop function LLD_LobExpT (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobExpT (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobExpT (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobExpT (LLD_Lob) 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, "LLD_LobExpT (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LLD_LobExpT (LLD_Lob)",
	"%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%", 3, "LLD_Lob->impexp",
	"%SYSBLDUSER%", 0,
	"create cast 
(
	LLD_Lob as impexp
	with  LLD_LobExpT
);

",
	"f",
	"drop cast (LLD_Lob as impexp);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "LLD_Lob->impexp",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "Assign (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function Assign (LLD_Lob)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_assign)""
language c;

",
	"f",
	"drop function Assign (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Assign (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "Assign (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Assign (LLD_Lob) 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, "Assign (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "Assign (LLD_Lob)",
	"%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, "Destroy (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create procedure Destroy (LLD_Lob)
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_destroy)""
language c;

",
	"f",
	"drop procedure Destroy (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	6, "Destroy (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "Destroy (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure Destroy (LLD_Lob) 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, "Destroy (LLD_Lob)",
	"%SYSBLDUSER%",
	6, "Destroy (LLD_Lob)",
	"%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, "LLD_Locator",
	"%SYSBLDUSER%", 0,
	"create row type LLD_Locator
(
	lo_protocol	char (18),
	lo_pointer	LLD_Lob,
	lo_location	lvarchar
);

",
	"f",
	"drop row type LLD_Locator restrict;

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	7, "LLD_Locator",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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%", 71, "LLD_Locator",
	"%SYSBLDUSER%", 0,
	"grant usage on type LLD_Locator 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, "LLD_Locator",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LOhandles (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LOhandles (LLD_Lob)
returns lolist
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_handles)""
language c;

",
	"f",
	"drop function LOhandles (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LOhandles (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LOhandles (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LOhandles (LLD_Lob) 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, "LOhandles (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LOhandles (LLD_Lob)",
	"%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, "LLD_Create (LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"create function LLD_Create (LLD_Locator)
returns LLD_Locator
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_create)""
language c;

",
	"f",
	"drop function LLD_Create (LLD_Locator);

",
	"f"
);

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

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_Create (LLD_Locator)",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LLD_Create (LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_Create (LLD_Locator) 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, "LLD_Create (LLD_Locator)",
	"%SYSBLDUSER%",
	5, "LLD_Create (LLD_Locator)",
	"%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, "LLD_Copy (LLD_Locator,LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"create function LLD_Copy (LLD_Locator,LLD_Locator)
returns LLD_Locator
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_copy)""
language c;

",
	"f",
	"drop function LLD_Copy (LLD_Locator,LLD_Locator);

",
	"f"
);

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

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_Copy (LLD_Locator,LLD_Locator)",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LLD_Copy (LLD_Locator,LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_Copy (LLD_Locator,LLD_Locator) 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, "LLD_Copy (LLD_Locator,LLD_Locator)",
	"%SYSBLDUSER%",
	5, "LLD_Copy (LLD_Locator,LLD_Locator)",
	"%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, "LLD_Delete (LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"create function LLD_Delete (LLD_Locator)
returns boolean
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_delete)""
language c;

",
	"f",
	"drop function LLD_Delete (LLD_Locator);

",
	"f"
);

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

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_Delete (LLD_Locator)",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LLD_Delete (LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_Delete (LLD_Locator) 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, "LLD_Delete (LLD_Locator)",
	"%SYSBLDUSER%",
	5, "LLD_Delete (LLD_Locator)",
	"%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, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"create function LLD_FromClient (lvarchar,LLD_Locator)
returns LLD_Locator
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_from_client)""
language c;

",
	"f",
	"drop function LLD_FromClient (lvarchar,LLD_Locator);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%SYSBLDUSER%"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_FromClient (lvarchar,LLD_Locator) 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, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%SYSBLDUSER%",
	5, "LLD_FromClient (lvarchar,LLD_Locator)",
	"%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, "LLD_ToClient (LLD_Locator,lvarchar)",
	"%SYSBLDUSER%", 0,
	"create function LLD_ToClient (LLD_Locator,lvarchar)
returns boolean
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_to_client)""
language c;

",
	"f",
	"drop function LLD_ToClient (LLD_Locator,lvarchar);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_ToClient (LLD_Locator,lvarchar)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%SYSBLDUSER%"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_ToClient (LLD_Locator,lvarchar)",
	"%SYSBLDUSER%",
	7, "LLD_Locator",
	"%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, "LLD_ToClient (LLD_Locator,lvarchar)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_ToClient (LLD_Locator,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, "LLD_ToClient (LLD_Locator,lvarchar)",
	"%SYSBLDUSER%",
	5, "LLD_ToClient (LLD_Locator,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, "LLD_FileToFile (lvarchar,lvarchar,boolean,boolean)",
	"%SYSBLDUSER%", 0,
	"create procedure LLD_FileToFile (lvarchar,lvarchar,boolean,boolean)
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_udr_file_to_file)""
language c;

",
	"f",
	"drop procedure LLD_FileToFile (lvarchar,lvarchar,boolean,boolean);

",
	"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, "LLD_FileToFile (lvarchar,lvarchar,boolean,boolean)",
	"%SYSBLDUSER%", 0,
	"grant execute on procedure LLD_FileToFile (lvarchar,lvarchar,boolean,boolean) 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, "LLD_FileToFile (lvarchar,lvarchar,boolean,boolean)",
	"%SYSBLDUSER%",
	6, "LLD_FileToFile (lvarchar,lvarchar,boolean,boolean)",
	"%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, "LoToFile (LLD_Lob,lvarchar,char)",
	"%SYSBLDUSER%", 0,
	"create function LoToFile (LLD_Lob,lvarchar,char (6))
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_to_file)""
language c;

",
	"f",
	"drop function LoToFile (LLD_Lob,lvarchar,char (6));

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LoToFile (LLD_Lob,lvarchar,char)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LoToFile (LLD_Lob,lvarchar,char)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LoToFile (LLD_Lob,lvarchar,char (6)) 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, "LoToFile (LLD_Lob,lvarchar,char)",
	"%SYSBLDUSER%",
	5, "LoToFile (LLD_Lob,lvarchar,char)",
	"%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, "LOCopy (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LOCopy (LLD_Lob)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_copy)""
language c;

",
	"f",
	"drop function LOCopy (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LOCopy (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LOCopy (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LOCopy (LLD_Lob) 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, "LOCopy (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LOCopy (LLD_Lob)",
	"%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, "LOCopy (LLD_Lob,char,char)",
	"%SYSBLDUSER%", 0,
	"create function LOCopy (LLD_Lob,char (18),char (18))
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_copy_colspec)""
language c;

",
	"f",
	"drop function LOCopy (LLD_Lob,char (18),char (18));

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LOCopy (LLD_Lob,char,char)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LOCopy (LLD_Lob,char,char)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LOCopy (LLD_Lob,char (18),char (18)) 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, "LOCopy (LLD_Lob,char,char)",
	"%SYSBLDUSER%",
	5, "LOCopy (LLD_Lob,char,char)",
	"%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, "LLD_LobType (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobType (LLD_Lob)
returns char (4)
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_type)""
language c;

",
	"f",
	"drop function LLD_LobType (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobType (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobType (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobType (LLD_Lob) 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, "LLD_LobType (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "LLD_LobType (LLD_Lob)",
	"%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, "LLD_LobCast (blob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobCast (blob)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_from_blob)""
language c;

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

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobCast (blob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobCast (blob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobCast (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, "LLD_LobCast (blob)",
	"%SYSBLDUSER%",
	5, "LLD_LobCast (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%", 3, "blob->LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	blob as LLD_Lob
	with  LLD_LobCast
);

",
	"f",
	"drop cast (blob as LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "blob->LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobCast (clob)",
	"%SYSBLDUSER%", 0,
	"create function LLD_LobCast (clob)
returns LLD_Lob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_from_clob)""
language c;

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

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "LLD_LobCast (clob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "LLD_LobCast (clob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function LLD_LobCast (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, "LLD_LobCast (clob)",
	"%SYSBLDUSER%",
	5, "LLD_LobCast (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%", 3, "clob->LLD_Lob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	clob as LLD_Lob
	with  LLD_LobCast
);

",
	"f",
	"drop cast (clob as LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "clob->LLD_Lob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "blobCast (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function blobCast (LLD_Lob)
returns blob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_to_blob)""
language c;

",
	"f",
	"drop function blobCast (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "blobCast (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "blobCast (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function blobCast (LLD_Lob) 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, "blobCast (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "blobCast (LLD_Lob)",
	"%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%", 3, "LLD_Lob->blob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	LLD_Lob as blob
	with  blobCast
);

",
	"f",
	"drop cast (LLD_Lob as blob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "LLD_Lob->blob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "clobCast (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"create function clobCast (LLD_Lob)
returns clob
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/LLD.bld(lld_lob_to_clob)""
language c;

",
	"f",
	"drop function clobCast (LLD_Lob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "clobCast (LLD_Lob)",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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, "clobCast (LLD_Lob)",
	"%SYSBLDUSER%", 0,
	"grant execute on function clobCast (LLD_Lob) 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, "clobCast (LLD_Lob)",
	"%SYSBLDUSER%",
	5, "clobCast (LLD_Lob)",
	"%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%", 3, "LLD_Lob->clob",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	LLD_Lob as clob
	with  clobCast
);

",
	"f",
	"drop cast (LLD_Lob as clob);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "LLD_Lob->clob",
	"%SYSBLDUSER%",
	7, "LLD_Lob",
	"%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%", 15, "ILLD1",
	"%SYSBLDUSER%", 0,
	"insert into sysbldiprovided
	(bldi_id, bld_id)
values
(
	""ILLD1"",
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldiprovided
	where bldi_id = ""ILLD1""
	and bld_id = ""%SYSBLDNAME%"";

",
	"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%", 15, "ILLD2",
	"%SYSBLDUSER%", 0,
	"insert into sysbldiprovided
	(bldi_id, bld_id)
values
(
	""ILLD2"",
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldiprovided
	where bldi_id = ""ILLD2""
	and bld_id = ""%SYSBLDNAME%"";

",
	"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%", 0, "sysbldregistered",
	"%SYSBLDUSER%", 0,
	"insert into sysbldregistered
	(bld_id)
values
(
	""%SYSBLDNAME%""
);

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

",
	"f"
);