analytics/informix/extend/TSPIndex.1.00.FC1/objects.sql

-- Generated by BladeSmith 3.60.TC2  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, "opclass",
	"%SYSBLDUSER%", 0,
	"create opclass MBRShape_ops for rtree
strategies (Overlap, Equal, Contains, Within)
support (Union, Size, Inter, SFCbits, ObjectLength, SFCvalue, SetUnion);
",
	"f",
	"drop opclass MBRShape_ops 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%", 0, "traceclass",
	"%SYSBLDUSER%", 0,
	"insert into systraceclasses (name) values ('mbr');
",
	"f",
	"delete from systraceclasses where name = 'mbr';
",
	"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, "MBRPoint",
	"%SYSBLDUSER%", 0,
	"create opaque type MBRPoint(
	internallength = variable,
	maxlen = 512,
	alignment = 8
);

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

",
	"f",
	"drop function MBRPointIn (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, "MBRPointIn (lvarchar)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointIn (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointIn (lvarchar)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointIn (lvarchar)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRPoint",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointOut (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointOut (MBRPoint)
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRPointOut (MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPointOut (MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointOut (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointOut (MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointOut (MBRPoint)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRPoint 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, "MBRPoint->lvarchar",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointSend (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointSend (MBRPoint)
returns sendrecv
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSend)""
language c;

",
	"f",
	"drop function MBRPointSend (MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPointSend (MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointSend (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointSend (MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointSend (MBRPoint)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRPoint 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, "MBRPoint->sendrecv",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointRecv (sendrecv)
returns MBRPoint
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRPointRecv)""
language c;

",
	"f",
	"drop function MBRPointRecv (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, "MBRPointRecv (sendrecv)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointRecv (sendrecv)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointRecv (sendrecv)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRPoint",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointImpT (impexp)
returns MBRPoint
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRPointIn)""
language c;

",
	"f",
	"drop function MBRPointImpT (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, "MBRPointImpT (impexp)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointImpT (impexp)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointImpT (impexp)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRPoint",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointExpT (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointExpT (MBRPoint)
returns impexp
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRPointExpT (MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPointExpT (MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointExpT (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointExpT (MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointExpT (MBRPoint)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRPoint 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, "MBRPoint->impexp",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRPointImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"create function MBRPointImpB (impexpbin)
returns MBRPoint
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRPointRecv)""
language c;

",
	"f",
	"drop function MBRPointImpB (impexpbin);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPointImpB (impexpbin)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointImpB (impexpbin)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointImpB (impexpbin)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (impexpbin as MBRPoint);

",
	"f"
);

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

",
	"f",
	"drop function MBRPointExpB (MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPointExpB (MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPointExpB (MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPointExpB (MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function MBRPointExpB (MBRPoint)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRPoint as impexpbin);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRPoint->impexpbin",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "MBRBox",
	"%SYSBLDUSER%", 0,
	"create opaque type MBRBox(
	internallength = variable,
	maxlen = 512,
	alignment = 8
);

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

",
	"f",
	"drop function MBRBoxIn (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, "MBRBoxIn (lvarchar)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxIn (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxIn (lvarchar)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxIn (lvarchar)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRBox",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxOut (MBRBox)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxOut (MBRBox)
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRBoxOut (MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBoxOut (MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxOut (MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxOut (MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxOut (MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRBox 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, "MBRBox->lvarchar",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxSend (MBRBox)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxSend (MBRBox)
returns sendrecv
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSend)""
language c;

",
	"f",
	"drop function MBRBoxSend (MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBoxSend (MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxSend (MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxSend (MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxSend (MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRBox 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, "MBRBox->sendrecv",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxRecv (sendrecv)
returns MBRBox
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRBoxRecv)""
language c;

",
	"f",
	"drop function MBRBoxRecv (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, "MBRBoxRecv (sendrecv)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxRecv (sendrecv)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxRecv (sendrecv)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRBox",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxImpT (impexp)
returns MBRBox
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRBoxIn)""
language c;

",
	"f",
	"drop function MBRBoxImpT (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, "MBRBoxImpT (impexp)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxImpT (impexp)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxImpT (impexp)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRBox",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxExpT (MBRBox)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxExpT (MBRBox)
returns impexp
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRBoxExpT (MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBoxExpT (MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxExpT (MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxExpT (MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxExpT (MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRBox 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, "MBRBox->impexp",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRBoxImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"create function MBRBoxImpB (impexpbin)
returns MBRBox
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRBoxRecv)""
language c;

",
	"f",
	"drop function MBRBoxImpB (impexpbin);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBoxImpB (impexpbin)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxImpB (impexpbin)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxImpB (impexpbin)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (impexpbin as MBRBox);

",
	"f"
);

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

",
	"f",
	"drop function MBRBoxExpB (MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBoxExpB (MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBoxExpB (MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBoxExpB (MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function MBRBoxExpB (MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRBox as impexpbin);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRBox->impexpbin",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRShape",
	"%SYSBLDUSER%", 0,
	"create opaque type MBRShape(
	internallength = variable,
	maxlen = 512,
	alignment = 8
);

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

",
	"f",
	"drop function MBRShapeIn (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, "MBRShapeIn (lvarchar)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeIn (lvarchar)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeIn (lvarchar)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeIn (lvarchar)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeOut (MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeOut (MBRShape)
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRShapeOut (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRShapeOut (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeOut (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeOut (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeOut (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRShape 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, "MBRShape->lvarchar",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeSend (MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeSend (MBRShape)
returns sendrecv
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSend)""
language c;

",
	"f",
	"drop function MBRShapeSend (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRShapeSend (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeSend (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeSend (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeSend (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRShape 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, "MBRShape->sendrecv",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeRecv (sendrecv)
returns MBRShape
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeRecv)""
language c;

",
	"f",
	"drop function MBRShapeRecv (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, "MBRShapeRecv (sendrecv)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeRecv (sendrecv)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeRecv (sendrecv)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeRecv (sendrecv)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeImpT (impexp)
returns MBRShape
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeIn)""
language c;

",
	"f",
	"drop function MBRShapeImpT (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, "MBRShapeImpT (impexp)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeImpT (impexp)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeImpT (impexp)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeImpT (impexp)
	with (drop parallelizable);

",
	"f"
);

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

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

",
	"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->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeExpT (MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeExpT (MBRShape)
returns impexp
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeOut)""
language c;

",
	"f",
	"drop function MBRShapeExpT (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRShapeExpT (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeExpT (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeExpT (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeExpT (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRShape 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, "MBRShape->impexp",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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, "MBRShapeImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"create function MBRShapeImpB (impexpbin)
returns MBRShape
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeRecv)""
language c;

",
	"f",
	"drop function MBRShapeImpB (impexpbin);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRShapeImpB (impexpbin)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeImpB (impexpbin)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeImpB (impexpbin)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeImpB (impexpbin)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (impexpbin as MBRShape);

",
	"f"
);

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

",
	"f",
	"drop function MBRShapeExpB (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRShapeExpB (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "MBRShapeExpB (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRShapeExpB (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRShapeExpB (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRShape as impexpbin);

",
	"f"
);

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

",
	"f",
	"drop function Compare (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Compare (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Compare (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Compare (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Compare (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Equal (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Equal (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Equal (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Equal (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Equal (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function NotEqual (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "NotEqual (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "NotEqual (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function NotEqual (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function NotEqual (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Union (MBRShape,MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Union (MBRShape,MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Union (MBRShape,MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Union (MBRShape,MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Union (MBRShape,MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Union (MBRBox,MBRBox,MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Union (MBRBox,MBRBox,MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "Union (MBRBox,MBRBox,MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function Union (MBRBox,MBRBox,MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function Union (MBRBox,MBRBox,MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Union (MBRPoint,MBRPoint,MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function Union (MBRPoint,MBRPoint,MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function Union (MBRPoint,MBRPoint,MBRPoint)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%",
	5, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%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, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Union (MBRPoint,MBRPoint,MBRPoint) 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, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%",
	5, "Union (MBRPoint,MBRPoint,MBRPoint)",
	"%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, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%", 0,
	"create function Size (MBRShape,double precision)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSize)""
language c;

",
	"f",
	"drop function Size (MBRShape,double precision);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%", 0,
	"alter function Size (MBRShape,double precision)
	with (add parallelizable);

",
	"f",
	"alter function Size (MBRShape,double precision)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%",
	5, "Size (MBRShape,double precision)",
	"%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, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Size (MBRShape,double precision) 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, "Size (MBRShape,double precision)",
	"%SYSBLDUSER%",
	5, "Size (MBRShape,double precision)",
	"%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, "Inter (MBRShape,MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function Inter (MBRShape,MBRShape,MBRShape)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeInter)""
language c;

",
	"f",
	"drop function Inter (MBRShape,MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Inter (MBRShape,MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Inter (MBRShape,MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Inter (MBRShape,MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Inter (MBRShape,MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Inter (MBRBox,MBRBox,MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Inter (MBRBox,MBRBox,MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "Inter (MBRBox,MBRBox,MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function Inter (MBRBox,MBRBox,MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function Inter (MBRBox,MBRBox,MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Inter (MBRPoint,MBRPoint,MBRPoint);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Inter (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "Inter (MBRPoint,MBRPoint,MBRPoint)",
	"%SYSBLDUSER%", 0,
	"alter function Inter (MBRPoint,MBRPoint,MBRPoint)
	with (add parallelizable);

",
	"f",
	"alter function Inter (MBRPoint,MBRPoint,MBRPoint)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function Overlap (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Overlap (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Overlap (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Overlap (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Overlap (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "Overlap (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Overlap (MBRShape,MBRShape)",
	"%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, "Overlap (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Overlap (MBRShape,MBRShape) 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, "Overlap (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Overlap (MBRShape,MBRShape)",
	"%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, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function Contains (MBRShape,MBRShape)
returns boolean
with
(
	commutator = Within,
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeContains)""
language c;

",
	"f",
	"drop function Contains (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Contains (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Contains (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Contains (MBRShape,MBRShape)",
	"%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, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Contains (MBRShape,MBRShape) 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, "Contains (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Contains (MBRShape,MBRShape)",
	"%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, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function Within (MBRShape,MBRShape)
returns boolean
with
(
	commutator = Contains,
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeWithin)""
language c;

",
	"f",
	"drop function Within (MBRShape,MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Within (MBRShape,MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Within (MBRShape,MBRShape)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Within (MBRShape,MBRShape)",
	"%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, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%", 0,
	"grant execute on function Within (MBRShape,MBRShape) 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, "Within (MBRShape,MBRShape)",
	"%SYSBLDUSER%",
	5, "Within (MBRShape,MBRShape)",
	"%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, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"create function SFCbits (MBRShape,pointer)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSFCbits)""
language c;

",
	"f",
	"drop function SFCbits (MBRShape,pointer);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"alter function SFCbits (MBRShape,pointer)
	with (add parallelizable);

",
	"f",
	"alter function SFCbits (MBRShape,pointer)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%",
	5, "SFCbits (MBRShape,pointer)",
	"%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, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function SFCbits (MBRShape,pointer) 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, "SFCbits (MBRShape,pointer)",
	"%SYSBLDUSER%",
	5, "SFCbits (MBRShape,pointer)",
	"%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, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"create function ObjectLength (MBRShape,pointer)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeObjectLength)""
language c;

",
	"f",
	"drop function ObjectLength (MBRShape,pointer);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"alter function ObjectLength (MBRShape,pointer)
	with (add parallelizable);

",
	"f",
	"alter function ObjectLength (MBRShape,pointer)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%",
	5, "ObjectLength (MBRShape,pointer)",
	"%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, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function ObjectLength (MBRShape,pointer) 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, "ObjectLength (MBRShape,pointer)",
	"%SYSBLDUSER%",
	5, "ObjectLength (MBRShape,pointer)",
	"%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, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"create function SFCvalue (MBRShape,integer,pointer)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSFCvalue)""
language c;

",
	"f",
	"drop function SFCvalue (MBRShape,integer,pointer);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"alter function SFCvalue (MBRShape,integer,pointer)
	with (add parallelizable);

",
	"f",
	"alter function SFCvalue (MBRShape,integer,pointer)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	5, "SFCvalue (MBRShape,integer,pointer)",
	"%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, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function SFCvalue (MBRShape,integer,pointer) 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, "SFCvalue (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	5, "SFCvalue (MBRShape,integer,pointer)",
	"%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, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"create function SetUnion (MBRShape,integer,pointer)
returns integer
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeSetUnion)""
language c;

",
	"f",
	"drop function SetUnion (MBRShape,integer,pointer);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"alter function SetUnion (MBRShape,integer,pointer)
	with (add parallelizable);

",
	"f",
	"alter function SetUnion (MBRShape,integer,pointer)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	5, "SetUnion (MBRShape,integer,pointer)",
	"%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, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function SetUnion (MBRShape,integer,pointer) 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, "SetUnion (MBRShape,integer,pointer)",
	"%SYSBLDUSER%",
	5, "SetUnion (MBRShape,integer,pointer)",
	"%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, "Area (MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function Area (MBRShape)
returns double precision
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRShapeArea)""
language c;

",
	"f",
	"drop function Area (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Area (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "Area (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function Area (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function Area (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function IsBox (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "IsBox (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "IsBox (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function IsBox (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function IsBox (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function IsPoint (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "IsPoint (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "IsPoint (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function IsPoint (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function IsPoint (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function IsCircle (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "IsCircle (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "IsCircle (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function IsCircle (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function IsCircle (MBRShape)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "IsCircle (MBRShape)",
	"%SYSBLDUSER%",
	5, "IsCircle (MBRShape)",
	"%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, "IsCircle (MBRShape)",
	"%SYSBLDUSER%", 0,
	"grant execute on function IsCircle (MBRShape) 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, "IsCircle (MBRShape)",
	"%SYSBLDUSER%",
	5, "IsCircle (MBRShape)",
	"%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, "MBRPoint (double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%", 0,
	"create function MBRPoint (double precision,double precision,double precision,double precision)
returns MBRPoint
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRPointFromValues)""
language c;

",
	"f",
	"drop function MBRPoint (double precision,double precision,double precision,double precision);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPoint (double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPoint (double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPoint (double precision,double precision,double precision,double precision)
	with (add parallelizable);

",
	"f",
	"alter function MBRPoint (double precision,double precision,double precision,double precision)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
	with (add parallelizable);

",
	"f",
	"alter function MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%",
	5, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%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, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%", 0,
	"grant execute on function MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision) 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, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%SYSBLDUSER%",
	5, "MBRBox (double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)",
	"%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, "MBRPoint (MBRShape)",
	"%SYSBLDUSER%", 0,
	"create function MBRPoint (MBRShape)
returns MBRPoint
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRPointFromShape)""
language c;

",
	"f",
	"drop function MBRPoint (MBRShape);

",
	"f"
);

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

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRPoint (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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%", 37, "MBRPoint (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRPoint (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRPoint (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function MBRBox (MBRShape);

",
	"f"
);

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

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "MBRBox (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "MBRBox (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function MBRBox (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function MBRBox (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function ShapeType (MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "ShapeType (MBRShape)",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%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%", 37, "ShapeType (MBRShape)",
	"%SYSBLDUSER%", 0,
	"alter function ShapeType (MBRShape)
	with (add parallelizable);

",
	"f",
	"alter function ShapeType (MBRShape)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop function ShapeTrace (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%", 69, "ShapeTrace (integer)",
	"%SYSBLDUSER%", 0,
	"grant execute on function ShapeTrace (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, "ShapeTrace (integer)",
	"%SYSBLDUSER%",
	5, "ShapeTrace (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, "ShapeRelease ()",
	"%SYSBLDUSER%", 0,
	"create function ShapeRelease ()
returns lvarchar
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(ShapeRelease)""
language c;

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

",
	"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%", 37, "ShapeRelease ()",
	"%SYSBLDUSER%", 0,
	"alter function ShapeRelease ()
	with (add parallelizable);

",
	"f",
	"alter function ShapeRelease ()
	with (drop parallelizable);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	37, "ShapeRelease ()",
	"%SYSBLDUSER%",
	5, "ShapeRelease ()",
	"%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, "ShapeRelease ()",
	"%SYSBLDUSER%", 0,
	"grant execute on function ShapeRelease () 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, "ShapeRelease ()",
	"%SYSBLDUSER%",
	5, "ShapeRelease ()",
	"%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, "Perimeter (MBRBox)",
	"%SYSBLDUSER%", 0,
	"create function Perimeter (MBRBox)
returns double precision
with
(
	not variant
)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(MBRBoxPerimeter)""
language c;

",
	"f",
	"drop function Perimeter (MBRBox);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	5, "Perimeter (MBRBox)",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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%", 37, "Perimeter (MBRBox)",
	"%SYSBLDUSER%", 0,
	"alter function Perimeter (MBRBox)
	with (add parallelizable);

",
	"f",
	"alter function Perimeter (MBRBox)
	with (drop parallelizable);

",
	"f"
);

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

",
	"f",
	"drop cast (MBRBox as MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRBox->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%SYSBLDUSER%"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRBox->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRBox",
	"%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, "MBRPoint->MBRShape",
	"%SYSBLDUSER%", 0,
	"create implicit cast 
(
	MBRPoint as MBRShape
);

",
	"f",
	"drop cast (MBRPoint as MBRShape);

",
	"f"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRPoint->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRShape",
	"%SYSBLDUSER%"
);

insert into sysbldobjdepends
	(bld_id, obj_kind, obj_signature, obj_owner,
	    need_obj_kind, need_obj_signature, need_obj_owner)
values
(
	"%SYSBLDNAME%",
	3, "MBRPoint->MBRShape",
	"%SYSBLDUSER%",
	7, "MBRPoint",
	"%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, "ifxrltree1",
	"%SYSBLDUSER%", 0,
	"insert into sysbldirequired
	(bldi_id, bld_id)
values
(
	""ifxrltree1"",
	""%SYSBLDNAME%""
);

",
	"f",
	"delete from sysbldirequired
	where bldi_id = ""ifxrltree1""
	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"
);

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, "TSPIndexRelease ()",
        "%SYSBLDUSER%", 0,
        "create function TSPIndexRelease ()
returns lvarchar with (not variant, handlesnulls)
external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/TSPIndex.bld(TSPIndexRelease)"" language c;

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

",
        "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, "TSPIndexRelease ()",
        "%SYSBLDUSER%", 0,
        "grant execute on function TSPIndexRelease () 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, "TSPIndexRelease ()",
        "%SYSBLDUSER%",
        5, "TSPIndexRelease ()",
        "%SYSBLDUSER%"
);