-- Generated by BladeSmith 4.20.FC1 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%", 5, "bts_beginscan (pointer)", "%SYSBLDUSER%", 0, "create function bts_beginscan (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_beginscan)"" language c; ", "f", "drop function bts_beginscan (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_beginscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_beginscan (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_beginscan)""); ", "f", "alter function bts_beginscan (pointer) with (Modify External Name = ""bts_beginscan""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_beginscan (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%", 151, "Alter-Class-bts_beginscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_beginscan (pointer) with (add class=""bts""); ", "f", "alter function bts_beginscan (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_beginscan (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, "bts_beginscan (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_beginscan (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, "bts_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_beginscan (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, "bts_check (pointer,integer)", "%SYSBLDUSER%", 0, "create function bts_check (pointer,integer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_check)"" language c; ", "f", "drop function bts_check (pointer,integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_check (pointer,integer)", "%SYSBLDUSER%", 0, "alter function bts_check (pointer,integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_check)""); ", "f", "alter function bts_check (pointer,integer) with (Modify External Name = ""bts_check""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_check (pointer,integer)", "%SYSBLDUSER%", 5, "bts_check (pointer,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%", 151, "Alter-Class-bts_check (pointer,integer)", "%SYSBLDUSER%", 0, "alter function bts_check (pointer,integer) with (add class=""bts""); ", "f", "alter function bts_check (pointer,integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_check (pointer,integer)", "%SYSBLDUSER%", 5, "bts_check (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_check (pointer,integer)", "%SYSBLDUSER%", 0, "grant execute on function bts_check (pointer,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, "bts_check (pointer,integer)", "%SYSBLDUSER%", 5, "bts_check (pointer,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, "bts_close (pointer)", "%SYSBLDUSER%", 0, "create function bts_close (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_close)"" language c; ", "f", "drop function bts_close (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_close (pointer)", "%SYSBLDUSER%", 0, "alter function bts_close (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_close)""); ", "f", "alter function bts_close (pointer) with (Modify External Name = ""bts_close""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_close (pointer)", "%SYSBLDUSER%", 5, "bts_close (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%", 151, "Alter-Class-bts_close (pointer)", "%SYSBLDUSER%", 0, "alter function bts_close (pointer) with (add class=""bts""); ", "f", "alter function bts_close (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_close (pointer)", "%SYSBLDUSER%", 5, "bts_close (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, "bts_close (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_close (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, "bts_close (pointer)", "%SYSBLDUSER%", 5, "bts_close (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, "bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "create function bts_contains (blob,lvarchar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_blob)"" language c; ", "f", "drop function bts_contains (blob,lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_blob)""); ", "f", "alter function bts_contains (blob,lvarchar) with (Modify External Name = ""bts_contains_blob""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (blob,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%", 135, "Alter-PerCallCost-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar) with (add percall_cost=65535); ", "f", "alter function bts_contains (blob,lvarchar) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (blob,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%", 151, "Alter-Class-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar) with (add class=""bts""); ", "f", "alter function bts_contains (blob,lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (blob,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, "bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (blob,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, "bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "create function bts_contains (blob,lvarchar,out real) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_blob_score)"" language c; ", "f", "drop function bts_contains (blob,lvarchar,real); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar,real) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_blob_score)""); ", "f", "alter function bts_contains (blob,lvarchar,real) with (Modify External Name = ""bts_contains_blob_score""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar,real) with (add percall_cost=65535); ", "f", "alter function bts_contains (blob,lvarchar,real) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar,real) with (add class=""bts""); ", "f", "alter function bts_contains (blob,lvarchar,real) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (blob,lvarchar,real) 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, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "create function bts_contains (clob,lvarchar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_clob)"" language c; ", "f", "drop function bts_contains (clob,lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_clob)""); ", "f", "alter function bts_contains (clob,lvarchar) with (Modify External Name = ""bts_contains_clob""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar) with (add percall_cost=65535); ", "f", "alter function bts_contains (clob,lvarchar) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar) with (add class=""bts""); ", "f", "alter function bts_contains (clob,lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (clob,lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "create function bts_contains (clob,lvarchar,out real) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_clob_score)"" language c; ", "f", "drop function bts_contains (clob,lvarchar,real); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar,real) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_clob_score)""); ", "f", "alter function bts_contains (clob,lvarchar,real) with (Modify External Name = ""bts_contains_clob_score""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar,real) with (add percall_cost=65535); ", "f", "alter function bts_contains (clob,lvarchar,real) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar,real) with (add class=""bts""); ", "f", "alter function bts_contains (clob,lvarchar,real) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (clob,lvarchar,real) 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, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "create function bts_contains (lvarchar,lvarchar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_lvarchar)"" language c; ", "f", "drop function bts_contains (lvarchar,lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_lvarchar)""); ", "f", "alter function bts_contains (lvarchar,lvarchar) with (Modify External Name = ""bts_contains_lvarchar""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar) with (add percall_cost=65535); ", "f", "alter function bts_contains (lvarchar,lvarchar) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar) with (add class=""bts""); ", "f", "alter function bts_contains (lvarchar,lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (lvarchar,lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "create function bts_contains (lvarchar,lvarchar,out real) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_lvarchar_score)"" language c; ", "f", "drop function bts_contains (lvarchar,lvarchar,real); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar,real) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_lvarchar_score)""); ", "f", "alter function bts_contains (lvarchar,lvarchar,real) with (Modify External Name = ""bts_contains_lvarchar_score""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar,real) with (add percall_cost=65535); ", "f", "alter function bts_contains (lvarchar,lvarchar,real) with (drop percall_cost); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar,real) with (add class=""bts""); ", "f", "alter function bts_contains (lvarchar,lvarchar,real) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "grant execute on function bts_contains (lvarchar,lvarchar,real) 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, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); 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, "bts_cost (pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_cost (pointer,pointer) returns real external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_cost)"" language c; ", "f", "drop function bts_cost (pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_cost (pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_cost)""); ", "f", "alter function bts_cost (pointer,pointer) with (Modify External Name = ""bts_cost""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_cost (pointer,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%", 85, "Alter-Variant-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_cost (pointer,pointer) with (add not variant); ", "f", "alter function bts_cost (pointer,pointer) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_cost (pointer,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%", 151, "Alter-Class-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_cost (pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_cost (pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_cost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_cost (pointer,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, "bts_cost (pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_cost (pointer,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, "bts_cost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_cost (pointer,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, "bts_create (pointer)", "%SYSBLDUSER%", 0, "create function bts_create (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_create)"" language c; ", "f", "drop function bts_create (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_create (pointer)", "%SYSBLDUSER%", 0, "alter function bts_create (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_create)""); ", "f", "alter function bts_create (pointer) with (Modify External Name = ""bts_create""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_create (pointer)", "%SYSBLDUSER%", 5, "bts_create (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%", 151, "Alter-Class-bts_create (pointer)", "%SYSBLDUSER%", 0, "alter function bts_create (pointer) with (add class=""bts""); ", "f", "alter function bts_create (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_create (pointer)", "%SYSBLDUSER%", 5, "bts_create (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, "bts_create (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_create (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, "bts_create (pointer)", "%SYSBLDUSER%", 5, "bts_create (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, "bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_delete (pointer,pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_delete)"" language c; ", "f", "drop function bts_delete (pointer,pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_delete (pointer,pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_delete)""); ", "f", "alter function bts_delete (pointer,pointer,pointer) with (Modify External Name = ""bts_delete""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_delete (pointer,pointer,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%", 151, "Alter-Class-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_delete (pointer,pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_delete (pointer,pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_delete (pointer,pointer,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, "bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_delete (pointer,pointer,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, "bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_delete (pointer,pointer,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, "bts_drop (pointer)", "%SYSBLDUSER%", 0, "create function bts_drop (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_drop)"" language c; ", "f", "drop function bts_drop (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_drop (pointer)", "%SYSBLDUSER%", 0, "alter function bts_drop (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_drop)""); ", "f", "alter function bts_drop (pointer) with (Modify External Name = ""bts_drop""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_drop (pointer)", "%SYSBLDUSER%", 5, "bts_drop (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%", 151, "Alter-Class-bts_drop (pointer)", "%SYSBLDUSER%", 0, "alter function bts_drop (pointer) with (add class=""bts""); ", "f", "alter function bts_drop (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_drop (pointer)", "%SYSBLDUSER%", 5, "bts_drop (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, "bts_drop (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_drop (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, "bts_drop (pointer)", "%SYSBLDUSER%", 5, "bts_drop (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, "bts_endscan (pointer)", "%SYSBLDUSER%", 0, "create function bts_endscan (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_endscan)"" language c; ", "f", "drop function bts_endscan (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_endscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_endscan (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_endscan)""); ", "f", "alter function bts_endscan (pointer) with (Modify External Name = ""bts_endscan""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_endscan (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%", 151, "Alter-Class-bts_endscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_endscan (pointer) with (add class=""bts""); ", "f", "alter function bts_endscan (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_endscan (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, "bts_endscan (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_endscan (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, "bts_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_endscan (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, "bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_getnext (pointer,pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_getnext)"" language c; ", "f", "drop function bts_getnext (pointer,pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_getnext (pointer,pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_getnext)""); ", "f", "alter function bts_getnext (pointer,pointer,pointer) with (Modify External Name = ""bts_getnext""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_getnext (pointer,pointer,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%", 151, "Alter-Class-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_getnext (pointer,pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_getnext (pointer,pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_getnext (pointer,pointer,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, "bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_getnext (pointer,pointer,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, "bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_getnext (pointer,pointer,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, "bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_insert (pointer,pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_insert)"" language c; ", "f", "drop function bts_insert (pointer,pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_insert (pointer,pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_insert)""); ", "f", "alter function bts_insert (pointer,pointer,pointer) with (Modify External Name = ""bts_insert""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_insert (pointer,pointer,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%", 151, "Alter-Class-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_insert (pointer,pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_insert (pointer,pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_insert (pointer,pointer,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, "bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_insert (pointer,pointer,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, "bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_insert (pointer,pointer,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, "bts_open (pointer)", "%SYSBLDUSER%", 0, "create function bts_open (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_open)"" language c; ", "f", "drop function bts_open (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_open (pointer)", "%SYSBLDUSER%", 0, "alter function bts_open (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_open)""); ", "f", "alter function bts_open (pointer) with (Modify External Name = ""bts_open""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_open (pointer)", "%SYSBLDUSER%", 5, "bts_open (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%", 151, "Alter-Class-bts_open (pointer)", "%SYSBLDUSER%", 0, "alter function bts_open (pointer) with (add class=""bts""); ", "f", "alter function bts_open (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_open (pointer)", "%SYSBLDUSER%", 5, "bts_open (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, "bts_open (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_open (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, "bts_open (pointer)", "%SYSBLDUSER%", 5, "bts_open (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, "bts_rescan (pointer)", "%SYSBLDUSER%", 0, "create function bts_rescan (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_rescan)"" language c; ", "f", "drop function bts_rescan (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_rescan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_rescan (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_rescan)""); ", "f", "alter function bts_rescan (pointer) with (Modify External Name = ""bts_rescan""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_rescan (pointer)", "%SYSBLDUSER%", 5, "bts_rescan (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%", 151, "Alter-Class-bts_rescan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_rescan (pointer) with (add class=""bts""); ", "f", "alter function bts_rescan (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_rescan (pointer)", "%SYSBLDUSER%", 5, "bts_rescan (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, "bts_rescan (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_rescan (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, "bts_rescan (pointer)", "%SYSBLDUSER%", 5, "bts_rescan (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, "bts_stats (pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_stats (pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_stats)"" language c; ", "f", "drop function bts_stats (pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_stats (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_stats (pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_stats)""); ", "f", "alter function bts_stats (pointer,pointer) with (Modify External Name = ""bts_stats""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_stats (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_stats (pointer,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%", 151, "Alter-Class-bts_stats (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_stats (pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_stats (pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_stats (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_stats (pointer,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, "bts_stats (pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_stats (pointer,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, "bts_stats (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_stats (pointer,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, "bts_truncate (pointer,integer)", "%SYSBLDUSER%", 0, "create function bts_truncate (pointer,integer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_truncate)"" language c; ", "f", "drop function bts_truncate (pointer,integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_truncate (pointer,integer)", "%SYSBLDUSER%", 0, "alter function bts_truncate (pointer,integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_truncate)""); ", "f", "alter function bts_truncate (pointer,integer) with (Modify External Name = ""bts_truncate""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_truncate (pointer,integer)", "%SYSBLDUSER%", 5, "bts_truncate (pointer,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%", 151, "Alter-Class-bts_truncate (pointer,integer)", "%SYSBLDUSER%", 0, "alter function bts_truncate (pointer,integer) with (add class=""bts""); ", "f", "alter function bts_truncate (pointer,integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_truncate (pointer,integer)", "%SYSBLDUSER%", 5, "bts_truncate (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_truncate (pointer,integer)", "%SYSBLDUSER%", 0, "grant execute on function bts_truncate (pointer,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, "bts_truncate (pointer,integer)", "%SYSBLDUSER%", 5, "bts_truncate (pointer,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, "bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_update (pointer,pointer,pointer,pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_update)"" language c; ", "f", "drop function bts_update (pointer,pointer,pointer,pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_update (pointer,pointer,pointer,pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_update)""); ", "f", "alter function bts_update (pointer,pointer,pointer,pointer,pointer) with (Modify External Name = ""bts_update""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_update (pointer,pointer,pointer,pointer,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%", 151, "Alter-Class-bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_update (pointer,pointer,pointer,pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_update (pointer,pointer,pointer,pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_update (pointer,pointer,pointer,pointer,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, "bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_update (pointer,pointer,pointer,pointer,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, "bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_update (pointer,pointer,pointer,pointer,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%", 0, "Access Method", "%SYSBLDUSER%", 0, "create secondary access_method bts ( am_create = bts_create, am_drop = bts_drop, am_open = bts_open, am_close = bts_close, am_insert = bts_insert, am_update = bts_update, am_delete = bts_delete, am_beginscan = bts_beginscan, am_endscan = bts_endscan, am_rescan = bts_rescan, am_getnext = bts_getnext, am_scancost = bts_cost, am_check = bts_check, am_stats = bts_stats, am_truncate = bts_truncate, am_sptype = 'A'); create opclass bts_char_ops for bts strategies ( bts_contains(char, lvarchar), bts_contains(char, lvarchar, real) ) support (noop); create opclass bts_varchar_ops for bts strategies ( bts_contains(varchar, lvarchar), bts_contains(varchar, lvarchar, real) ) support (noop); create opclass bts_nchar_ops for bts strategies ( bts_contains(nchar, lvarchar), bts_contains(nchar, lvarchar, real) ) support (noop); create opclass bts_nvarchar_ops for bts strategies ( bts_contains(nvarchar, lvarchar), bts_contains(nvarchar, lvarchar, real) ) support (noop); create opclass bts_lvarchar_ops for bts strategies ( bts_contains(lvarchar, lvarchar), bts_contains(lvarchar, lvarchar, real) ) support (noop); create opclass bts_clob_ops for bts strategies ( bts_contains(clob, lvarchar), bts_contains(clob, lvarchar, real) ) support (noop); create opclass bts_blob_ops for bts strategies ( bts_contains(blob, lvarchar), bts_contains(blob, lvarchar, real) ) support (noop); ", "f", "drop opclass bts_char_ops restrict; drop opclass bts_varchar_ops restrict; drop opclass bts_nchar_ops restrict; drop opclass bts_nvarchar_ops restrict; drop opclass bts_lvarchar_ops restrict; drop opclass bts_clob_ops restrict; drop opclass bts_blob_ops restrict; drop access_method bts restrict; ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_check (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_cost (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_rescan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_stats (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_truncate (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 5, "bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_check (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_check (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (blob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (blob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (blob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 130, "Alter-PerCallCost-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_cost (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_delete (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_insert (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_rescan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_rescan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_stats (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_stats (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_truncate (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_truncate (pointer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 80, "Alter-Variant-bts_update (pointer,pointer,pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "Access Method", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_update (pointer,pointer,pointer,pointer,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%", 0, "Trace", "%SYSBLDUSER%", 0, "insert into informix.systraceclasses (name) values ('bts'); ", "f", "delete from informix.systraceclasses where name = 'bts'; ", "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%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 0, "create procedure bts_CreateStorage (lvarchar,integer) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseCreateStorageArea)"" language c; ", "f", "drop procedure bts_CreateStorage (lvarchar,integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 0, "alter procedure bts_CreateStorage (lvarchar,integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseCreateStorageArea)""); ", "f", "alter procedure bts_CreateStorage (lvarchar,integer) with (Modify External Name = ""bts_IfxFseCreateStorageArea""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 86, "Alter-Variant-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 0, "alter procedure bts_CreateStorage (lvarchar,integer) with (add not variant); ", "f", "alter procedure bts_CreateStorage (lvarchar,integer) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 86, "Alter-Variant-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 0, "alter procedure bts_CreateStorage (lvarchar,integer) with (add class=""bts""); ", "f", "alter procedure bts_CreateStorage (lvarchar,integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_CreateStorage (lvarchar,integer) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_DeleteStorage (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDestroyStorageArea)"" language c; ", "f", "drop procedure bts_DeleteStorage (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DeleteStorage (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDestroyStorageArea)""); ", "f", "alter procedure bts_DeleteStorage (lvarchar) with (Modify External Name = ""bts_IfxFseDestroyStorageArea""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 86, "Alter-Variant-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DeleteStorage (lvarchar) with (add not variant); ", "f", "alter procedure bts_DeleteStorage (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 86, "Alter-Variant-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DeleteStorage (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%", 150, "Alter-Class-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DeleteStorage (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_DeleteStorage (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_DeleteStorage (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_DumpStorage (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDumpStorageArea)"" language c; ", "f", "drop procedure bts_DumpStorage (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DumpStorage (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDumpStorageArea)""); ", "f", "alter procedure bts_DumpStorage (lvarchar) with (Modify External Name = ""bts_IfxFseDumpStorageArea""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorage (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%", 150, "Alter-Class-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DumpStorage (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_DumpStorage (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_DumpStorage (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_DumpStorage (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorage (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%", 7, "bts_FseStorageRow", "%SYSBLDUSER%", 0, "create row type bts_FseStorageRow ( sto_name lvarchar, num_buckets int, bucket_num int, bucket blob ); ", "f", "drop row type bts_FseStorageRow 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, "bts_FseStorageRow", "%SYSBLDUSER%", 0, "grant usage on type bts_FseStorageRow 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, "bts_FseStorageRow", "%SYSBLDUSER%", 7, "bts_FseStorageRow", "%SYSBLDUSER%" ); 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, "bts_storage", "%SYSBLDUSER%", 0, "execute function SYSBldTstSBSpace(""""); create table btsfse_storage (sto_row bts_FseStorageRow); grant all on btsfse_storage to public; execute procedure bts_CreateStorage(""bts_index"", 11); ", "f", "execute procedure bts_DeleteStorage(""bts_index""); drop table btsfse_storage; ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 6, "bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 6, "bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 6, "bts_DumpStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 7, "bts_FseStorageRow", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_CreateStorage (lvarchar,integer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_DeleteStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 80, "Alter-Variant-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_storage", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_DumpStorage (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_beginscan (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_beginscan)"" language c; ", "f", "drop function bts_vti_am_beginscan (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_beginscan (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_beginscan)""); ", "f", "alter function bts_vti_am_beginscan (pointer) with (Modify External Name = ""bts_vti_am_beginscan""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_beginscan (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%", 151, "Alter-Class-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_beginscan (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_beginscan (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_beginscan (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, "bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_beginscan (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, "bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_beginscan (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, "bts_vti_am_close (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_close (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_close)"" language c; ", "f", "drop function bts_vti_am_close (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_close (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_close (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_close)""); ", "f", "alter function bts_vti_am_close (pointer) with (Modify External Name = ""bts_vti_am_close""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_close (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_close (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%", 151, "Alter-Class-bts_vti_am_close (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_close (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_close (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_close (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_close (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, "bts_vti_am_close (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_close (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, "bts_vti_am_close (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_close (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, "bts_vti_am_create (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_create (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_create)"" language c; ", "f", "drop function bts_vti_am_create (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_create (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_create (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_create)""); ", "f", "alter function bts_vti_am_create (pointer) with (Modify External Name = ""bts_vti_am_create""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_create (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_create (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%", 151, "Alter-Class-bts_vti_am_create (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_create (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_create (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_create (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_create (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, "bts_vti_am_create (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_create (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, "bts_vti_am_create (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_create (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, "bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_drop (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_drop)"" language c; ", "f", "drop function bts_vti_am_drop (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_drop (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_drop)""); ", "f", "alter function bts_vti_am_drop (pointer) with (Modify External Name = ""bts_vti_am_drop""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_drop (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%", 151, "Alter-Class-bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_drop (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_drop (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_drop (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, "bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_drop (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, "bts_vti_am_drop (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_drop (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, "bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_endscan (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_endscan)"" language c; ", "f", "drop function bts_vti_am_endscan (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_endscan (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_endscan)""); ", "f", "alter function bts_vti_am_endscan (pointer) with (Modify External Name = ""bts_vti_am_endscan""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_endscan (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%", 151, "Alter-Class-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_endscan (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_endscan (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_endscan (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, "bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_endscan (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, "bts_vti_am_endscan (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_endscan (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, "bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_getnext (pointer,pointer,pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_getnext)"" language c; ", "f", "drop function bts_vti_am_getnext (pointer,pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_getnext (pointer,pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_getnext)""); ", "f", "alter function bts_vti_am_getnext (pointer,pointer,pointer) with (Modify External Name = ""bts_vti_am_getnext""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_getnext (pointer,pointer,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%", 151, "Alter-Class-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_getnext (pointer,pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_getnext (pointer,pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_getnext (pointer,pointer,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, "bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_getnext (pointer,pointer,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, "bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_getnext (pointer,pointer,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, "bts_vti_am_open (pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_open (pointer) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_open)"" language c; ", "f", "drop function bts_vti_am_open (pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_open (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_open (pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_open)""); ", "f", "alter function bts_vti_am_open (pointer) with (Modify External Name = ""bts_vti_am_open""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_open (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_open (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%", 151, "Alter-Class-bts_vti_am_open (pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_open (pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_open (pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_open (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_open (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, "bts_vti_am_open (pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_open (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, "bts_vti_am_open (pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_open (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, "bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 0, "create function bts_vti_am_scancost (pointer,pointer) returns real external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_scancost)"" language c; ", "f", "drop function bts_vti_am_scancost (pointer,pointer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_scancost (pointer,pointer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_vti_am_scancost)""); ", "f", "alter function bts_vti_am_scancost (pointer,pointer) with (Modify External Name = ""bts_vti_am_scancost""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_scancost (pointer,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%", 151, "Alter-Class-bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 0, "alter function bts_vti_am_scancost (pointer,pointer) with (add class=""bts""); ", "f", "alter function bts_vti_am_scancost (pointer,pointer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_scancost (pointer,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, "bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 0, "grant execute on function bts_vti_am_scancost (pointer,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, "bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%", 5, "bts_vti_am_scancost (pointer,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%", 0, "bts_info", "%SYSBLDUSER%", 0, "create primary access_method bts_info ( am_create = bts_vti_am_create, am_drop = bts_vti_am_drop, am_open = bts_vti_am_open, am_close = bts_vti_am_close, am_scancost = bts_vti_am_scancost, am_beginscan = bts_vti_am_beginscan, am_getnext = bts_vti_am_getnext, am_endscan = bts_vti_am_endscan, am_sptype = 'x' ); ", "f", "drop access_method bts_info restrict; ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 5, "bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_beginscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_close (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_create (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_drop (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_endscan (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_getnext (pointer,pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_open (pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 80, "Alter-Variant-bts_vti_am_scancost (pointer,pointer)", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "bts_info", "%SYSBLDUSER%", 140, "Alter-PerCallStack-bts_vti_am_scancost (pointer,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%", 0, "json_support", "%SYSBLDUSER%", 0, "create function bts_contains (json,lvarchar) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_json)"" language c; create function bts_contains (json,lvarchar,real) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_json_score)"" language c; create function bts_contains (bson,lvarchar) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_bson)"" language c; create function bts_contains (bson,lvarchar,real) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_bson_score)"" language c; create function bts_contains (longlvarchar,lvarchar) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_longlvarchar)"" language c; create function bts_contains (longlvarchar,lvarchar,real) returns boolean with (class=""bts"", percall_cost=65535, selconst=0.00001) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_contains_longlvarchar_score)"" language c; grant execute on function bts_contains (json,lvarchar) to public; grant execute on function bts_contains (json,lvarchar,real) to public; grant execute on function bts_contains (bson,lvarchar) to public; grant execute on function bts_contains (bson,lvarchar,real) to public; grant execute on function bts_contains (longlvarchar,lvarchar) to public; grant execute on function bts_contains (longlvarchar,lvarchar,real) to public; create opclass bts_json_ops for bts strategies ( bts_contains(json, lvarchar), bts_contains(json, lvarchar, real) ) support (noop); create opclass bts_bson_ops for bts strategies ( bts_contains(bson, lvarchar), bts_contains(bson, lvarchar, real) ) support (noop); create opclass bts_longlvarchar_ops for bts strategies ( bts_contains(longlvarchar, lvarchar), bts_contains(longlvarchar, lvarchar, real) ) support (noop); ", "f", "drop function bts_contains (json,lvarchar); drop function bts_contains (json,lvarchar,real); drop function bts_contains (bson,lvarchar); drop function bts_contains (bson,lvarchar,real); drop function bts_contains (longlvarchar,lvarchar); drop function bts_contains (longlvarchar,lvarchar,real); drop opclass bts_json_ops restrict; drop opclass bts_bson_ops restrict; drop opclass bts_longlvarchar_ops restrict; ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 0, "json_support", "%SYSBLDUSER%", 0, "Access Method", "%SYSBLDUSER%" ); 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, "bts_loadlib ()", "%SYSBLDUSER%", 0, "create function bts_loadlib () returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_loadlib)"" language c; ", "f", "drop function bts_loadlib (); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_loadlib ()", "%SYSBLDUSER%", 0, "alter function bts_loadlib () with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_loadlib)""); ", "f", "alter function bts_loadlib () with (Modify External Name = ""bts_loadlib""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_loadlib ()", "%SYSBLDUSER%", 5, "bts_loadlib ()", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_loadlib ()", "%SYSBLDUSER%", 0, "alter function bts_loadlib () with (add class=""bts""); ", "f", "alter function bts_loadlib () with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_loadlib ()", "%SYSBLDUSER%", 5, "bts_loadlib ()", "%SYSBLDUSER%" ); 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, "bts_loadlib ()", "%SYSBLDUSER%", 0, "grant execute on function bts_loadlib () 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, "bts_loadlib ()", "%SYSBLDUSER%", 5, "bts_loadlib ()", "%SYSBLDUSER%" ); 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, "bts_index_close ()", "%SYSBLDUSER%", 0, "create function bts_index_close () returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_close)"" language c; ", "f", "drop function bts_index_close (); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_close ()", "%SYSBLDUSER%", 0, "alter function bts_index_close () with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_close)""); ", "f", "alter function bts_index_close () with (Modify External Name = ""bts_index_close""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_close ()", "%SYSBLDUSER%", 5, "bts_index_close ()", "%SYSBLDUSER%" ); 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, "bts_index_close ()", "%SYSBLDUSER%", 0, "grant execute on function bts_index_close () 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, "bts_index_close ()", "%SYSBLDUSER%", 5, "bts_index_close ()", "%SYSBLDUSER%" ); 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, "bts_release ()", "%SYSBLDUSER%", 0, "create function bts_release () returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_release)"" language c; ", "f", "drop function bts_release (); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_release ()", "%SYSBLDUSER%", 0, "alter function bts_release () with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_release)""); ", "f", "alter function bts_release () with (Modify External Name = ""bts_release""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_release ()", "%SYSBLDUSER%", 5, "bts_release ()", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_release ()", "%SYSBLDUSER%", 0, "alter function bts_release () with (add not variant); ", "f", "alter function bts_release () with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_release ()", "%SYSBLDUSER%", 5, "bts_release ()", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_release ()", "%SYSBLDUSER%", 0, "alter function bts_release () with (add class=""bts""); ", "f", "alter function bts_release () with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_release ()", "%SYSBLDUSER%", 5, "bts_release ()", "%SYSBLDUSER%" ); 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, "bts_release ()", "%SYSBLDUSER%", 0, "grant execute on function bts_release () 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, "bts_release ()", "%SYSBLDUSER%", 5, "bts_release ()", "%SYSBLDUSER%" ); 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, "bts_index_compact (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_compact (lvarchar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_compact)"" language c; ", "f", "drop function bts_index_compact (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_compact (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_compact (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_compact)""); ", "f", "alter function bts_index_compact (lvarchar) with (Modify External Name = ""bts_index_compact""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_compact (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_compact (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%", 151, "Alter-Class-bts_index_compact (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_compact (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_compact (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_compact (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_compact (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, "bts_index_compact (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_compact (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, "bts_index_compact (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_compact (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_tracefile (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_tracefile (lvarchar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_tracefile)"" language c; ", "f", "drop function bts_tracefile (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_tracefile (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_tracefile (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_tracefile)""); ", "f", "alter function bts_tracefile (lvarchar) with (Modify External Name = ""bts_tracefile""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_tracefile (lvarchar)", "%SYSBLDUSER%", 5, "bts_tracefile (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%", 151, "Alter-Class-bts_tracefile (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_tracefile (lvarchar) with (add class=""bts""); ", "f", "alter function bts_tracefile (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_tracefile (lvarchar)", "%SYSBLDUSER%", 5, "bts_tracefile (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, "bts_tracefile (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_tracefile (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, "bts_tracefile (lvarchar)", "%SYSBLDUSER%", 5, "bts_tracefile (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_tracelevel (integer)", "%SYSBLDUSER%", 0, "create function bts_tracelevel (integer) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_tracelevel)"" language c; ", "f", "drop function bts_tracelevel (integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_tracelevel (integer)", "%SYSBLDUSER%", 0, "alter function bts_tracelevel (integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_tracelevel)""); ", "f", "alter function bts_tracelevel (integer) with (Modify External Name = ""bts_tracelevel""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_tracelevel (integer)", "%SYSBLDUSER%", 5, "bts_tracelevel (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%", 151, "Alter-Class-bts_tracelevel (integer)", "%SYSBLDUSER%", 0, "alter function bts_tracelevel (integer) with (add class=""bts""); ", "f", "alter function bts_tracelevel (integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_tracelevel (integer)", "%SYSBLDUSER%", 5, "bts_tracelevel (integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_tracelevel (integer)", "%SYSBLDUSER%", 0, "grant execute on function bts_tracelevel (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, "bts_tracelevel (integer)", "%SYSBLDUSER%", 5, "bts_tracelevel (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, "bts_index_fields (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_fields (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_fields)"" language c; ", "f", "drop function bts_index_fields (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_fields (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_fields (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_fields)""); ", "f", "alter function bts_index_fields (lvarchar) with (Modify External Name = ""bts_index_fields""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_fields (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fields (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%", 151, "Alter-Class-bts_index_fields (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_fields (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_fields (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_fields (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fields (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, "bts_index_fields (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_fields (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, "bts_index_fields (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fields (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_target (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_target (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_target)"" language c; ", "f", "drop function bts_index_target (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_target (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_target (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_target)""); ", "f", "alter function bts_index_target (lvarchar) with (Modify External Name = ""bts_index_target""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_target (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_target (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%", 151, "Alter-Class-bts_index_target (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_target (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_target (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_target (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_target (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, "bts_index_target (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_target (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, "bts_index_target (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_target (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_stopwords (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_stopwords)"" language c; ", "f", "drop function bts_index_stopwords (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_stopwords (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_stopwords)""); ", "f", "alter function bts_index_stopwords (lvarchar) with (Modify External Name = ""bts_index_stopwords""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_stopwords (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%", 151, "Alter-Class-bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_stopwords (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_stopwords (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_stopwords (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, "bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_stopwords (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, "bts_index_stopwords (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_stopwords (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_default_field (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_default_field)"" language c; ", "f", "drop function bts_index_default_field (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_default_field (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_default_field)""); ", "f", "alter function bts_index_default_field (lvarchar) with (Modify External Name = ""bts_index_default_field""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_default_field (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%", 151, "Alter-Class-bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_default_field (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_default_field (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_default_field (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, "bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_default_field (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, "bts_index_default_field (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_default_field (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_params (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_params (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_params)"" language c; ", "f", "drop function bts_index_params (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_params (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_params (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_params)""); ", "f", "alter function bts_index_params (lvarchar) with (Modify External Name = ""bts_index_params""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_params (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_params (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%", 151, "Alter-Class-bts_index_params (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_params (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_params (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_params (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_params (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, "bts_index_params (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_params (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, "bts_index_params (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_params (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_info (lvarchar,lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_info)"" language c; ", "f", "drop function bts_index_info (lvarchar,lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_info (lvarchar,lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_info)""); ", "f", "alter function bts_index_info (lvarchar,lvarchar) with (Modify External Name = ""bts_index_info""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_info (lvarchar,lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_info (lvarchar,lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_info (lvarchar,lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_index_info (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_xmltags (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_xmltags)"" language c; ", "f", "drop function bts_index_xmltags (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_xmltags (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_xmltags)""); ", "f", "alter function bts_index_xmltags (lvarchar) with (Modify External Name = ""bts_index_xmltags""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_xmltags (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%", 151, "Alter-Class-bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_xmltags (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_xmltags (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_xmltags (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, "bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_xmltags (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, "bts_index_xmltags (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_xmltags (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_DumpStorageNoLock (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDumpStorageAreaNoLock)"" language c; ", "f", "drop procedure bts_DumpStorageNoLock (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DumpStorageNoLock (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDumpStorageAreaNoLock)""); ", "f", "alter procedure bts_DumpStorageNoLock (lvarchar) with (Modify External Name = ""bts_IfxFseDumpStorageAreaNoLock""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorageNoLock (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%", 150, "Alter-Class-bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_DumpStorageNoLock (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_DumpStorageNoLock (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_DumpStorageNoLock (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%", 6, "bts_DumpStorageNoLock (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "create function destroy (bts_FseStorageRow) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDestroy)"" language c; ", "f", "drop function destroy (bts_FseStorageRow); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 7, "bts_FseStorageRow", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function destroy (bts_FseStorageRow) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseDestroy)""); ", "f", "alter function destroy (bts_FseStorageRow) with (Modify External Name = ""bts_IfxFseDestroy""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function destroy (bts_FseStorageRow) with (add not variant); ", "f", "alter function destroy (bts_FseStorageRow) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function destroy (bts_FseStorageRow) with (add class=""bts""); ", "f", "alter function destroy (bts_FseStorageRow) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%" ); 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, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "grant execute on function destroy (bts_FseStorageRow) 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, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "destroy (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "create function lohandles (bts_FseStorageRow) returns lolist external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseHandles)"" language c; ", "f", "drop function lohandles (bts_FseStorageRow); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 7, "bts_FseStorageRow", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function lohandles (bts_FseStorageRow) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseHandles)""); ", "f", "alter function lohandles (bts_FseStorageRow) with (Modify External Name = ""bts_IfxFseHandles""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function lohandles (bts_FseStorageRow) with (add not variant); ", "f", "alter function lohandles (bts_FseStorageRow) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "alter function lohandles (bts_FseStorageRow) with (add class=""bts""); ", "f", "alter function lohandles (bts_FseStorageRow) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 0, "grant execute on function lohandles (bts_FseStorageRow) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%", 5, "lohandles (bts_FseStorageRow)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%", 0, "create DBA procedure bts_free_FSE_mem (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseFreeStorageMem)"" language c; ", "f", "drop procedure bts_free_FSE_mem (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_free_FSE_mem (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_IfxFseFreeStorageMem)""); ", "f", "alter procedure bts_free_FSE_mem (lvarchar) with (Modify External Name = ""bts_IfxFseFreeStorageMem""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%", 6, "bts_free_FSE_mem (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%", 150, "Alter-Class-bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_free_FSE_mem (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_free_FSE_mem (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%", 6, "bts_free_FSE_mem (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_index_hdr_update (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_update)"" language c; ", "f", "drop procedure bts_index_hdr_update (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_update (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_update)""); ", "f", "alter procedure bts_index_hdr_update (lvarchar) with (Modify External Name = ""bts_index_hdr_update""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_update (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%", 150, "Alter-Class-bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_update (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_index_hdr_update (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_index_hdr_update (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_update (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_index_hdr_send_update (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_send_update)"" language c; ", "f", "drop procedure bts_index_hdr_send_update (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_send_update (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_send_update)""); ", "f", "alter procedure bts_index_hdr_send_update (lvarchar) with (Modify External Name = ""bts_index_hdr_send_update""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_send_update (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%", 150, "Alter-Class-bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_send_update (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_index_hdr_send_update (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_index_hdr_send_update (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_hdr_send_update (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 0, "create procedure bts_index_logmsg (lvarchar) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_logmsg)"" language c; ", "f", "drop procedure bts_index_logmsg (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_logmsg (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_logmsg)""); ", "f", "alter procedure bts_index_logmsg (lvarchar) with (Modify External Name = ""bts_index_logmsg""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_logmsg (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%", 150, "Alter-Class-bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 0, "alter procedure bts_index_logmsg (lvarchar) with (add class=""bts""); ", "f", "alter procedure bts_index_logmsg (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_logmsg (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_index_logmsg (lvarchar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_index_logmsg (lvarchar)", "%SYSBLDUSER%", 6, "bts_index_logmsg (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 6, "bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 0, "create procedure bts_index_hdr_logmsg_mode (integer) external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_logmsg_mode)"" language c; ", "f", "drop procedure bts_index_hdr_logmsg_mode (integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_logmsg_mode (integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_hdr_logmsg_mode)""); ", "f", "alter procedure bts_index_hdr_logmsg_mode (integer) with (Modify External Name = ""bts_index_hdr_logmsg_mode""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 182, "Alter-ExternalName-bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 6, "bts_index_hdr_logmsg_mode (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%", 150, "Alter-Class-bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 0, "alter procedure bts_index_hdr_logmsg_mode (integer) with (add class=""bts""); ", "f", "alter procedure bts_index_hdr_logmsg_mode (integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 150, "Alter-Class-bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 6, "bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 0, "grant execute on procedure bts_index_hdr_logmsg_mode (integer) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 70, "bts_index_hdr_logmsg_mode (integer)", "%SYSBLDUSER%", 6, "bts_index_hdr_logmsg_mode (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, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 0, "create function bts_index_soundex_full (lvarchar,integer,integer) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_full)"" language c; ", "f", "drop function bts_index_soundex_full (lvarchar,integer,integer); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_full (lvarchar,integer,integer) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_full)""); ", "f", "alter function bts_index_soundex_full (lvarchar,integer,integer) with (Modify External Name = ""bts_index_soundex_full""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 5, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_full (lvarchar,integer,integer) with (add not variant); ", "f", "alter function bts_index_soundex_full (lvarchar,integer,integer) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 5, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_full (lvarchar,integer,integer) with (add class=""bts""); ", "f", "alter function bts_index_soundex_full (lvarchar,integer,integer) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 5, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_soundex_full (lvarchar,integer,integer) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%", 5, "bts_index_soundex_full (lvarchar,integer,integer)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_soundex (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex)"" language c; ", "f", "drop function bts_index_soundex (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex)""); ", "f", "alter function bts_index_soundex (lvarchar) with (Modify External Name = ""bts_index_soundex""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex (lvarchar) with (add not variant); ", "f", "alter function bts_index_soundex (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex (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%", 151, "Alter-Class-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_soundex (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex (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, "bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_soundex (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, "bts_index_soundex (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_soundex_text (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_text)"" language c; ", "f", "drop function bts_index_soundex_text (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_text)""); ", "f", "alter function bts_index_soundex_text (lvarchar) with (Modify External Name = ""bts_index_soundex_text""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text (lvarchar) with (add not variant); ", "f", "alter function bts_index_soundex_text (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text (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%", 151, "Alter-Class-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_soundex_text (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text (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, "bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_soundex_text (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, "bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_soundex_extended (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_extended)"" language c; ", "f", "drop function bts_index_soundex_extended (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_extended (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_extended)""); ", "f", "alter function bts_index_soundex_extended (lvarchar) with (Modify External Name = ""bts_index_soundex_extended""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_extended (lvarchar) with (add not variant); ", "f", "alter function bts_index_soundex_extended (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_extended (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%", 151, "Alter-Class-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_extended (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_soundex_extended (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_extended (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, "bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_soundex_extended (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, "bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_extended (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_soundex_text_extended (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_text_extended)"" language c; ", "f", "drop function bts_index_soundex_text_extended (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text_extended (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_soundex_text_extended)""); ", "f", "alter function bts_index_soundex_text_extended (lvarchar) with (Modify External Name = ""bts_index_soundex_text_extended""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text_extended (lvarchar) with (add not variant); ", "f", "alter function bts_index_soundex_text_extended (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text_extended (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%", 151, "Alter-Class-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_soundex_text_extended (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_soundex_text_extended (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text_extended (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, "bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_soundex_text_extended (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, "bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_soundex_text_extended (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_fntolv (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_fntolv)"" language c; ", "f", "drop function bts_index_fntolv (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_fntolv (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_fntolv)""); ", "f", "alter function bts_index_fntolv (lvarchar) with (Modify External Name = ""bts_index_fntolv""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fntolv (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_fntolv (lvarchar) with (add not variant); ", "f", "alter function bts_index_fntolv (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fntolv (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%", 151, "Alter-Class-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_fntolv (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_fntolv (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fntolv (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, "bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_fntolv (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, "bts_index_fntolv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_fntolv (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_tokenize_echo (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_tokenize_echo)"" language c; ", "f", "drop function bts_index_tokenize_echo (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_echo (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_tokenize_echo)""); ", "f", "alter function bts_index_tokenize_echo (lvarchar) with (Modify External Name = ""bts_index_tokenize_echo""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_echo (lvarchar) with (add not variant); ", "f", "alter function bts_index_tokenize_echo (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_echo (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%", 151, "Alter-Class-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_echo (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_tokenize_echo (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_echo (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, "bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_tokenize_echo (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, "bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_echo (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_tokenize_alnum (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_tokenize_alnum)"" language c; ", "f", "drop function bts_index_tokenize_alnum (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_alnum (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_tokenize_alnum)""); ", "f", "alter function bts_index_tokenize_alnum (lvarchar) with (Modify External Name = ""bts_index_tokenize_alnum""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_alnum (lvarchar) with (add not variant); ", "f", "alter function bts_index_tokenize_alnum (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_alnum (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%", 151, "Alter-Class-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_tokenize_alnum (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_tokenize_alnum (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_alnum (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, "bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_tokenize_alnum (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, "bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_tokenize_alnum (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 0, "create function bts_index_lvhtrlv (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_lv_htr_lv)"" language c; ", "f", "drop function bts_index_lvhtrlv (lvarchar); ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_lvhtrlv (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/bts.bld(bts_index_lv_htr_lv)""); ", "f", "alter function bts_index_lvhtrlv (lvarchar) with (Modify External Name = ""bts_index_lv_htr_lv""); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 181, "Alter-ExternalName-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_lvhtrlv (lvarchar) with (add not variant); ", "f", "alter function bts_index_lvhtrlv (lvarchar) with (drop not variant); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 85, "Alter-Variant-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_lvhtrlv (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%", 151, "Alter-Class-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_index_lvhtrlv (lvarchar) with (add class=""bts""); ", "f", "alter function bts_index_lvhtrlv (lvarchar) with (drop class); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 151, "Alter-Class-bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_lvhtrlv (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, "bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function bts_index_lvhtrlv (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, "bts_index_lvhtrlv (lvarchar)", "%SYSBLDUSER%", 5, "bts_index_lvhtrlv (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%", 135, "Alter-SelConst-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar) with (add selconst=0.00001); ", "f", "alter function bts_contains (blob,lvarchar) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (blob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (blob,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%", 135, "Alter-SelConst-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar) with (add selconst=0.00001); ", "f", "alter function bts_contains (clob,lvarchar) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (clob,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar) with (add selconst=0.00001); ", "f", "alter function bts_contains (lvarchar,lvarchar) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (blob,lvarchar,real) with (add selconst=0.00001); ", "f", "alter function bts_contains (blob,lvarchar,real) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (blob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (clob,lvarchar,real) with (add selconst=0.00001); ", "f", "alter function bts_contains (clob,lvarchar,real) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (clob,lvarchar,real)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 0, "alter function bts_contains (lvarchar,lvarchar,real) with (add selconst=0.00001); ", "f", "alter function bts_contains (lvarchar,lvarchar,real) with (drop selconst); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 135, "Alter-SelConst-bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%", 5, "bts_contains (lvarchar,lvarchar,real)", "%SYSBLDUSER%" ); 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, "IBTS3", "%SYSBLDUSER%", 0, "insert into sysbldiprovided (bldi_id, bld_id) values ( ""IBTS3"", ""%SYSBLDNAME%"" ); ", "f", "delete from sysbldiprovided where bldi_id = ""IBTS3"" 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" );