-- Generated by BladeSmith 4.00.TC6 DO NOT MODIFY. -- execute procedure ifx_allow_newline('t'); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 7, "binaryvar", "%SYSBLDUSER%", 0, "create opaque type binaryvar( internallength = variable, maxlen = 255, alignment = 4 ); ", "f", "drop type binaryvar 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, "binaryvar", "%SYSBLDUSER%", 0, "grant usage on type binaryvar 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, "binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarIn (lvarchar)", "%SYSBLDUSER%", 0, "create function binaryvarIn (lvarchar) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarInput)"" language c; ", "f", "drop function binaryvarIn (lvarchar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarIn (lvarchar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 0, "alter function binaryvarIn (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarInput)""); ", "f", "alter function binaryvarIn (lvarchar) with (Modify External Name = ""binaryvarInput""); ", "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-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 5, "binaryvarIn (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%", 37, "Alter-Parallelize-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 0, "alter function binaryvarIn (lvarchar) with (add parallelizable); ", "f", "alter function binaryvarIn (lvarchar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 5, "binaryvarIn (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-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 0, "alter function binaryvarIn (lvarchar) with (add variant); ", "f", "alter function binaryvarIn (lvarchar) with (drop 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-binaryvarIn (lvarchar)", "%SYSBLDUSER%", 5, "binaryvarIn (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, "binaryvarIn (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarIn (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, "binaryvarIn (lvarchar)", "%SYSBLDUSER%", 5, "binaryvarIn (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "lvarchar->binaryvar", "%SYSBLDUSER%", 0, "create implicit cast ( lvarchar as binaryvar with binaryvarIn ); ", "f", "drop cast (lvarchar as binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "lvarchar->binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarOut (binaryvar)", "%SYSBLDUSER%", 0, "create function binaryvarOut (binaryvar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarOutput)"" language c; ", "f", "drop function binaryvarOut (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarOut (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarOut (binaryvar)", "%SYSBLDUSER%", 0, "alter function binaryvarOut (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarOutput)""); ", "f", "alter function binaryvarOut (binaryvar) with (Modify External Name = ""binaryvarOutput""); ", "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-binaryvarOut (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarOut (binaryvar)", "%SYSBLDUSER%" ); 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, "binaryvarOut (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarOut (binaryvar) 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, "binaryvarOut (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarOut (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binaryvar->lvarchar", "%SYSBLDUSER%", 0, "create cast ( binaryvar as lvarchar with binaryvarOut ); ", "f", "drop cast (binaryvar as lvarchar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->lvarchar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarSend (binaryvar)", "%SYSBLDUSER%", 0, "create function binaryvarSend (binaryvar) returns sendrecv external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarSend)"" language c; ", "f", "drop function binaryvarSend (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarSend (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarSend (binaryvar)", "%SYSBLDUSER%", 0, "alter function binaryvarSend (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarSend)""); ", "f", "alter function binaryvarSend (binaryvar) with (Modify External Name = ""binaryvarSend""); ", "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-binaryvarSend (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarSend (binaryvar)", "%SYSBLDUSER%" ); 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, "binaryvarSend (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarSend (binaryvar) 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, "binaryvarSend (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarSend (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binaryvar->sendrecv", "%SYSBLDUSER%", 0, "create cast ( binaryvar as sendrecv with binaryvarSend ); ", "f", "drop cast (binaryvar as sendrecv); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->sendrecv", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 0, "create function binaryvarRecv (sendrecv) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarReceive)"" language c; ", "f", "drop function binaryvarRecv (sendrecv); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 0, "alter function binaryvarRecv (sendrecv) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarReceive)""); ", "f", "alter function binaryvarRecv (sendrecv) with (Modify External Name = ""binaryvarReceive""); ", "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-binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 5, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarRecv (sendrecv) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%", 5, "binaryvarRecv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "sendrecv->binaryvar", "%SYSBLDUSER%", 0, "create implicit cast ( sendrecv as binaryvar with binaryvarRecv ); ", "f", "drop cast (sendrecv as binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "sendrecv->binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarImpT (impexp)", "%SYSBLDUSER%", 0, "create function binaryvarImpT (impexp) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarImportText)"" language c; ", "f", "drop function binaryvarImpT (impexp); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarImpT (impexp)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarImpT (impexp)", "%SYSBLDUSER%", 0, "alter function binaryvarImpT (impexp) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarImportText)""); ", "f", "alter function binaryvarImpT (impexp) with (Modify External Name = ""binaryvarImportText""); ", "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-binaryvarImpT (impexp)", "%SYSBLDUSER%", 5, "binaryvarImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binaryvarImpT (impexp)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarImpT (impexp) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binaryvarImpT (impexp)", "%SYSBLDUSER%", 5, "binaryvarImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "impexp->binaryvar", "%SYSBLDUSER%", 0, "create implicit cast ( impexp as binaryvar with binaryvarImpT ); ", "f", "drop cast (impexp as binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "impexp->binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 0, "create function binaryvarExpT (binaryvar) returns impexp external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarExportText)"" language c; ", "f", "drop function binaryvarExpT (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 0, "alter function binaryvarExpT (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarExportText)""); ", "f", "alter function binaryvarExpT (binaryvar) with (Modify External Name = ""binaryvarExportText""); ", "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-binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%" ); 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, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarExpT (binaryvar) 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, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarExpT (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binaryvar->impexp", "%SYSBLDUSER%", 0, "create cast ( binaryvar as impexp with binaryvarExpT ); ", "f", "drop cast (binaryvar as impexp); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->impexp", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 0, "create function binaryvarImpB (impexpbin) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarImportBinary)"" language c; ", "f", "drop function binaryvarImpB (impexpbin); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 0, "alter function binaryvarImpB (impexpbin) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarImportBinary)""); ", "f", "alter function binaryvarImpB (impexpbin) with (Modify External Name = ""binaryvarImportBinary""); ", "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-binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 5, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarImpB (impexpbin) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%", 5, "binaryvarImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "impexpbin->binaryvar", "%SYSBLDUSER%", 0, "create implicit cast ( impexpbin as binaryvar with binaryvarImpB ); ", "f", "drop cast (impexpbin as binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "impexpbin->binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 0, "create function binaryvarExpB (binaryvar) returns impexpbin external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarExportBinary)"" language c; ", "f", "drop function binaryvarExpB (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 0, "alter function binaryvarExpB (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarExportBinary)""); ", "f", "alter function binaryvarExpB (binaryvar) with (Modify External Name = ""binaryvarExportBinary""); ", "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-binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%" ); 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, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarExpB (binaryvar) 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, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%", 5, "binaryvarExpB (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binaryvar->impexpbin", "%SYSBLDUSER%", 0, "create cast ( binaryvar as impexpbin with binaryvarExpB ); ", "f", "drop cast (binaryvar as impexpbin); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->impexpbin", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function Compare (binaryvar,binaryvar) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarCompare)"" language c; ", "f", "drop function Compare (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Compare (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarCompare)""); ", "f", "alter function Compare (binaryvar,binaryvar) with (Modify External Name = ""binaryvarCompare""); ", "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-Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Compare (binaryvar,binaryvar) with (add not variant); ", "f", "alter function Compare (binaryvar,binaryvar) 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-Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function Compare (binaryvar,binaryvar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Compare (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function Equal (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarEqual)"" language c; ", "f", "drop function Equal (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Equal (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarEqual)""); ", "f", "alter function Equal (binaryvar,binaryvar) with (Modify External Name = ""binaryvarEqual""); ", "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-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Equal (binaryvar,binaryvar) with (add not variant); ", "f", "alter function Equal (binaryvar,binaryvar) 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-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Equal (binaryvar,binaryvar) with (add negator=NotEqual); ", "f", "alter function Equal (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function Equal (binaryvar,binaryvar) with (add Commutator=Equal); ", "f", "alter function Equal (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function Equal (binaryvar,binaryvar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "Equal (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function NotEqual (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarNotEqual)"" language c; ", "f", "drop function NotEqual (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function NotEqual (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarNotEqual)""); ", "f", "alter function NotEqual (binaryvar,binaryvar) with (Modify External Name = ""binaryvarNotEqual""); ", "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-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function NotEqual (binaryvar,binaryvar) with (add not variant); ", "f", "alter function NotEqual (binaryvar,binaryvar) 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-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function NotEqual (binaryvar,binaryvar) with (add negator=Equal); ", "f", "alter function NotEqual (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function NotEqual (binaryvar,binaryvar) with (add Commutator=NotEqual); ", "f", "alter function NotEqual (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function NotEqual (binaryvar,binaryvar) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "NotEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function LessThan (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarLessThan)"" language c; ", "f", "drop function LessThan (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThan (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarLessThan)""); ", "f", "alter function LessThan (binaryvar,binaryvar) with (Modify External Name = ""binaryvarLessThan""); ", "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-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThan (binaryvar,binaryvar) with (add not variant); ", "f", "alter function LessThan (binaryvar,binaryvar) 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-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThan (binaryvar,binaryvar) with (add negator=GreaterThanOrEqual); ", "f", "alter function LessThan (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThan (binaryvar,binaryvar) with (add Commutator=GreaterThanOrEqual); ", "f", "alter function LessThan (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function LessThan (binaryvar,binaryvar) 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, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function GreaterThan (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarGreaterThan)"" language c; ", "f", "drop function GreaterThan (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarGreaterThan)""); ", "f", "alter function GreaterThan (binaryvar,binaryvar) with (Modify External Name = ""binaryvarGreaterThan""); ", "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-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binaryvar,binaryvar) with (add not variant); ", "f", "alter function GreaterThan (binaryvar,binaryvar) 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-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binaryvar,binaryvar) with (add negator=LessThanOrEqual); ", "f", "alter function GreaterThan (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binaryvar,binaryvar) with (add Commutator=LessThanOrEqual); ", "f", "alter function GreaterThan (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function GreaterThan (binaryvar,binaryvar) 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, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThan (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function LessThanOrEqual (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarLessThanOrEqual)"" language c; ", "f", "drop function LessThanOrEqual (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarLessThanOrEqual)""); ", "f", "alter function LessThanOrEqual (binaryvar,binaryvar) with (Modify External Name = ""binaryvarLessThanOrEqual""); ", "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-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binaryvar,binaryvar) with (add not variant); ", "f", "alter function LessThanOrEqual (binaryvar,binaryvar) 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-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binaryvar,binaryvar) with (add negator=GreaterThan); ", "f", "alter function LessThanOrEqual (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binaryvar,binaryvar) with (add Commutator=GreaterThan); ", "f", "alter function LessThanOrEqual (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function LessThanOrEqual (binaryvar,binaryvar) 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, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function GreaterThanOrEqual (binaryvar,binaryvar) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarGreaterThanOrEqual)"" language c; ", "f", "drop function GreaterThanOrEqual (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvarGreaterThanOrEqual)""); ", "f", "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (Modify External Name = ""binaryvarGreaterThanOrEqual""); ", "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-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (add not variant); ", "f", "alter function GreaterThanOrEqual (binaryvar,binaryvar) 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-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (add negator=LessThan); ", "f", "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (add Commutator=LessThan); ", "f", "alter function GreaterThanOrEqual (binaryvar,binaryvar) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function GreaterThanOrEqual (binaryvar,binaryvar) 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, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "binary18", "%SYSBLDUSER%", 0, "create opaque type binary18( internallength = 18, alignment = 4 ); ", "f", "drop type binary18 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, "binary18", "%SYSBLDUSER%", 0, "grant usage on type binary18 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, "binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18In (lvarchar)", "%SYSBLDUSER%", 0, "create function binary18In (lvarchar) returns binary18 external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Input)"" language c; ", "f", "drop function binary18In (lvarchar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18In (lvarchar)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18In (lvarchar)", "%SYSBLDUSER%", 0, "alter function binary18In (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Input)""); ", "f", "alter function binary18In (lvarchar) with (Modify External Name = ""binary18Input""); ", "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-binary18In (lvarchar)", "%SYSBLDUSER%", 5, "binary18In (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%", 37, "Alter-Parallelize-binary18In (lvarchar)", "%SYSBLDUSER%", 0, "alter function binary18In (lvarchar) with (add parallelizable); ", "f", "alter function binary18In (lvarchar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18In (lvarchar)", "%SYSBLDUSER%", 5, "binary18In (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-binary18In (lvarchar)", "%SYSBLDUSER%", 0, "alter function binary18In (lvarchar) with (add variant); ", "f", "alter function binary18In (lvarchar) with (drop 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-binary18In (lvarchar)", "%SYSBLDUSER%", 5, "binary18In (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, "binary18In (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function binary18In (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, "binary18In (lvarchar)", "%SYSBLDUSER%", 5, "binary18In (lvarchar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "lvarchar->binary18", "%SYSBLDUSER%", 0, "create implicit cast ( lvarchar as binary18 with binary18In ); ", "f", "drop cast (lvarchar as binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "lvarchar->binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18Out (binary18)", "%SYSBLDUSER%", 0, "create function binary18Out (binary18) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Output)"" language c; ", "f", "drop function binary18Out (binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18Out (binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18Out (binary18)", "%SYSBLDUSER%", 0, "alter function binary18Out (binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Output)""); ", "f", "alter function binary18Out (binary18) with (Modify External Name = ""binary18Output""); ", "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-binary18Out (binary18)", "%SYSBLDUSER%", 5, "binary18Out (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18Out (binary18)", "%SYSBLDUSER%", 0, "alter function binary18Out (binary18) with (add parallelizable); ", "f", "alter function binary18Out (binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18Out (binary18)", "%SYSBLDUSER%", 5, "binary18Out (binary18)", "%SYSBLDUSER%" ); 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-binary18Out (binary18)", "%SYSBLDUSER%", 0, "alter function binary18Out (binary18) with (add not variant); ", "f", "alter function binary18Out (binary18) 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-binary18Out (binary18)", "%SYSBLDUSER%", 5, "binary18Out (binary18)", "%SYSBLDUSER%" ); 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, "binary18Out (binary18)", "%SYSBLDUSER%", 0, "grant execute on function binary18Out (binary18) 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, "binary18Out (binary18)", "%SYSBLDUSER%", 5, "binary18Out (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binary18->lvarchar", "%SYSBLDUSER%", 0, "create cast ( binary18 as lvarchar with binary18Out ); ", "f", "drop cast (binary18 as lvarchar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->lvarchar", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18Send (binary18)", "%SYSBLDUSER%", 0, "create function binary18Send (binary18) returns sendrecv external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Send)"" language c; ", "f", "drop function binary18Send (binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18Send (binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18Send (binary18)", "%SYSBLDUSER%", 0, "alter function binary18Send (binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Send)""); ", "f", "alter function binary18Send (binary18) with (Modify External Name = ""binary18Send""); ", "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-binary18Send (binary18)", "%SYSBLDUSER%", 5, "binary18Send (binary18)", "%SYSBLDUSER%" ); 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, "binary18Send (binary18)", "%SYSBLDUSER%", 0, "grant execute on function binary18Send (binary18) 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, "binary18Send (binary18)", "%SYSBLDUSER%", 5, "binary18Send (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binary18->sendrecv", "%SYSBLDUSER%", 0, "create cast ( binary18 as sendrecv with binary18Send ); ", "f", "drop cast (binary18 as sendrecv); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->sendrecv", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18Recv (sendrecv)", "%SYSBLDUSER%", 0, "create function binary18Recv (sendrecv) returns binary18 external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Receive)"" language c; ", "f", "drop function binary18Recv (sendrecv); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18Recv (sendrecv)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18Recv (sendrecv)", "%SYSBLDUSER%", 0, "alter function binary18Recv (sendrecv) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Receive)""); ", "f", "alter function binary18Recv (sendrecv) with (Modify External Name = ""binary18Receive""); ", "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-binary18Recv (sendrecv)", "%SYSBLDUSER%", 5, "binary18Recv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18Recv (sendrecv)", "%SYSBLDUSER%", 0, "alter function binary18Recv (sendrecv) with (add parallelizable); ", "f", "alter function binary18Recv (sendrecv) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18Recv (sendrecv)", "%SYSBLDUSER%", 5, "binary18Recv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-binary18Recv (sendrecv)", "%SYSBLDUSER%", 0, "alter function binary18Recv (sendrecv) with (add not variant); ", "f", "alter function binary18Recv (sendrecv) 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-binary18Recv (sendrecv)", "%SYSBLDUSER%", 5, "binary18Recv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binary18Recv (sendrecv)", "%SYSBLDUSER%", 0, "grant execute on function binary18Recv (sendrecv) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binary18Recv (sendrecv)", "%SYSBLDUSER%", 5, "binary18Recv (sendrecv)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "sendrecv->binary18", "%SYSBLDUSER%", 0, "create implicit cast ( sendrecv as binary18 with binary18Recv ); ", "f", "drop cast (sendrecv as binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "sendrecv->binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18ImpT (impexp)", "%SYSBLDUSER%", 0, "create function binary18ImpT (impexp) returns binary18 external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ImportText)"" language c; ", "f", "drop function binary18ImpT (impexp); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18ImpT (impexp)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18ImpT (impexp)", "%SYSBLDUSER%", 0, "alter function binary18ImpT (impexp) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ImportText)""); ", "f", "alter function binary18ImpT (impexp) with (Modify External Name = ""binary18ImportText""); ", "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-binary18ImpT (impexp)", "%SYSBLDUSER%", 5, "binary18ImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ImpT (impexp)", "%SYSBLDUSER%", 0, "alter function binary18ImpT (impexp) with (add parallelizable); ", "f", "alter function binary18ImpT (impexp) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ImpT (impexp)", "%SYSBLDUSER%", 5, "binary18ImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-binary18ImpT (impexp)", "%SYSBLDUSER%", 0, "alter function binary18ImpT (impexp) with (add not variant); ", "f", "alter function binary18ImpT (impexp) 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-binary18ImpT (impexp)", "%SYSBLDUSER%", 5, "binary18ImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binary18ImpT (impexp)", "%SYSBLDUSER%", 0, "grant execute on function binary18ImpT (impexp) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binary18ImpT (impexp)", "%SYSBLDUSER%", 5, "binary18ImpT (impexp)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "impexp->binary18", "%SYSBLDUSER%", 0, "create implicit cast ( impexp as binary18 with binary18ImpT ); ", "f", "drop cast (impexp as binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "impexp->binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18ExpT (binary18)", "%SYSBLDUSER%", 0, "create function binary18ExpT (binary18) returns impexp external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ExportText)"" language c; ", "f", "drop function binary18ExpT (binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18ExpT (binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18ExpT (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpT (binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ExportText)""); ", "f", "alter function binary18ExpT (binary18) with (Modify External Name = ""binary18ExportText""); ", "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-binary18ExpT (binary18)", "%SYSBLDUSER%", 5, "binary18ExpT (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ExpT (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpT (binary18) with (add parallelizable); ", "f", "alter function binary18ExpT (binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ExpT (binary18)", "%SYSBLDUSER%", 5, "binary18ExpT (binary18)", "%SYSBLDUSER%" ); 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-binary18ExpT (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpT (binary18) with (add not variant); ", "f", "alter function binary18ExpT (binary18) 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-binary18ExpT (binary18)", "%SYSBLDUSER%", 5, "binary18ExpT (binary18)", "%SYSBLDUSER%" ); 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, "binary18ExpT (binary18)", "%SYSBLDUSER%", 0, "grant execute on function binary18ExpT (binary18) 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, "binary18ExpT (binary18)", "%SYSBLDUSER%", 5, "binary18ExpT (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binary18->impexp", "%SYSBLDUSER%", 0, "create cast ( binary18 as impexp with binary18ExpT ); ", "f", "drop cast (binary18 as impexp); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->impexp", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18ImpB (impexpbin)", "%SYSBLDUSER%", 0, "create function binary18ImpB (impexpbin) returns binary18 external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ImportBinary)"" language c; ", "f", "drop function binary18ImpB (impexpbin); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18ImpB (impexpbin)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 0, "alter function binary18ImpB (impexpbin) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ImportBinary)""); ", "f", "alter function binary18ImpB (impexpbin) with (Modify External Name = ""binary18ImportBinary""); ", "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-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 5, "binary18ImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 0, "alter function binary18ImpB (impexpbin) with (add parallelizable); ", "f", "alter function binary18ImpB (impexpbin) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 5, "binary18ImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 85, "Alter-Variant-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 0, "alter function binary18ImpB (impexpbin) with (add not variant); ", "f", "alter function binary18ImpB (impexpbin) 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-binary18ImpB (impexpbin)", "%SYSBLDUSER%", 5, "binary18ImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "binary18ImpB (impexpbin)", "%SYSBLDUSER%", 0, "grant execute on function binary18ImpB (impexpbin) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "binary18ImpB (impexpbin)", "%SYSBLDUSER%", 5, "binary18ImpB (impexpbin)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "impexpbin->binary18", "%SYSBLDUSER%", 0, "create implicit cast ( impexpbin as binary18 with binary18ImpB ); ", "f", "drop cast (impexpbin as binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "impexpbin->binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18ExpB (binary18)", "%SYSBLDUSER%", 0, "create function binary18ExpB (binary18) returns impexpbin external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ExportBinary)"" language c; ", "f", "drop function binary18ExpB (binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18ExpB (binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-binary18ExpB (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpB (binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18ExportBinary)""); ", "f", "alter function binary18ExpB (binary18) with (Modify External Name = ""binary18ExportBinary""); ", "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-binary18ExpB (binary18)", "%SYSBLDUSER%", 5, "binary18ExpB (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ExpB (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpB (binary18) with (add parallelizable); ", "f", "alter function binary18ExpB (binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-binary18ExpB (binary18)", "%SYSBLDUSER%", 5, "binary18ExpB (binary18)", "%SYSBLDUSER%" ); 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-binary18ExpB (binary18)", "%SYSBLDUSER%", 0, "alter function binary18ExpB (binary18) with (add not variant); ", "f", "alter function binary18ExpB (binary18) 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-binary18ExpB (binary18)", "%SYSBLDUSER%", 5, "binary18ExpB (binary18)", "%SYSBLDUSER%" ); 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, "binary18ExpB (binary18)", "%SYSBLDUSER%", 0, "grant execute on function binary18ExpB (binary18) 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, "binary18ExpB (binary18)", "%SYSBLDUSER%", 5, "binary18ExpB (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binary18->impexpbin", "%SYSBLDUSER%", 0, "create cast ( binary18 as impexpbin with binary18ExpB ); ", "f", "drop cast (binary18 as impexpbin); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->impexpbin", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%", 0, "create function Compare (binary18,binary18) returns integer external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Compare)"" language c; ", "f", "drop function Compare (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-Compare (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Compare (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Compare)""); ", "f", "alter function Compare (binary18,binary18) with (Modify External Name = ""binary18Compare""); ", "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-Compare (binary18,binary18)", "%SYSBLDUSER%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-Compare (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Compare (binary18,binary18) with (add parallelizable); ", "f", "alter function Compare (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-Compare (binary18,binary18)", "%SYSBLDUSER%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%" ); 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-Compare (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Compare (binary18,binary18) with (add not variant); ", "f", "alter function Compare (binary18,binary18) 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-Compare (binary18,binary18)", "%SYSBLDUSER%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "Compare (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function Compare (binary18,binary18) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "Compare (binary18,binary18)", "%SYSBLDUSER%", 5, "Compare (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "create function Equal (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Equal)"" language c; ", "f", "drop function Equal (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Equal (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18Equal)""); ", "f", "alter function Equal (binary18,binary18) with (Modify External Name = ""binary18Equal""); ", "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-Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Equal (binary18,binary18) with (add parallelizable); ", "f", "alter function Equal (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); 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-Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Equal (binary18,binary18) with (add not variant); ", "f", "alter function Equal (binary18,binary18) 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-Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Equal (binary18,binary18) with (add negator=NotEqual); ", "f", "alter function Equal (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function Equal (binary18,binary18) with (add Commutator=Equal); ", "f", "alter function Equal (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "Equal (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function Equal (binary18,binary18) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "Equal (binary18,binary18)", "%SYSBLDUSER%", 5, "Equal (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "create function NotEqual (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18NotEqual)"" language c; ", "f", "drop function NotEqual (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function NotEqual (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18NotEqual)""); ", "f", "alter function NotEqual (binary18,binary18) with (Modify External Name = ""binary18NotEqual""); ", "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-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function NotEqual (binary18,binary18) with (add parallelizable); ", "f", "alter function NotEqual (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function NotEqual (binary18,binary18) with (add not variant); ", "f", "alter function NotEqual (binary18,binary18) 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-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function NotEqual (binary18,binary18) with (add negator=Equal); ", "f", "alter function NotEqual (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function NotEqual (binary18,binary18) with (add Commutator=NotEqual); ", "f", "alter function NotEqual (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 69, "NotEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function NotEqual (binary18,binary18) to public; ", "f", "", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 69, "NotEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "NotEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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, "LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "create function LessThan (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18LessThan)"" language c; ", "f", "drop function LessThan (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThan (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18LessThan)""); ", "f", "alter function LessThan (binary18,binary18) with (Modify External Name = ""binary18LessThan""); ", "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-LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThan (binary18,binary18) with (add parallelizable); ", "f", "alter function LessThan (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); 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-LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThan (binary18,binary18) with (add not variant); ", "f", "alter function LessThan (binary18,binary18) 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-LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThan (binary18,binary18) with (add negator=GreaterThanOrEqual); ", "f", "alter function LessThan (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThan (binary18,binary18) with (add Commutator=GreaterThanOrEqual); ", "f", "alter function LessThan (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); 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, "LessThan (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function LessThan (binary18,binary18) 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, "LessThan (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThan (binary18,binary18)", "%SYSBLDUSER%" ); 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, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "create function GreaterThan (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18GreaterThan)"" language c; ", "f", "drop function GreaterThan (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18GreaterThan)""); ", "f", "alter function GreaterThan (binary18,binary18) with (Modify External Name = ""binary18GreaterThan""); ", "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-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binary18,binary18) with (add parallelizable); ", "f", "alter function GreaterThan (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); 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-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binary18,binary18) with (add not variant); ", "f", "alter function GreaterThan (binary18,binary18) 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-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binary18,binary18) with (add negator=LessThanOrEqual); ", "f", "alter function GreaterThan (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThan (binary18,binary18) with (add Commutator=LessThanOrEqual); ", "f", "alter function GreaterThan (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); 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, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function GreaterThan (binary18,binary18) 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, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThan (binary18,binary18)", "%SYSBLDUSER%" ); 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, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "create function LessThanOrEqual (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18LessThanOrEqual)"" language c; ", "f", "drop function LessThanOrEqual (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18LessThanOrEqual)""); ", "f", "alter function LessThanOrEqual (binary18,binary18) with (Modify External Name = ""binary18LessThanOrEqual""); ", "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-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binary18,binary18) with (add parallelizable); ", "f", "alter function LessThanOrEqual (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binary18,binary18) with (add not variant); ", "f", "alter function LessThanOrEqual (binary18,binary18) 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-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binary18,binary18) with (add negator=GreaterThan); ", "f", "alter function LessThanOrEqual (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function LessThanOrEqual (binary18,binary18) with (add Commutator=GreaterThan); ", "f", "alter function LessThanOrEqual (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function LessThanOrEqual (binary18,binary18) 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, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "LessThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "create function GreaterThanOrEqual (binary18,binary18) returns boolean external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18GreaterThanOrEqual)"" language c; ", "f", "drop function GreaterThanOrEqual (binary18,binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binary18,binary18) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binary18GreaterThanOrEqual)""); ", "f", "alter function GreaterThanOrEqual (binary18,binary18) with (Modify External Name = ""binary18GreaterThanOrEqual""); ", "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-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binary18,binary18) with (add parallelizable); ", "f", "alter function GreaterThanOrEqual (binary18,binary18) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binary18,binary18) with (add not variant); ", "f", "alter function GreaterThanOrEqual (binary18,binary18) 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-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binary18,binary18) with (add negator=LessThan); ", "f", "alter function GreaterThanOrEqual (binary18,binary18) with (drop negator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "alter function GreaterThanOrEqual (binary18,binary18) with (add Commutator=LessThan); ", "f", "alter function GreaterThanOrEqual (binary18,binary18) with (drop Commutator); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 0, "grant execute on function GreaterThanOrEqual (binary18,binary18) 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, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%", 5, "GreaterThanOrEqual (binary18,binary18)", "%SYSBLDUSER%" ); 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, "length (binaryvar)", "%SYSBLDUSER%", 0, "create function length (binaryvar) returns int external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_binlength)"" language c; ", "f", "drop function length (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "length (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-length (binaryvar)", "%SYSBLDUSER%", 0, "alter function length (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_binlength)""); ", "f", "alter function length (binaryvar) with (Modify External Name = ""binaryvar_binlength""); ", "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-length (binaryvar)", "%SYSBLDUSER%", 5, "length (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-length (binaryvar)", "%SYSBLDUSER%", 0, "alter function length (binaryvar) with (add parallelizable); ", "f", "alter function length (binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-length (binaryvar)", "%SYSBLDUSER%", 5, "length (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-length (binaryvar)", "%SYSBLDUSER%", 0, "alter function length (binaryvar) with (add handlesnulls); ", "f", "alter function length (binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-length (binaryvar)", "%SYSBLDUSER%", 5, "length (binaryvar)", "%SYSBLDUSER%" ); 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-length (binaryvar)", "%SYSBLDUSER%", 0, "alter function length (binaryvar) with (add not variant); ", "f", "alter function length (binaryvar) 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-length (binaryvar)", "%SYSBLDUSER%", 5, "length (binaryvar)", "%SYSBLDUSER%" ); 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, "length (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function length (binaryvar) 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, "length (binaryvar)", "%SYSBLDUSER%", 5, "length (binaryvar)", "%SYSBLDUSER%" ); 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, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function bit_or (binaryvar,binaryvar) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitOR)"" language c; ", "f", "drop function bit_or (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_or (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitOR)""); ", "f", "alter function bit_or (binaryvar,binaryvar) with (Modify External Name = ""binaryvar_bitOR""); ", "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-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_or (binaryvar,binaryvar) with (add parallelizable); ", "f", "alter function bit_or (binaryvar,binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_or (binaryvar,binaryvar) with (add handlesnulls); ", "f", "alter function bit_or (binaryvar,binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_or (binaryvar,binaryvar) with (add not variant); ", "f", "alter function bit_or (binaryvar,binaryvar) 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-bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function bit_or (binaryvar,binaryvar) 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, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_or (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function bit_and (binaryvar,binaryvar) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitAND)"" language c; ", "f", "drop function bit_and (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_and (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitAND)""); ", "f", "alter function bit_and (binaryvar,binaryvar) with (Modify External Name = ""binaryvar_bitAND""); ", "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-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_and (binaryvar,binaryvar) with (add parallelizable); ", "f", "alter function bit_and (binaryvar,binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_and (binaryvar,binaryvar) with (add handlesnulls); ", "f", "alter function bit_and (binaryvar,binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_and (binaryvar,binaryvar) with (add not variant); ", "f", "alter function bit_and (binaryvar,binaryvar) 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-bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function bit_and (binaryvar,binaryvar) 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, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_and (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "create function bit_xor (binaryvar,binaryvar) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitXOR)"" language c; ", "f", "drop function bit_xor (binaryvar,binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_xor (binaryvar,binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitXOR)""); ", "f", "alter function bit_xor (binaryvar,binaryvar) with (Modify External Name = ""binaryvar_bitXOR""); ", "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-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_xor (binaryvar,binaryvar) with (add parallelizable); ", "f", "alter function bit_xor (binaryvar,binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_xor (binaryvar,binaryvar) with (add handlesnulls); ", "f", "alter function bit_xor (binaryvar,binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_xor (binaryvar,binaryvar) with (add not variant); ", "f", "alter function bit_xor (binaryvar,binaryvar) 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-bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function bit_xor (binaryvar,binaryvar) 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, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%", 5, "bit_xor (binaryvar,binaryvar)", "%SYSBLDUSER%" ); 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, "bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "create function bit_complement (binaryvar) returns binaryvar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitcomplement)"" language c; ", "f", "drop function bit_complement (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_complement (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_bitcomplement)""); ", "f", "alter function bit_complement (binaryvar) with (Modify External Name = ""binaryvar_bitcomplement""); ", "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-bit_complement (binaryvar)", "%SYSBLDUSER%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_complement (binaryvar) with (add parallelizable); ", "f", "alter function bit_complement (binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-bit_complement (binaryvar)", "%SYSBLDUSER%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_complement (binaryvar) with (add handlesnulls); ", "f", "alter function bit_complement (binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-bit_complement (binaryvar)", "%SYSBLDUSER%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%" ); 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-bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "alter function bit_complement (binaryvar) with (add not variant); ", "f", "alter function bit_complement (binaryvar) 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-bit_complement (binaryvar)", "%SYSBLDUSER%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%" ); 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, "bit_complement (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function bit_complement (binaryvar) 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, "bit_complement (binaryvar)", "%SYSBLDUSER%", 5, "bit_complement (binaryvar)", "%SYSBLDUSER%" ); 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, "BDTRelease ()", "%SYSBLDUSER%", 0, "create function BDTRelease () returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(BDTRelease)"" language c; ", "f", "drop function BDTRelease (); ", "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-BDTRelease ()", "%SYSBLDUSER%", 0, "alter function BDTRelease () with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(BDTRelease)""); ", "f", "alter function BDTRelease () with (Modify External Name = ""BDTRelease""); ", "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-BDTRelease ()", "%SYSBLDUSER%", 5, "BDTRelease ()", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-BDTRelease ()", "%SYSBLDUSER%", 0, "alter function BDTRelease () with (add handlesnulls); ", "f", "alter function BDTRelease () with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-BDTRelease ()", "%SYSBLDUSER%", 5, "BDTRelease ()", "%SYSBLDUSER%" ); 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-BDTRelease ()", "%SYSBLDUSER%", 0, "alter function BDTRelease () with (add not variant); ", "f", "alter function BDTRelease () 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-BDTRelease ()", "%SYSBLDUSER%", 5, "BDTRelease ()", "%SYSBLDUSER%" ); 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, "BDTRelease ()", "%SYSBLDUSER%", 0, "grant execute on function BDTRelease () 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, "BDTRelease ()", "%SYSBLDUSER%", 5, "BDTRelease ()", "%SYSBLDUSER%" ); 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, "BDTTrace (lvarchar)", "%SYSBLDUSER%", 0, "create function BDTTrace (lvarchar) returns lvarchar external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(BDTTrace)"" language c; ", "f", "drop function BDTTrace (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-BDTTrace (lvarchar)", "%SYSBLDUSER%", 0, "alter function BDTTrace (lvarchar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(BDTTrace)""); ", "f", "alter function BDTTrace (lvarchar) with (Modify External Name = ""BDTTrace""); ", "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-BDTTrace (lvarchar)", "%SYSBLDUSER%", 5, "BDTTrace (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%", 55, "Alter-HandleNul-BDTTrace (lvarchar)", "%SYSBLDUSER%", 0, "alter function BDTTrace (lvarchar) with (add handlesnulls); ", "f", "alter function BDTTrace (lvarchar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-BDTTrace (lvarchar)", "%SYSBLDUSER%", 5, "BDTTrace (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-BDTTrace (lvarchar)", "%SYSBLDUSER%", 0, "alter function BDTTrace (lvarchar) with (add not variant); ", "f", "alter function BDTTrace (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-BDTTrace (lvarchar)", "%SYSBLDUSER%", 5, "BDTTrace (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, "BDTTrace (lvarchar)", "%SYSBLDUSER%", 0, "grant execute on function BDTTrace (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, "BDTTrace (lvarchar)", "%SYSBLDUSER%", 5, "BDTTrace (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, "octet_length (binaryvar)", "%SYSBLDUSER%", 0, "create function octet_length (binaryvar) returns int external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_binlength)"" language c; ", "f", "drop function octet_length (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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-octet_length (binaryvar)", "%SYSBLDUSER%", 0, "alter function octet_length (binaryvar) with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/binaryudt.bld(binaryvar_binlength)""); ", "f", "alter function octet_length (binaryvar) with (Modify External Name = ""binaryvar_binlength""); ", "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-octet_length (binaryvar)", "%SYSBLDUSER%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-octet_length (binaryvar)", "%SYSBLDUSER%", 0, "alter function octet_length (binaryvar) with (add parallelizable); ", "f", "alter function octet_length (binaryvar) with (drop parallelizable); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 37, "Alter-Parallelize-octet_length (binaryvar)", "%SYSBLDUSER%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-octet_length (binaryvar)", "%SYSBLDUSER%", 0, "alter function octet_length (binaryvar) with (add handlesnulls); ", "f", "alter function octet_length (binaryvar) with (drop handlesnulls); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 55, "Alter-HandleNul-octet_length (binaryvar)", "%SYSBLDUSER%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%" ); 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-octet_length (binaryvar)", "%SYSBLDUSER%", 0, "alter function octet_length (binaryvar) with (add not variant); ", "f", "alter function octet_length (binaryvar) 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-octet_length (binaryvar)", "%SYSBLDUSER%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%" ); 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, "octet_length (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function octet_length (binaryvar) 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, "octet_length (binaryvar)", "%SYSBLDUSER%", 5, "octet_length (binaryvar)", "%SYSBLDUSER%" ); 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, "binary18Cast (binaryvar)", "%SYSBLDUSER%", 0, "create function binary18Cast (Argument1 binaryvar) returns binary18 RETURN CAST(CAST(Argument1 AS LVARCHAR) AS binary18); end function; ", "f", "drop function binary18Cast (binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18Cast (binaryvar)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binary18Cast (binaryvar)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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, "binary18Cast (binaryvar)", "%SYSBLDUSER%", 0, "grant execute on function binary18Cast (binaryvar) 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, "binary18Cast (binaryvar)", "%SYSBLDUSER%", 5, "binary18Cast (binaryvar)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binaryvar->binary18", "%SYSBLDUSER%", 0, "create implicit cast ( binaryvar as binary18 with binary18Cast ); ", "f", "drop cast (binaryvar as binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->binary18", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binaryvar->binary18", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarCast (binary18)", "%SYSBLDUSER%", 0, "create function binaryvarCast (Argument1 binary18) returns binaryvar RETURN CAST(CAST(Argument1 AS LVARCHAR) AS binaryvar); end function; ", "f", "drop function binaryvarCast (binary18); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarCast (binary18)", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 5, "binaryvarCast (binary18)", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); 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, "binaryvarCast (binary18)", "%SYSBLDUSER%", 0, "grant execute on function binaryvarCast (binary18) 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, "binaryvarCast (binary18)", "%SYSBLDUSER%", 5, "binaryvarCast (binary18)", "%SYSBLDUSER%" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 3, "binary18->binaryvar", "%SYSBLDUSER%", 0, "create implicit cast ( binary18 as binaryvar with binaryvarCast ); ", "f", "drop cast (binary18 as binaryvar); ", "f" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->binaryvar", "%SYSBLDUSER%", 7, "binaryvar", "%SYSBLDUSER%" ); insert into sysbldobjdepends ( bld_id, obj_kind, obj_signature, obj_owner, need_obj_kind, need_obj_signature, need_obj_owner) values ( "%SYSBLDNAME%", 3, "binary18->binaryvar", "%SYSBLDUSER%", 7, "binary18", "%SYSBLDUSER%" ); 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" );