objects.sql 105 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461446244634464446544664467446844694470447144724473447444754476447744784479448044814482448344844485448644874488448944904491449244934494449544964497449844994500450145024503450445054506450745084509451045114512451345144515451645174518451945204521452245234524452545264527452845294530453145324533453445354536453745384539454045414542454345444545454645474548454945504551455245534554455545564557455845594560456145624563456445654566456745684569457045714572457345744575457645774578457945804581458245834584458545864587458845894590459145924593459445954596459745984599460046014602460346044605460646074608460946104611461246134614461546164617461846194620462146224623462446254626462746284629463046314632463346344635463646374638463946404641464246434644464546464647464846494650465146524653465446554656465746584659466046614662466346644665466646674668466946704671467246734674467546764677467846794680468146824683468446854686468746884689469046914692469346944695469646974698469947004701470247034704470547064707470847094710471147124713471447154716471747184719472047214722472347244725472647274728472947304731473247334734473547364737473847394740474147424743474447454746474747484749475047514752475347544755475647574758475947604761476247634764476547664767476847694770477147724773477447754776477747784779478047814782478347844785478647874788478947904791479247934794479547964797479847994800480148024803480448054806480748084809481048114812481348144815481648174818481948204821482248234824482548264827482848294830483148324833483448354836483748384839484048414842484348444845484648474848484948504851485248534854485548564857485848594860486148624863486448654866486748684869487048714872487348744875487648774878487948804881488248834884488548864887488848894890489148924893489448954896489748984899490049014902490349044905490649074908490949104911491249134914491549164917491849194920492149224923492449254926492749284929493049314932493349344935493649374938493949404941494249434944494549464947494849494950495149524953495449554956495749584959496049614962496349644965496649674968496949704971497249734974497549764977497849794980498149824983498449854986498749884989499049914992499349944995499649974998499950005001500250035004500550065007500850095010501150125013501450155016501750185019502050215022502350245025502650275028502950305031503250335034503550365037503850395040504150425043504450455046504750485049505050515052505350545055505650575058505950605061506250635064506550665067506850695070507150725073507450755076507750785079508050815082508350845085508650875088508950905091509250935094509550965097509850995100510151025103510451055106510751085109511051115112511351145115511651175118511951205121512251235124512551265127512851295130513151325133513451355136513751385139514051415142514351445145514651475148514951505151515251535154515551565157515851595160516151625163516451655166516751685169517051715172517351745175517651775178517951805181518251835184518551865187518851895190519151925193519451955196519751985199520052015202520352045205520652075208520952105211521252135214521552165217521852195220522152225223522452255226522752285229523052315232523352345235523652375238523952405241524252435244524552465247524852495250525152525253525452555256525752585259526052615262526352645265526652675268526952705271527252735274527552765277527852795280528152825283528452855286528752885289529052915292529352945295529652975298529953005301530253035304530553065307530853095310531153125313531453155316531753185319532053215322532353245325532653275328532953305331533253335334533553365337533853395340534153425343534453455346534753485349535053515352535353545355535653575358535953605361536253635364536553665367536853695370537153725373537453755376537753785379538053815382538353845385538653875388538953905391539253935394539553965397539853995400540154025403540454055406540754085409541054115412541354145415541654175418541954205421542254235424542554265427542854295430543154325433543454355436543754385439544054415442544354445445544654475448544954505451545254535454545554565457545854595460546154625463546454655466546754685469547054715472547354745475547654775478547954805481548254835484548554865487548854895490549154925493549454955496549754985499550055015502550355045505550655075508550955105511551255135514551555165517551855195520552155225523552455255526552755285529553055315532553355345535553655375538553955405541554255435544554555465547554855495550555155525553555455555556555755585559556055615562556355645565556655675568556955705571557255735574557555765577557855795580558155825583558455855586558755885589559055915592559355945595559655975598559956005601560256035604560556065607560856095610561156125613561456155616561756185619562056215622562356245625562656275628562956305631563256335634563556365637563856395640564156425643564456455646564756485649565056515652565356545655565656575658565956605661566256635664566556665667566856695670567156725673567456755676567756785679568056815682568356845685568656875688568956905691569256935694569556965697569856995700570157025703570457055706570757085709571057115712571357145715571657175718571957205721572257235724572557265727572857295730573157325733573457355736573757385739574057415742574357445745574657475748574957505751575257535754575557565757575857595760576157625763576457655766576757685769577057715772577357745775577657775778577957805781578257835784578557865787578857895790579157925793579457955796579757985799580058015802580358045805580658075808580958105811581258135814581558165817581858195820582158225823582458255826582758285829583058315832583358345835583658375838583958405841584258435844584558465847584858495850585158525853585458555856585758585859586058615862586358645865586658675868586958705871587258735874587558765877587858795880588158825883588458855886588758885889589058915892589358945895589658975898589959005901590259035904590559065907590859095910591159125913591459155916591759185919592059215922592359245925592659275928592959305931593259335934593559365937593859395940594159425943594459455946594759485949595059515952595359545955595659575958595959605961596259635964596559665967596859695970597159725973597459755976597759785979598059815982598359845985598659875988598959905991599259935994599559965997599859996000600160026003600460056006600760086009601060116012601360146015601660176018601960206021602260236024602560266027602860296030603160326033603460356036603760386039
  1. -- Generated by BladeSmith 4.00.TC6 DO NOT MODIFY. --
  2. execute procedure ifx_allow_newline('t');
  3. insert into sysbldobjects
  4. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5. create_can_fail, drop_sql, drop_can_fail)
  6. values
  7. (
  8. "%SYSBLDNAME%", 7, "Node",
  9. "%SYSBLDUSER%", 0,
  10. "create opaque type Node(
  11. internallength = variable,
  12. maxlen = 256,
  13. alignment = 4
  14. );
  15. ",
  16. "f",
  17. "drop type Node restrict;
  18. ",
  19. "f"
  20. );
  21. insert into sysbldobjects
  22. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  23. create_can_fail, drop_sql, drop_can_fail)
  24. values
  25. (
  26. "%SYSBLDNAME%", 71, "Node",
  27. "%SYSBLDUSER%", 0,
  28. "grant usage on type Node to public;
  29. ",
  30. "f",
  31. "",
  32. "f"
  33. );
  34. insert into sysbldobjdepends
  35. (
  36. bld_id,
  37. obj_kind,
  38. obj_signature,
  39. obj_owner,
  40. need_obj_kind,
  41. need_obj_signature,
  42. need_obj_owner)
  43. values
  44. (
  45. "%SYSBLDNAME%",
  46. 71, "Node",
  47. "%SYSBLDUSER%",
  48. 7, "Node",
  49. "%SYSBLDUSER%"
  50. );
  51. insert into sysbldobjects
  52. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  53. create_can_fail, drop_sql, drop_can_fail)
  54. values
  55. (
  56. "%SYSBLDNAME%", 5, "NodeIn (lvarchar)",
  57. "%SYSBLDUSER%", 0,
  58. "create function NodeIn (lvarchar)
  59. returns Node
  60. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeInput)"" language c;
  61. ",
  62. "f",
  63. "drop function NodeIn (lvarchar);
  64. ",
  65. "f"
  66. );
  67. insert into sysbldobjdepends
  68. (
  69. bld_id,
  70. obj_kind,
  71. obj_signature,
  72. obj_owner,
  73. need_obj_kind,
  74. need_obj_signature,
  75. need_obj_owner)
  76. values
  77. (
  78. "%SYSBLDNAME%",
  79. 5, "NodeIn (lvarchar)",
  80. "%SYSBLDUSER%",
  81. 7, "Node",
  82. "%SYSBLDUSER%"
  83. );
  84. insert into sysbldobjects
  85. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  86. create_can_fail, drop_sql, drop_can_fail)
  87. values
  88. (
  89. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeIn (lvarchar)",
  90. "%SYSBLDUSER%", 0,
  91. "alter function NodeIn (lvarchar)
  92. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeInput)"");
  93. ",
  94. "f",
  95. "alter function NodeIn (lvarchar)
  96. with (Modify External Name = ""NodeInput"");
  97. ",
  98. "f"
  99. );
  100. insert into sysbldobjdepends
  101. (
  102. bld_id,
  103. obj_kind,
  104. obj_signature,
  105. obj_owner,
  106. need_obj_kind,
  107. need_obj_signature,
  108. need_obj_owner)
  109. values
  110. (
  111. "%SYSBLDNAME%",
  112. 181, "Alter-ExternalName-NodeIn (lvarchar)",
  113. "%SYSBLDUSER%",
  114. 5, "NodeIn (lvarchar)",
  115. "%SYSBLDUSER%"
  116. );
  117. insert into sysbldobjects
  118. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  119. create_can_fail, drop_sql, drop_can_fail)
  120. values
  121. (
  122. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeIn (lvarchar)",
  123. "%SYSBLDUSER%", 0,
  124. "alter function NodeIn (lvarchar)
  125. with (add parallelizable);
  126. ",
  127. "f",
  128. "alter function NodeIn (lvarchar)
  129. with (drop parallelizable);
  130. ",
  131. "f"
  132. );
  133. insert into sysbldobjdepends
  134. (
  135. bld_id,
  136. obj_kind,
  137. obj_signature,
  138. obj_owner,
  139. need_obj_kind,
  140. need_obj_signature,
  141. need_obj_owner)
  142. values
  143. (
  144. "%SYSBLDNAME%",
  145. 37, "Alter-Parallelize-NodeIn (lvarchar)",
  146. "%SYSBLDUSER%",
  147. 5, "NodeIn (lvarchar)",
  148. "%SYSBLDUSER%"
  149. );
  150. insert into sysbldobjects
  151. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  152. create_can_fail, drop_sql, drop_can_fail)
  153. values
  154. (
  155. "%SYSBLDNAME%", 85, "Alter-Variant-NodeIn (lvarchar)",
  156. "%SYSBLDUSER%", 0,
  157. "alter function NodeIn (lvarchar)
  158. with (add not variant);
  159. ",
  160. "f",
  161. "alter function NodeIn (lvarchar)
  162. with (drop not variant);
  163. ",
  164. "f"
  165. );
  166. insert into sysbldobjdepends
  167. (
  168. bld_id,
  169. obj_kind,
  170. obj_signature,
  171. obj_owner,
  172. need_obj_kind,
  173. need_obj_signature,
  174. need_obj_owner)
  175. values
  176. (
  177. "%SYSBLDNAME%",
  178. 85, "Alter-Variant-NodeIn (lvarchar)",
  179. "%SYSBLDUSER%",
  180. 5, "NodeIn (lvarchar)",
  181. "%SYSBLDUSER%"
  182. );
  183. insert into sysbldobjects
  184. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  185. create_can_fail, drop_sql, drop_can_fail)
  186. values
  187. (
  188. "%SYSBLDNAME%", 69, "NodeIn (lvarchar)",
  189. "%SYSBLDUSER%", 0,
  190. "grant execute on function NodeIn (lvarchar) to public;
  191. ",
  192. "f",
  193. "",
  194. "f"
  195. );
  196. insert into sysbldobjdepends
  197. (
  198. bld_id,
  199. obj_kind,
  200. obj_signature,
  201. obj_owner,
  202. need_obj_kind,
  203. need_obj_signature,
  204. need_obj_owner)
  205. values
  206. (
  207. "%SYSBLDNAME%",
  208. 69, "NodeIn (lvarchar)",
  209. "%SYSBLDUSER%",
  210. 5, "NodeIn (lvarchar)",
  211. "%SYSBLDUSER%"
  212. );
  213. insert into sysbldobjects
  214. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  215. create_can_fail, drop_sql, drop_can_fail)
  216. values
  217. (
  218. "%SYSBLDNAME%", 3, "lvarchar->Node",
  219. "%SYSBLDUSER%", 0,
  220. "create implicit cast
  221. (
  222. lvarchar as Node
  223. with NodeIn
  224. );
  225. ",
  226. "f",
  227. "drop cast (lvarchar as Node);
  228. ",
  229. "f"
  230. );
  231. insert into sysbldobjdepends
  232. (
  233. bld_id,
  234. obj_kind,
  235. obj_signature,
  236. obj_owner,
  237. need_obj_kind,
  238. need_obj_signature,
  239. need_obj_owner)
  240. values
  241. (
  242. "%SYSBLDNAME%",
  243. 3, "lvarchar->Node",
  244. "%SYSBLDUSER%",
  245. 7, "Node",
  246. "%SYSBLDUSER%"
  247. );
  248. insert into sysbldobjects
  249. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  250. create_can_fail, drop_sql, drop_can_fail)
  251. values
  252. (
  253. "%SYSBLDNAME%", 5, "NodeOut (Node)",
  254. "%SYSBLDUSER%", 0,
  255. "create function NodeOut (Node)
  256. returns lvarchar
  257. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeOutput)"" language c;
  258. ",
  259. "f",
  260. "drop function NodeOut (Node);
  261. ",
  262. "f"
  263. );
  264. insert into sysbldobjdepends
  265. (
  266. bld_id,
  267. obj_kind,
  268. obj_signature,
  269. obj_owner,
  270. need_obj_kind,
  271. need_obj_signature,
  272. need_obj_owner)
  273. values
  274. (
  275. "%SYSBLDNAME%",
  276. 5, "NodeOut (Node)",
  277. "%SYSBLDUSER%",
  278. 7, "Node",
  279. "%SYSBLDUSER%"
  280. );
  281. insert into sysbldobjects
  282. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  283. create_can_fail, drop_sql, drop_can_fail)
  284. values
  285. (
  286. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeOut (Node)",
  287. "%SYSBLDUSER%", 0,
  288. "alter function NodeOut (Node)
  289. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeOutput)"");
  290. ",
  291. "f",
  292. "alter function NodeOut (Node)
  293. with (Modify External Name = ""NodeOutput"");
  294. ",
  295. "f"
  296. );
  297. insert into sysbldobjdepends
  298. (
  299. bld_id,
  300. obj_kind,
  301. obj_signature,
  302. obj_owner,
  303. need_obj_kind,
  304. need_obj_signature,
  305. need_obj_owner)
  306. values
  307. (
  308. "%SYSBLDNAME%",
  309. 181, "Alter-ExternalName-NodeOut (Node)",
  310. "%SYSBLDUSER%",
  311. 5, "NodeOut (Node)",
  312. "%SYSBLDUSER%"
  313. );
  314. insert into sysbldobjects
  315. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  316. create_can_fail, drop_sql, drop_can_fail)
  317. values
  318. (
  319. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeOut (Node)",
  320. "%SYSBLDUSER%", 0,
  321. "alter function NodeOut (Node)
  322. with (add parallelizable);
  323. ",
  324. "f",
  325. "alter function NodeOut (Node)
  326. with (drop parallelizable);
  327. ",
  328. "f"
  329. );
  330. insert into sysbldobjdepends
  331. (
  332. bld_id,
  333. obj_kind,
  334. obj_signature,
  335. obj_owner,
  336. need_obj_kind,
  337. need_obj_signature,
  338. need_obj_owner)
  339. values
  340. (
  341. "%SYSBLDNAME%",
  342. 37, "Alter-Parallelize-NodeOut (Node)",
  343. "%SYSBLDUSER%",
  344. 5, "NodeOut (Node)",
  345. "%SYSBLDUSER%"
  346. );
  347. insert into sysbldobjects
  348. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  349. create_can_fail, drop_sql, drop_can_fail)
  350. values
  351. (
  352. "%SYSBLDNAME%", 85, "Alter-Variant-NodeOut (Node)",
  353. "%SYSBLDUSER%", 0,
  354. "alter function NodeOut (Node)
  355. with (add not variant);
  356. ",
  357. "f",
  358. "alter function NodeOut (Node)
  359. with (drop not variant);
  360. ",
  361. "f"
  362. );
  363. insert into sysbldobjdepends
  364. (
  365. bld_id,
  366. obj_kind,
  367. obj_signature,
  368. obj_owner,
  369. need_obj_kind,
  370. need_obj_signature,
  371. need_obj_owner)
  372. values
  373. (
  374. "%SYSBLDNAME%",
  375. 85, "Alter-Variant-NodeOut (Node)",
  376. "%SYSBLDUSER%",
  377. 5, "NodeOut (Node)",
  378. "%SYSBLDUSER%"
  379. );
  380. insert into sysbldobjects
  381. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  382. create_can_fail, drop_sql, drop_can_fail)
  383. values
  384. (
  385. "%SYSBLDNAME%", 69, "NodeOut (Node)",
  386. "%SYSBLDUSER%", 0,
  387. "grant execute on function NodeOut (Node) to public;
  388. ",
  389. "f",
  390. "",
  391. "f"
  392. );
  393. insert into sysbldobjdepends
  394. (
  395. bld_id,
  396. obj_kind,
  397. obj_signature,
  398. obj_owner,
  399. need_obj_kind,
  400. need_obj_signature,
  401. need_obj_owner)
  402. values
  403. (
  404. "%SYSBLDNAME%",
  405. 69, "NodeOut (Node)",
  406. "%SYSBLDUSER%",
  407. 5, "NodeOut (Node)",
  408. "%SYSBLDUSER%"
  409. );
  410. insert into sysbldobjects
  411. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  412. create_can_fail, drop_sql, drop_can_fail)
  413. values
  414. (
  415. "%SYSBLDNAME%", 3, "Node->lvarchar",
  416. "%SYSBLDUSER%", 0,
  417. "create cast
  418. (
  419. Node as lvarchar
  420. with NodeOut
  421. );
  422. ",
  423. "f",
  424. "drop cast (Node as lvarchar);
  425. ",
  426. "f"
  427. );
  428. insert into sysbldobjdepends
  429. (
  430. bld_id,
  431. obj_kind,
  432. obj_signature,
  433. obj_owner,
  434. need_obj_kind,
  435. need_obj_signature,
  436. need_obj_owner)
  437. values
  438. (
  439. "%SYSBLDNAME%",
  440. 3, "Node->lvarchar",
  441. "%SYSBLDUSER%",
  442. 7, "Node",
  443. "%SYSBLDUSER%"
  444. );
  445. insert into sysbldobjects
  446. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  447. create_can_fail, drop_sql, drop_can_fail)
  448. values
  449. (
  450. "%SYSBLDNAME%", 5, "NodeSend (Node)",
  451. "%SYSBLDUSER%", 0,
  452. "create function NodeSend (Node)
  453. returns sendrecv
  454. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeSend)"" language c;
  455. ",
  456. "f",
  457. "drop function NodeSend (Node);
  458. ",
  459. "f"
  460. );
  461. insert into sysbldobjdepends
  462. (
  463. bld_id,
  464. obj_kind,
  465. obj_signature,
  466. obj_owner,
  467. need_obj_kind,
  468. need_obj_signature,
  469. need_obj_owner)
  470. values
  471. (
  472. "%SYSBLDNAME%",
  473. 5, "NodeSend (Node)",
  474. "%SYSBLDUSER%",
  475. 7, "Node",
  476. "%SYSBLDUSER%"
  477. );
  478. insert into sysbldobjects
  479. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  480. create_can_fail, drop_sql, drop_can_fail)
  481. values
  482. (
  483. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeSend (Node)",
  484. "%SYSBLDUSER%", 0,
  485. "alter function NodeSend (Node)
  486. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeSend)"");
  487. ",
  488. "f",
  489. "alter function NodeSend (Node)
  490. with (Modify External Name = ""NodeSend"");
  491. ",
  492. "f"
  493. );
  494. insert into sysbldobjdepends
  495. (
  496. bld_id,
  497. obj_kind,
  498. obj_signature,
  499. obj_owner,
  500. need_obj_kind,
  501. need_obj_signature,
  502. need_obj_owner)
  503. values
  504. (
  505. "%SYSBLDNAME%",
  506. 181, "Alter-ExternalName-NodeSend (Node)",
  507. "%SYSBLDUSER%",
  508. 5, "NodeSend (Node)",
  509. "%SYSBLDUSER%"
  510. );
  511. insert into sysbldobjects
  512. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  513. create_can_fail, drop_sql, drop_can_fail)
  514. values
  515. (
  516. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeSend (Node)",
  517. "%SYSBLDUSER%", 0,
  518. "alter function NodeSend (Node)
  519. with (add parallelizable);
  520. ",
  521. "f",
  522. "alter function NodeSend (Node)
  523. with (drop parallelizable);
  524. ",
  525. "f"
  526. );
  527. insert into sysbldobjdepends
  528. (
  529. bld_id,
  530. obj_kind,
  531. obj_signature,
  532. obj_owner,
  533. need_obj_kind,
  534. need_obj_signature,
  535. need_obj_owner)
  536. values
  537. (
  538. "%SYSBLDNAME%",
  539. 37, "Alter-Parallelize-NodeSend (Node)",
  540. "%SYSBLDUSER%",
  541. 5, "NodeSend (Node)",
  542. "%SYSBLDUSER%"
  543. );
  544. insert into sysbldobjects
  545. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  546. create_can_fail, drop_sql, drop_can_fail)
  547. values
  548. (
  549. "%SYSBLDNAME%", 85, "Alter-Variant-NodeSend (Node)",
  550. "%SYSBLDUSER%", 0,
  551. "alter function NodeSend (Node)
  552. with (add not variant);
  553. ",
  554. "f",
  555. "alter function NodeSend (Node)
  556. with (drop not variant);
  557. ",
  558. "f"
  559. );
  560. insert into sysbldobjdepends
  561. (
  562. bld_id,
  563. obj_kind,
  564. obj_signature,
  565. obj_owner,
  566. need_obj_kind,
  567. need_obj_signature,
  568. need_obj_owner)
  569. values
  570. (
  571. "%SYSBLDNAME%",
  572. 85, "Alter-Variant-NodeSend (Node)",
  573. "%SYSBLDUSER%",
  574. 5, "NodeSend (Node)",
  575. "%SYSBLDUSER%"
  576. );
  577. insert into sysbldobjects
  578. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  579. create_can_fail, drop_sql, drop_can_fail)
  580. values
  581. (
  582. "%SYSBLDNAME%", 69, "NodeSend (Node)",
  583. "%SYSBLDUSER%", 0,
  584. "grant execute on function NodeSend (Node) to public;
  585. ",
  586. "f",
  587. "",
  588. "f"
  589. );
  590. insert into sysbldobjdepends
  591. (
  592. bld_id,
  593. obj_kind,
  594. obj_signature,
  595. obj_owner,
  596. need_obj_kind,
  597. need_obj_signature,
  598. need_obj_owner)
  599. values
  600. (
  601. "%SYSBLDNAME%",
  602. 69, "NodeSend (Node)",
  603. "%SYSBLDUSER%",
  604. 5, "NodeSend (Node)",
  605. "%SYSBLDUSER%"
  606. );
  607. insert into sysbldobjects
  608. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  609. create_can_fail, drop_sql, drop_can_fail)
  610. values
  611. (
  612. "%SYSBLDNAME%", 3, "Node->sendrecv",
  613. "%SYSBLDUSER%", 0,
  614. "create cast
  615. (
  616. Node as sendrecv
  617. with NodeSend
  618. );
  619. ",
  620. "f",
  621. "drop cast (Node as sendrecv);
  622. ",
  623. "f"
  624. );
  625. insert into sysbldobjdepends
  626. (
  627. bld_id,
  628. obj_kind,
  629. obj_signature,
  630. obj_owner,
  631. need_obj_kind,
  632. need_obj_signature,
  633. need_obj_owner)
  634. values
  635. (
  636. "%SYSBLDNAME%",
  637. 3, "Node->sendrecv",
  638. "%SYSBLDUSER%",
  639. 7, "Node",
  640. "%SYSBLDUSER%"
  641. );
  642. insert into sysbldobjects
  643. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  644. create_can_fail, drop_sql, drop_can_fail)
  645. values
  646. (
  647. "%SYSBLDNAME%", 5, "NodeRecv (sendrecv)",
  648. "%SYSBLDUSER%", 0,
  649. "create function NodeRecv (sendrecv)
  650. returns Node
  651. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeReceive)"" language c;
  652. ",
  653. "f",
  654. "drop function NodeRecv (sendrecv);
  655. ",
  656. "f"
  657. );
  658. insert into sysbldobjdepends
  659. (
  660. bld_id,
  661. obj_kind,
  662. obj_signature,
  663. obj_owner,
  664. need_obj_kind,
  665. need_obj_signature,
  666. need_obj_owner)
  667. values
  668. (
  669. "%SYSBLDNAME%",
  670. 5, "NodeRecv (sendrecv)",
  671. "%SYSBLDUSER%",
  672. 7, "Node",
  673. "%SYSBLDUSER%"
  674. );
  675. insert into sysbldobjects
  676. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  677. create_can_fail, drop_sql, drop_can_fail)
  678. values
  679. (
  680. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeRecv (sendrecv)",
  681. "%SYSBLDUSER%", 0,
  682. "alter function NodeRecv (sendrecv)
  683. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeReceive)"");
  684. ",
  685. "f",
  686. "alter function NodeRecv (sendrecv)
  687. with (Modify External Name = ""NodeReceive"");
  688. ",
  689. "f"
  690. );
  691. insert into sysbldobjdepends
  692. (
  693. bld_id,
  694. obj_kind,
  695. obj_signature,
  696. obj_owner,
  697. need_obj_kind,
  698. need_obj_signature,
  699. need_obj_owner)
  700. values
  701. (
  702. "%SYSBLDNAME%",
  703. 181, "Alter-ExternalName-NodeRecv (sendrecv)",
  704. "%SYSBLDUSER%",
  705. 5, "NodeRecv (sendrecv)",
  706. "%SYSBLDUSER%"
  707. );
  708. insert into sysbldobjects
  709. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  710. create_can_fail, drop_sql, drop_can_fail)
  711. values
  712. (
  713. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeRecv (sendrecv)",
  714. "%SYSBLDUSER%", 0,
  715. "alter function NodeRecv (sendrecv)
  716. with (add parallelizable);
  717. ",
  718. "f",
  719. "alter function NodeRecv (sendrecv)
  720. with (drop parallelizable);
  721. ",
  722. "f"
  723. );
  724. insert into sysbldobjdepends
  725. (
  726. bld_id,
  727. obj_kind,
  728. obj_signature,
  729. obj_owner,
  730. need_obj_kind,
  731. need_obj_signature,
  732. need_obj_owner)
  733. values
  734. (
  735. "%SYSBLDNAME%",
  736. 37, "Alter-Parallelize-NodeRecv (sendrecv)",
  737. "%SYSBLDUSER%",
  738. 5, "NodeRecv (sendrecv)",
  739. "%SYSBLDUSER%"
  740. );
  741. insert into sysbldobjects
  742. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  743. create_can_fail, drop_sql, drop_can_fail)
  744. values
  745. (
  746. "%SYSBLDNAME%", 85, "Alter-Variant-NodeRecv (sendrecv)",
  747. "%SYSBLDUSER%", 0,
  748. "alter function NodeRecv (sendrecv)
  749. with (add not variant);
  750. ",
  751. "f",
  752. "alter function NodeRecv (sendrecv)
  753. with (drop not variant);
  754. ",
  755. "f"
  756. );
  757. insert into sysbldobjdepends
  758. (
  759. bld_id,
  760. obj_kind,
  761. obj_signature,
  762. obj_owner,
  763. need_obj_kind,
  764. need_obj_signature,
  765. need_obj_owner)
  766. values
  767. (
  768. "%SYSBLDNAME%",
  769. 85, "Alter-Variant-NodeRecv (sendrecv)",
  770. "%SYSBLDUSER%",
  771. 5, "NodeRecv (sendrecv)",
  772. "%SYSBLDUSER%"
  773. );
  774. insert into sysbldobjects
  775. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  776. create_can_fail, drop_sql, drop_can_fail)
  777. values
  778. (
  779. "%SYSBLDNAME%", 69, "NodeRecv (sendrecv)",
  780. "%SYSBLDUSER%", 0,
  781. "grant execute on function NodeRecv (sendrecv) to public;
  782. ",
  783. "f",
  784. "",
  785. "f"
  786. );
  787. insert into sysbldobjdepends
  788. (
  789. bld_id,
  790. obj_kind,
  791. obj_signature,
  792. obj_owner,
  793. need_obj_kind,
  794. need_obj_signature,
  795. need_obj_owner)
  796. values
  797. (
  798. "%SYSBLDNAME%",
  799. 69, "NodeRecv (sendrecv)",
  800. "%SYSBLDUSER%",
  801. 5, "NodeRecv (sendrecv)",
  802. "%SYSBLDUSER%"
  803. );
  804. insert into sysbldobjects
  805. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  806. create_can_fail, drop_sql, drop_can_fail)
  807. values
  808. (
  809. "%SYSBLDNAME%", 3, "sendrecv->Node",
  810. "%SYSBLDUSER%", 0,
  811. "create implicit cast
  812. (
  813. sendrecv as Node
  814. with NodeRecv
  815. );
  816. ",
  817. "f",
  818. "drop cast (sendrecv as Node);
  819. ",
  820. "f"
  821. );
  822. insert into sysbldobjdepends
  823. (
  824. bld_id,
  825. obj_kind,
  826. obj_signature,
  827. obj_owner,
  828. need_obj_kind,
  829. need_obj_signature,
  830. need_obj_owner)
  831. values
  832. (
  833. "%SYSBLDNAME%",
  834. 3, "sendrecv->Node",
  835. "%SYSBLDUSER%",
  836. 7, "Node",
  837. "%SYSBLDUSER%"
  838. );
  839. insert into sysbldobjects
  840. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  841. create_can_fail, drop_sql, drop_can_fail)
  842. values
  843. (
  844. "%SYSBLDNAME%", 5, "NodeImpT (impexp)",
  845. "%SYSBLDUSER%", 0,
  846. "create function NodeImpT (impexp)
  847. returns Node
  848. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeImportText)"" language c;
  849. ",
  850. "f",
  851. "drop function NodeImpT (impexp);
  852. ",
  853. "f"
  854. );
  855. insert into sysbldobjdepends
  856. (
  857. bld_id,
  858. obj_kind,
  859. obj_signature,
  860. obj_owner,
  861. need_obj_kind,
  862. need_obj_signature,
  863. need_obj_owner)
  864. values
  865. (
  866. "%SYSBLDNAME%",
  867. 5, "NodeImpT (impexp)",
  868. "%SYSBLDUSER%",
  869. 7, "Node",
  870. "%SYSBLDUSER%"
  871. );
  872. insert into sysbldobjects
  873. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  874. create_can_fail, drop_sql, drop_can_fail)
  875. values
  876. (
  877. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeImpT (impexp)",
  878. "%SYSBLDUSER%", 0,
  879. "alter function NodeImpT (impexp)
  880. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeImportText)"");
  881. ",
  882. "f",
  883. "alter function NodeImpT (impexp)
  884. with (Modify External Name = ""NodeImportText"");
  885. ",
  886. "f"
  887. );
  888. insert into sysbldobjdepends
  889. (
  890. bld_id,
  891. obj_kind,
  892. obj_signature,
  893. obj_owner,
  894. need_obj_kind,
  895. need_obj_signature,
  896. need_obj_owner)
  897. values
  898. (
  899. "%SYSBLDNAME%",
  900. 181, "Alter-ExternalName-NodeImpT (impexp)",
  901. "%SYSBLDUSER%",
  902. 5, "NodeImpT (impexp)",
  903. "%SYSBLDUSER%"
  904. );
  905. insert into sysbldobjects
  906. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  907. create_can_fail, drop_sql, drop_can_fail)
  908. values
  909. (
  910. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeImpT (impexp)",
  911. "%SYSBLDUSER%", 0,
  912. "alter function NodeImpT (impexp)
  913. with (add parallelizable);
  914. ",
  915. "f",
  916. "alter function NodeImpT (impexp)
  917. with (drop parallelizable);
  918. ",
  919. "f"
  920. );
  921. insert into sysbldobjdepends
  922. (
  923. bld_id,
  924. obj_kind,
  925. obj_signature,
  926. obj_owner,
  927. need_obj_kind,
  928. need_obj_signature,
  929. need_obj_owner)
  930. values
  931. (
  932. "%SYSBLDNAME%",
  933. 37, "Alter-Parallelize-NodeImpT (impexp)",
  934. "%SYSBLDUSER%",
  935. 5, "NodeImpT (impexp)",
  936. "%SYSBLDUSER%"
  937. );
  938. insert into sysbldobjects
  939. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  940. create_can_fail, drop_sql, drop_can_fail)
  941. values
  942. (
  943. "%SYSBLDNAME%", 85, "Alter-Variant-NodeImpT (impexp)",
  944. "%SYSBLDUSER%", 0,
  945. "alter function NodeImpT (impexp)
  946. with (add not variant);
  947. ",
  948. "f",
  949. "alter function NodeImpT (impexp)
  950. with (drop not variant);
  951. ",
  952. "f"
  953. );
  954. insert into sysbldobjdepends
  955. (
  956. bld_id,
  957. obj_kind,
  958. obj_signature,
  959. obj_owner,
  960. need_obj_kind,
  961. need_obj_signature,
  962. need_obj_owner)
  963. values
  964. (
  965. "%SYSBLDNAME%",
  966. 85, "Alter-Variant-NodeImpT (impexp)",
  967. "%SYSBLDUSER%",
  968. 5, "NodeImpT (impexp)",
  969. "%SYSBLDUSER%"
  970. );
  971. insert into sysbldobjects
  972. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  973. create_can_fail, drop_sql, drop_can_fail)
  974. values
  975. (
  976. "%SYSBLDNAME%", 69, "NodeImpT (impexp)",
  977. "%SYSBLDUSER%", 0,
  978. "grant execute on function NodeImpT (impexp) to public;
  979. ",
  980. "f",
  981. "",
  982. "f"
  983. );
  984. insert into sysbldobjdepends
  985. (
  986. bld_id,
  987. obj_kind,
  988. obj_signature,
  989. obj_owner,
  990. need_obj_kind,
  991. need_obj_signature,
  992. need_obj_owner)
  993. values
  994. (
  995. "%SYSBLDNAME%",
  996. 69, "NodeImpT (impexp)",
  997. "%SYSBLDUSER%",
  998. 5, "NodeImpT (impexp)",
  999. "%SYSBLDUSER%"
  1000. );
  1001. insert into sysbldobjects
  1002. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1003. create_can_fail, drop_sql, drop_can_fail)
  1004. values
  1005. (
  1006. "%SYSBLDNAME%", 3, "impexp->Node",
  1007. "%SYSBLDUSER%", 0,
  1008. "create implicit cast
  1009. (
  1010. impexp as Node
  1011. with NodeImpT
  1012. );
  1013. ",
  1014. "f",
  1015. "drop cast (impexp as Node);
  1016. ",
  1017. "f"
  1018. );
  1019. insert into sysbldobjdepends
  1020. (
  1021. bld_id,
  1022. obj_kind,
  1023. obj_signature,
  1024. obj_owner,
  1025. need_obj_kind,
  1026. need_obj_signature,
  1027. need_obj_owner)
  1028. values
  1029. (
  1030. "%SYSBLDNAME%",
  1031. 3, "impexp->Node",
  1032. "%SYSBLDUSER%",
  1033. 7, "Node",
  1034. "%SYSBLDUSER%"
  1035. );
  1036. insert into sysbldobjects
  1037. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1038. create_can_fail, drop_sql, drop_can_fail)
  1039. values
  1040. (
  1041. "%SYSBLDNAME%", 5, "NodeExpT (Node)",
  1042. "%SYSBLDUSER%", 0,
  1043. "create function NodeExpT (Node)
  1044. returns impexp
  1045. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeExportText)"" language c;
  1046. ",
  1047. "f",
  1048. "drop function NodeExpT (Node);
  1049. ",
  1050. "f"
  1051. );
  1052. insert into sysbldobjdepends
  1053. (
  1054. bld_id,
  1055. obj_kind,
  1056. obj_signature,
  1057. obj_owner,
  1058. need_obj_kind,
  1059. need_obj_signature,
  1060. need_obj_owner)
  1061. values
  1062. (
  1063. "%SYSBLDNAME%",
  1064. 5, "NodeExpT (Node)",
  1065. "%SYSBLDUSER%",
  1066. 7, "Node",
  1067. "%SYSBLDUSER%"
  1068. );
  1069. insert into sysbldobjects
  1070. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1071. create_can_fail, drop_sql, drop_can_fail)
  1072. values
  1073. (
  1074. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeExpT (Node)",
  1075. "%SYSBLDUSER%", 0,
  1076. "alter function NodeExpT (Node)
  1077. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeExportText)"");
  1078. ",
  1079. "f",
  1080. "alter function NodeExpT (Node)
  1081. with (Modify External Name = ""NodeExportText"");
  1082. ",
  1083. "f"
  1084. );
  1085. insert into sysbldobjdepends
  1086. (
  1087. bld_id,
  1088. obj_kind,
  1089. obj_signature,
  1090. obj_owner,
  1091. need_obj_kind,
  1092. need_obj_signature,
  1093. need_obj_owner)
  1094. values
  1095. (
  1096. "%SYSBLDNAME%",
  1097. 181, "Alter-ExternalName-NodeExpT (Node)",
  1098. "%SYSBLDUSER%",
  1099. 5, "NodeExpT (Node)",
  1100. "%SYSBLDUSER%"
  1101. );
  1102. insert into sysbldobjects
  1103. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1104. create_can_fail, drop_sql, drop_can_fail)
  1105. values
  1106. (
  1107. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeExpT (Node)",
  1108. "%SYSBLDUSER%", 0,
  1109. "alter function NodeExpT (Node)
  1110. with (add parallelizable);
  1111. ",
  1112. "f",
  1113. "alter function NodeExpT (Node)
  1114. with (drop parallelizable);
  1115. ",
  1116. "f"
  1117. );
  1118. insert into sysbldobjdepends
  1119. (
  1120. bld_id,
  1121. obj_kind,
  1122. obj_signature,
  1123. obj_owner,
  1124. need_obj_kind,
  1125. need_obj_signature,
  1126. need_obj_owner)
  1127. values
  1128. (
  1129. "%SYSBLDNAME%",
  1130. 37, "Alter-Parallelize-NodeExpT (Node)",
  1131. "%SYSBLDUSER%",
  1132. 5, "NodeExpT (Node)",
  1133. "%SYSBLDUSER%"
  1134. );
  1135. insert into sysbldobjects
  1136. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1137. create_can_fail, drop_sql, drop_can_fail)
  1138. values
  1139. (
  1140. "%SYSBLDNAME%", 85, "Alter-Variant-NodeExpT (Node)",
  1141. "%SYSBLDUSER%", 0,
  1142. "alter function NodeExpT (Node)
  1143. with (add not variant);
  1144. ",
  1145. "f",
  1146. "alter function NodeExpT (Node)
  1147. with (drop not variant);
  1148. ",
  1149. "f"
  1150. );
  1151. insert into sysbldobjdepends
  1152. (
  1153. bld_id,
  1154. obj_kind,
  1155. obj_signature,
  1156. obj_owner,
  1157. need_obj_kind,
  1158. need_obj_signature,
  1159. need_obj_owner)
  1160. values
  1161. (
  1162. "%SYSBLDNAME%",
  1163. 85, "Alter-Variant-NodeExpT (Node)",
  1164. "%SYSBLDUSER%",
  1165. 5, "NodeExpT (Node)",
  1166. "%SYSBLDUSER%"
  1167. );
  1168. insert into sysbldobjects
  1169. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1170. create_can_fail, drop_sql, drop_can_fail)
  1171. values
  1172. (
  1173. "%SYSBLDNAME%", 69, "NodeExpT (Node)",
  1174. "%SYSBLDUSER%", 0,
  1175. "grant execute on function NodeExpT (Node) to public;
  1176. ",
  1177. "f",
  1178. "",
  1179. "f"
  1180. );
  1181. insert into sysbldobjdepends
  1182. (
  1183. bld_id,
  1184. obj_kind,
  1185. obj_signature,
  1186. obj_owner,
  1187. need_obj_kind,
  1188. need_obj_signature,
  1189. need_obj_owner)
  1190. values
  1191. (
  1192. "%SYSBLDNAME%",
  1193. 69, "NodeExpT (Node)",
  1194. "%SYSBLDUSER%",
  1195. 5, "NodeExpT (Node)",
  1196. "%SYSBLDUSER%"
  1197. );
  1198. insert into sysbldobjects
  1199. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1200. create_can_fail, drop_sql, drop_can_fail)
  1201. values
  1202. (
  1203. "%SYSBLDNAME%", 3, "Node->impexp",
  1204. "%SYSBLDUSER%", 0,
  1205. "create cast
  1206. (
  1207. Node as impexp
  1208. with NodeExpT
  1209. );
  1210. ",
  1211. "f",
  1212. "drop cast (Node as impexp);
  1213. ",
  1214. "f"
  1215. );
  1216. insert into sysbldobjdepends
  1217. (
  1218. bld_id,
  1219. obj_kind,
  1220. obj_signature,
  1221. obj_owner,
  1222. need_obj_kind,
  1223. need_obj_signature,
  1224. need_obj_owner)
  1225. values
  1226. (
  1227. "%SYSBLDNAME%",
  1228. 3, "Node->impexp",
  1229. "%SYSBLDUSER%",
  1230. 7, "Node",
  1231. "%SYSBLDUSER%"
  1232. );
  1233. insert into sysbldobjects
  1234. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1235. create_can_fail, drop_sql, drop_can_fail)
  1236. values
  1237. (
  1238. "%SYSBLDNAME%", 5, "NodeImpB (impexpbin)",
  1239. "%SYSBLDUSER%", 0,
  1240. "create function NodeImpB (impexpbin)
  1241. returns Node
  1242. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeImportBinary)"" language c;
  1243. ",
  1244. "f",
  1245. "drop function NodeImpB (impexpbin);
  1246. ",
  1247. "f"
  1248. );
  1249. insert into sysbldobjdepends
  1250. (
  1251. bld_id,
  1252. obj_kind,
  1253. obj_signature,
  1254. obj_owner,
  1255. need_obj_kind,
  1256. need_obj_signature,
  1257. need_obj_owner)
  1258. values
  1259. (
  1260. "%SYSBLDNAME%",
  1261. 5, "NodeImpB (impexpbin)",
  1262. "%SYSBLDUSER%",
  1263. 7, "Node",
  1264. "%SYSBLDUSER%"
  1265. );
  1266. insert into sysbldobjects
  1267. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1268. create_can_fail, drop_sql, drop_can_fail)
  1269. values
  1270. (
  1271. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeImpB (impexpbin)",
  1272. "%SYSBLDUSER%", 0,
  1273. "alter function NodeImpB (impexpbin)
  1274. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeImportBinary)"");
  1275. ",
  1276. "f",
  1277. "alter function NodeImpB (impexpbin)
  1278. with (Modify External Name = ""NodeImportBinary"");
  1279. ",
  1280. "f"
  1281. );
  1282. insert into sysbldobjdepends
  1283. (
  1284. bld_id,
  1285. obj_kind,
  1286. obj_signature,
  1287. obj_owner,
  1288. need_obj_kind,
  1289. need_obj_signature,
  1290. need_obj_owner)
  1291. values
  1292. (
  1293. "%SYSBLDNAME%",
  1294. 181, "Alter-ExternalName-NodeImpB (impexpbin)",
  1295. "%SYSBLDUSER%",
  1296. 5, "NodeImpB (impexpbin)",
  1297. "%SYSBLDUSER%"
  1298. );
  1299. insert into sysbldobjects
  1300. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1301. create_can_fail, drop_sql, drop_can_fail)
  1302. values
  1303. (
  1304. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeImpB (impexpbin)",
  1305. "%SYSBLDUSER%", 0,
  1306. "alter function NodeImpB (impexpbin)
  1307. with (add parallelizable);
  1308. ",
  1309. "f",
  1310. "alter function NodeImpB (impexpbin)
  1311. with (drop parallelizable);
  1312. ",
  1313. "f"
  1314. );
  1315. insert into sysbldobjdepends
  1316. (
  1317. bld_id,
  1318. obj_kind,
  1319. obj_signature,
  1320. obj_owner,
  1321. need_obj_kind,
  1322. need_obj_signature,
  1323. need_obj_owner)
  1324. values
  1325. (
  1326. "%SYSBLDNAME%",
  1327. 37, "Alter-Parallelize-NodeImpB (impexpbin)",
  1328. "%SYSBLDUSER%",
  1329. 5, "NodeImpB (impexpbin)",
  1330. "%SYSBLDUSER%"
  1331. );
  1332. insert into sysbldobjects
  1333. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1334. create_can_fail, drop_sql, drop_can_fail)
  1335. values
  1336. (
  1337. "%SYSBLDNAME%", 85, "Alter-Variant-NodeImpB (impexpbin)",
  1338. "%SYSBLDUSER%", 0,
  1339. "alter function NodeImpB (impexpbin)
  1340. with (add not variant);
  1341. ",
  1342. "f",
  1343. "alter function NodeImpB (impexpbin)
  1344. with (drop not variant);
  1345. ",
  1346. "f"
  1347. );
  1348. insert into sysbldobjdepends
  1349. (
  1350. bld_id,
  1351. obj_kind,
  1352. obj_signature,
  1353. obj_owner,
  1354. need_obj_kind,
  1355. need_obj_signature,
  1356. need_obj_owner)
  1357. values
  1358. (
  1359. "%SYSBLDNAME%",
  1360. 85, "Alter-Variant-NodeImpB (impexpbin)",
  1361. "%SYSBLDUSER%",
  1362. 5, "NodeImpB (impexpbin)",
  1363. "%SYSBLDUSER%"
  1364. );
  1365. insert into sysbldobjects
  1366. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1367. create_can_fail, drop_sql, drop_can_fail)
  1368. values
  1369. (
  1370. "%SYSBLDNAME%", 69, "NodeImpB (impexpbin)",
  1371. "%SYSBLDUSER%", 0,
  1372. "grant execute on function NodeImpB (impexpbin) to public;
  1373. ",
  1374. "f",
  1375. "",
  1376. "f"
  1377. );
  1378. insert into sysbldobjdepends
  1379. (
  1380. bld_id,
  1381. obj_kind,
  1382. obj_signature,
  1383. obj_owner,
  1384. need_obj_kind,
  1385. need_obj_signature,
  1386. need_obj_owner)
  1387. values
  1388. (
  1389. "%SYSBLDNAME%",
  1390. 69, "NodeImpB (impexpbin)",
  1391. "%SYSBLDUSER%",
  1392. 5, "NodeImpB (impexpbin)",
  1393. "%SYSBLDUSER%"
  1394. );
  1395. insert into sysbldobjects
  1396. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1397. create_can_fail, drop_sql, drop_can_fail)
  1398. values
  1399. (
  1400. "%SYSBLDNAME%", 3, "impexpbin->Node",
  1401. "%SYSBLDUSER%", 0,
  1402. "create implicit cast
  1403. (
  1404. impexpbin as Node
  1405. with NodeImpB
  1406. );
  1407. ",
  1408. "f",
  1409. "drop cast (impexpbin as Node);
  1410. ",
  1411. "f"
  1412. );
  1413. insert into sysbldobjdepends
  1414. (
  1415. bld_id,
  1416. obj_kind,
  1417. obj_signature,
  1418. obj_owner,
  1419. need_obj_kind,
  1420. need_obj_signature,
  1421. need_obj_owner)
  1422. values
  1423. (
  1424. "%SYSBLDNAME%",
  1425. 3, "impexpbin->Node",
  1426. "%SYSBLDUSER%",
  1427. 7, "Node",
  1428. "%SYSBLDUSER%"
  1429. );
  1430. insert into sysbldobjects
  1431. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1432. create_can_fail, drop_sql, drop_can_fail)
  1433. values
  1434. (
  1435. "%SYSBLDNAME%", 5, "NodeExpB (Node)",
  1436. "%SYSBLDUSER%", 0,
  1437. "create function NodeExpB (Node)
  1438. returns impexpbin
  1439. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeExportBinary)"" language c;
  1440. ",
  1441. "f",
  1442. "drop function NodeExpB (Node);
  1443. ",
  1444. "f"
  1445. );
  1446. insert into sysbldobjdepends
  1447. (
  1448. bld_id,
  1449. obj_kind,
  1450. obj_signature,
  1451. obj_owner,
  1452. need_obj_kind,
  1453. need_obj_signature,
  1454. need_obj_owner)
  1455. values
  1456. (
  1457. "%SYSBLDNAME%",
  1458. 5, "NodeExpB (Node)",
  1459. "%SYSBLDUSER%",
  1460. 7, "Node",
  1461. "%SYSBLDUSER%"
  1462. );
  1463. insert into sysbldobjects
  1464. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1465. create_can_fail, drop_sql, drop_can_fail)
  1466. values
  1467. (
  1468. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeExpB (Node)",
  1469. "%SYSBLDUSER%", 0,
  1470. "alter function NodeExpB (Node)
  1471. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeExportBinary)"");
  1472. ",
  1473. "f",
  1474. "alter function NodeExpB (Node)
  1475. with (Modify External Name = ""NodeExportBinary"");
  1476. ",
  1477. "f"
  1478. );
  1479. insert into sysbldobjdepends
  1480. (
  1481. bld_id,
  1482. obj_kind,
  1483. obj_signature,
  1484. obj_owner,
  1485. need_obj_kind,
  1486. need_obj_signature,
  1487. need_obj_owner)
  1488. values
  1489. (
  1490. "%SYSBLDNAME%",
  1491. 181, "Alter-ExternalName-NodeExpB (Node)",
  1492. "%SYSBLDUSER%",
  1493. 5, "NodeExpB (Node)",
  1494. "%SYSBLDUSER%"
  1495. );
  1496. insert into sysbldobjects
  1497. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1498. create_can_fail, drop_sql, drop_can_fail)
  1499. values
  1500. (
  1501. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeExpB (Node)",
  1502. "%SYSBLDUSER%", 0,
  1503. "alter function NodeExpB (Node)
  1504. with (add parallelizable);
  1505. ",
  1506. "f",
  1507. "alter function NodeExpB (Node)
  1508. with (drop parallelizable);
  1509. ",
  1510. "f"
  1511. );
  1512. insert into sysbldobjdepends
  1513. (
  1514. bld_id,
  1515. obj_kind,
  1516. obj_signature,
  1517. obj_owner,
  1518. need_obj_kind,
  1519. need_obj_signature,
  1520. need_obj_owner)
  1521. values
  1522. (
  1523. "%SYSBLDNAME%",
  1524. 37, "Alter-Parallelize-NodeExpB (Node)",
  1525. "%SYSBLDUSER%",
  1526. 5, "NodeExpB (Node)",
  1527. "%SYSBLDUSER%"
  1528. );
  1529. insert into sysbldobjects
  1530. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1531. create_can_fail, drop_sql, drop_can_fail)
  1532. values
  1533. (
  1534. "%SYSBLDNAME%", 85, "Alter-Variant-NodeExpB (Node)",
  1535. "%SYSBLDUSER%", 0,
  1536. "alter function NodeExpB (Node)
  1537. with (add not variant);
  1538. ",
  1539. "f",
  1540. "alter function NodeExpB (Node)
  1541. with (drop not variant);
  1542. ",
  1543. "f"
  1544. );
  1545. insert into sysbldobjdepends
  1546. (
  1547. bld_id,
  1548. obj_kind,
  1549. obj_signature,
  1550. obj_owner,
  1551. need_obj_kind,
  1552. need_obj_signature,
  1553. need_obj_owner)
  1554. values
  1555. (
  1556. "%SYSBLDNAME%",
  1557. 85, "Alter-Variant-NodeExpB (Node)",
  1558. "%SYSBLDUSER%",
  1559. 5, "NodeExpB (Node)",
  1560. "%SYSBLDUSER%"
  1561. );
  1562. insert into sysbldobjects
  1563. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1564. create_can_fail, drop_sql, drop_can_fail)
  1565. values
  1566. (
  1567. "%SYSBLDNAME%", 69, "NodeExpB (Node)",
  1568. "%SYSBLDUSER%", 0,
  1569. "grant execute on function NodeExpB (Node) to public;
  1570. ",
  1571. "f",
  1572. "",
  1573. "f"
  1574. );
  1575. insert into sysbldobjdepends
  1576. (
  1577. bld_id,
  1578. obj_kind,
  1579. obj_signature,
  1580. obj_owner,
  1581. need_obj_kind,
  1582. need_obj_signature,
  1583. need_obj_owner)
  1584. values
  1585. (
  1586. "%SYSBLDNAME%",
  1587. 69, "NodeExpB (Node)",
  1588. "%SYSBLDUSER%",
  1589. 5, "NodeExpB (Node)",
  1590. "%SYSBLDUSER%"
  1591. );
  1592. insert into sysbldobjects
  1593. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1594. create_can_fail, drop_sql, drop_can_fail)
  1595. values
  1596. (
  1597. "%SYSBLDNAME%", 3, "Node->impexpbin",
  1598. "%SYSBLDUSER%", 0,
  1599. "create cast
  1600. (
  1601. Node as impexpbin
  1602. with NodeExpB
  1603. );
  1604. ",
  1605. "f",
  1606. "drop cast (Node as impexpbin);
  1607. ",
  1608. "f"
  1609. );
  1610. insert into sysbldobjdepends
  1611. (
  1612. bld_id,
  1613. obj_kind,
  1614. obj_signature,
  1615. obj_owner,
  1616. need_obj_kind,
  1617. need_obj_signature,
  1618. need_obj_owner)
  1619. values
  1620. (
  1621. "%SYSBLDNAME%",
  1622. 3, "Node->impexpbin",
  1623. "%SYSBLDUSER%",
  1624. 7, "Node",
  1625. "%SYSBLDUSER%"
  1626. );
  1627. insert into sysbldobjects
  1628. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1629. create_can_fail, drop_sql, drop_can_fail)
  1630. values
  1631. (
  1632. "%SYSBLDNAME%", 5, "Compare (Node,Node)",
  1633. "%SYSBLDUSER%", 0,
  1634. "create function Compare (Node,Node)
  1635. returns integer
  1636. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeCompare)"" language c;
  1637. ",
  1638. "f",
  1639. "drop function Compare (Node,Node);
  1640. ",
  1641. "f"
  1642. );
  1643. insert into sysbldobjdepends
  1644. (
  1645. bld_id,
  1646. obj_kind,
  1647. obj_signature,
  1648. obj_owner,
  1649. need_obj_kind,
  1650. need_obj_signature,
  1651. need_obj_owner)
  1652. values
  1653. (
  1654. "%SYSBLDNAME%",
  1655. 5, "Compare (Node,Node)",
  1656. "%SYSBLDUSER%",
  1657. 7, "Node",
  1658. "%SYSBLDUSER%"
  1659. );
  1660. insert into sysbldobjects
  1661. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1662. create_can_fail, drop_sql, drop_can_fail)
  1663. values
  1664. (
  1665. "%SYSBLDNAME%", 181, "Alter-ExternalName-Compare (Node,Node)",
  1666. "%SYSBLDUSER%", 0,
  1667. "alter function Compare (Node,Node)
  1668. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeCompare)"");
  1669. ",
  1670. "f",
  1671. "alter function Compare (Node,Node)
  1672. with (Modify External Name = ""NodeCompare"");
  1673. ",
  1674. "f"
  1675. );
  1676. insert into sysbldobjdepends
  1677. (
  1678. bld_id,
  1679. obj_kind,
  1680. obj_signature,
  1681. obj_owner,
  1682. need_obj_kind,
  1683. need_obj_signature,
  1684. need_obj_owner)
  1685. values
  1686. (
  1687. "%SYSBLDNAME%",
  1688. 181, "Alter-ExternalName-Compare (Node,Node)",
  1689. "%SYSBLDUSER%",
  1690. 5, "Compare (Node,Node)",
  1691. "%SYSBLDUSER%"
  1692. );
  1693. insert into sysbldobjects
  1694. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1695. create_can_fail, drop_sql, drop_can_fail)
  1696. values
  1697. (
  1698. "%SYSBLDNAME%", 37, "Alter-Parallelize-Compare (Node,Node)",
  1699. "%SYSBLDUSER%", 0,
  1700. "alter function Compare (Node,Node)
  1701. with (add parallelizable);
  1702. ",
  1703. "f",
  1704. "alter function Compare (Node,Node)
  1705. with (drop parallelizable);
  1706. ",
  1707. "f"
  1708. );
  1709. insert into sysbldobjdepends
  1710. (
  1711. bld_id,
  1712. obj_kind,
  1713. obj_signature,
  1714. obj_owner,
  1715. need_obj_kind,
  1716. need_obj_signature,
  1717. need_obj_owner)
  1718. values
  1719. (
  1720. "%SYSBLDNAME%",
  1721. 37, "Alter-Parallelize-Compare (Node,Node)",
  1722. "%SYSBLDUSER%",
  1723. 5, "Compare (Node,Node)",
  1724. "%SYSBLDUSER%"
  1725. );
  1726. insert into sysbldobjects
  1727. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1728. create_can_fail, drop_sql, drop_can_fail)
  1729. values
  1730. (
  1731. "%SYSBLDNAME%", 85, "Alter-Variant-Compare (Node,Node)",
  1732. "%SYSBLDUSER%", 0,
  1733. "alter function Compare (Node,Node)
  1734. with (add not variant);
  1735. ",
  1736. "f",
  1737. "alter function Compare (Node,Node)
  1738. with (drop not variant);
  1739. ",
  1740. "f"
  1741. );
  1742. insert into sysbldobjdepends
  1743. (
  1744. bld_id,
  1745. obj_kind,
  1746. obj_signature,
  1747. obj_owner,
  1748. need_obj_kind,
  1749. need_obj_signature,
  1750. need_obj_owner)
  1751. values
  1752. (
  1753. "%SYSBLDNAME%",
  1754. 85, "Alter-Variant-Compare (Node,Node)",
  1755. "%SYSBLDUSER%",
  1756. 5, "Compare (Node,Node)",
  1757. "%SYSBLDUSER%"
  1758. );
  1759. insert into sysbldobjects
  1760. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1761. create_can_fail, drop_sql, drop_can_fail)
  1762. values
  1763. (
  1764. "%SYSBLDNAME%", 69, "Compare (Node,Node)",
  1765. "%SYSBLDUSER%", 0,
  1766. "grant execute on function Compare (Node,Node) to public;
  1767. ",
  1768. "f",
  1769. "",
  1770. "f"
  1771. );
  1772. insert into sysbldobjdepends
  1773. (
  1774. bld_id,
  1775. obj_kind,
  1776. obj_signature,
  1777. obj_owner,
  1778. need_obj_kind,
  1779. need_obj_signature,
  1780. need_obj_owner)
  1781. values
  1782. (
  1783. "%SYSBLDNAME%",
  1784. 69, "Compare (Node,Node)",
  1785. "%SYSBLDUSER%",
  1786. 5, "Compare (Node,Node)",
  1787. "%SYSBLDUSER%"
  1788. );
  1789. insert into sysbldobjects
  1790. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1791. create_can_fail, drop_sql, drop_can_fail)
  1792. values
  1793. (
  1794. "%SYSBLDNAME%", 5, "Equal (Node,Node)",
  1795. "%SYSBLDUSER%", 0,
  1796. "create function Equal (Node,Node)
  1797. returns boolean
  1798. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeEqual)"" language c;
  1799. ",
  1800. "f",
  1801. "drop function Equal (Node,Node);
  1802. ",
  1803. "f"
  1804. );
  1805. insert into sysbldobjdepends
  1806. (
  1807. bld_id,
  1808. obj_kind,
  1809. obj_signature,
  1810. obj_owner,
  1811. need_obj_kind,
  1812. need_obj_signature,
  1813. need_obj_owner)
  1814. values
  1815. (
  1816. "%SYSBLDNAME%",
  1817. 5, "Equal (Node,Node)",
  1818. "%SYSBLDUSER%",
  1819. 7, "Node",
  1820. "%SYSBLDUSER%"
  1821. );
  1822. insert into sysbldobjects
  1823. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1824. create_can_fail, drop_sql, drop_can_fail)
  1825. values
  1826. (
  1827. "%SYSBLDNAME%", 181, "Alter-ExternalName-Equal (Node,Node)",
  1828. "%SYSBLDUSER%", 0,
  1829. "alter function Equal (Node,Node)
  1830. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeEqual)"");
  1831. ",
  1832. "f",
  1833. "alter function Equal (Node,Node)
  1834. with (Modify External Name = ""NodeEqual"");
  1835. ",
  1836. "f"
  1837. );
  1838. insert into sysbldobjdepends
  1839. (
  1840. bld_id,
  1841. obj_kind,
  1842. obj_signature,
  1843. obj_owner,
  1844. need_obj_kind,
  1845. need_obj_signature,
  1846. need_obj_owner)
  1847. values
  1848. (
  1849. "%SYSBLDNAME%",
  1850. 181, "Alter-ExternalName-Equal (Node,Node)",
  1851. "%SYSBLDUSER%",
  1852. 5, "Equal (Node,Node)",
  1853. "%SYSBLDUSER%"
  1854. );
  1855. insert into sysbldobjects
  1856. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1857. create_can_fail, drop_sql, drop_can_fail)
  1858. values
  1859. (
  1860. "%SYSBLDNAME%", 37, "Alter-Parallelize-Equal (Node,Node)",
  1861. "%SYSBLDUSER%", 0,
  1862. "alter function Equal (Node,Node)
  1863. with (add parallelizable);
  1864. ",
  1865. "f",
  1866. "alter function Equal (Node,Node)
  1867. with (drop parallelizable);
  1868. ",
  1869. "f"
  1870. );
  1871. insert into sysbldobjdepends
  1872. (
  1873. bld_id,
  1874. obj_kind,
  1875. obj_signature,
  1876. obj_owner,
  1877. need_obj_kind,
  1878. need_obj_signature,
  1879. need_obj_owner)
  1880. values
  1881. (
  1882. "%SYSBLDNAME%",
  1883. 37, "Alter-Parallelize-Equal (Node,Node)",
  1884. "%SYSBLDUSER%",
  1885. 5, "Equal (Node,Node)",
  1886. "%SYSBLDUSER%"
  1887. );
  1888. insert into sysbldobjects
  1889. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1890. create_can_fail, drop_sql, drop_can_fail)
  1891. values
  1892. (
  1893. "%SYSBLDNAME%", 85, "Alter-Variant-Equal (Node,Node)",
  1894. "%SYSBLDUSER%", 0,
  1895. "alter function Equal (Node,Node)
  1896. with (add not variant);
  1897. ",
  1898. "f",
  1899. "alter function Equal (Node,Node)
  1900. with (drop not variant);
  1901. ",
  1902. "f"
  1903. );
  1904. insert into sysbldobjdepends
  1905. (
  1906. bld_id,
  1907. obj_kind,
  1908. obj_signature,
  1909. obj_owner,
  1910. need_obj_kind,
  1911. need_obj_signature,
  1912. need_obj_owner)
  1913. values
  1914. (
  1915. "%SYSBLDNAME%",
  1916. 85, "Alter-Variant-Equal (Node,Node)",
  1917. "%SYSBLDUSER%",
  1918. 5, "Equal (Node,Node)",
  1919. "%SYSBLDUSER%"
  1920. );
  1921. insert into sysbldobjects
  1922. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1923. create_can_fail, drop_sql, drop_can_fail)
  1924. values
  1925. (
  1926. "%SYSBLDNAME%", 95, "Alter-Negator-Equal (Node,Node)",
  1927. "%SYSBLDUSER%", 0,
  1928. "alter function Equal (Node,Node)
  1929. with (add negator=NotEqual);
  1930. ",
  1931. "f",
  1932. "alter function Equal (Node,Node)
  1933. with (drop negator);
  1934. ",
  1935. "f"
  1936. );
  1937. insert into sysbldobjdepends
  1938. (
  1939. bld_id,
  1940. obj_kind,
  1941. obj_signature,
  1942. obj_owner,
  1943. need_obj_kind,
  1944. need_obj_signature,
  1945. need_obj_owner)
  1946. values
  1947. (
  1948. "%SYSBLDNAME%",
  1949. 95, "Alter-Negator-Equal (Node,Node)",
  1950. "%SYSBLDUSER%",
  1951. 5, "Equal (Node,Node)",
  1952. "%SYSBLDUSER%"
  1953. );
  1954. insert into sysbldobjects
  1955. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1956. create_can_fail, drop_sql, drop_can_fail)
  1957. values
  1958. (
  1959. "%SYSBLDNAME%", 101, "Alter-Commutator-Equal (Node,Node)",
  1960. "%SYSBLDUSER%", 0,
  1961. "alter function Equal (Node,Node)
  1962. with (add Commutator=Equal);
  1963. ",
  1964. "f",
  1965. "alter function Equal (Node,Node)
  1966. with (drop Commutator);
  1967. ",
  1968. "f"
  1969. );
  1970. insert into sysbldobjdepends
  1971. (
  1972. bld_id,
  1973. obj_kind,
  1974. obj_signature,
  1975. obj_owner,
  1976. need_obj_kind,
  1977. need_obj_signature,
  1978. need_obj_owner)
  1979. values
  1980. (
  1981. "%SYSBLDNAME%",
  1982. 101, "Alter-Commutator-Equal (Node,Node)",
  1983. "%SYSBLDUSER%",
  1984. 5, "Equal (Node,Node)",
  1985. "%SYSBLDUSER%"
  1986. );
  1987. insert into sysbldobjects
  1988. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  1989. create_can_fail, drop_sql, drop_can_fail)
  1990. values
  1991. (
  1992. "%SYSBLDNAME%", 69, "Equal (Node,Node)",
  1993. "%SYSBLDUSER%", 0,
  1994. "grant execute on function Equal (Node,Node) to public;
  1995. ",
  1996. "f",
  1997. "",
  1998. "f"
  1999. );
  2000. insert into sysbldobjdepends
  2001. (
  2002. bld_id,
  2003. obj_kind,
  2004. obj_signature,
  2005. obj_owner,
  2006. need_obj_kind,
  2007. need_obj_signature,
  2008. need_obj_owner)
  2009. values
  2010. (
  2011. "%SYSBLDNAME%",
  2012. 69, "Equal (Node,Node)",
  2013. "%SYSBLDUSER%",
  2014. 5, "Equal (Node,Node)",
  2015. "%SYSBLDUSER%"
  2016. );
  2017. insert into sysbldobjects
  2018. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2019. create_can_fail, drop_sql, drop_can_fail)
  2020. values
  2021. (
  2022. "%SYSBLDNAME%", 5, "NotEqual (Node,Node)",
  2023. "%SYSBLDUSER%", 0,
  2024. "create function NotEqual (Node,Node)
  2025. returns boolean
  2026. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeNotEqual)"" language c;
  2027. ",
  2028. "f",
  2029. "drop function NotEqual (Node,Node);
  2030. ",
  2031. "f"
  2032. );
  2033. insert into sysbldobjdepends
  2034. (
  2035. bld_id,
  2036. obj_kind,
  2037. obj_signature,
  2038. obj_owner,
  2039. need_obj_kind,
  2040. need_obj_signature,
  2041. need_obj_owner)
  2042. values
  2043. (
  2044. "%SYSBLDNAME%",
  2045. 5, "NotEqual (Node,Node)",
  2046. "%SYSBLDUSER%",
  2047. 7, "Node",
  2048. "%SYSBLDUSER%"
  2049. );
  2050. insert into sysbldobjects
  2051. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2052. create_can_fail, drop_sql, drop_can_fail)
  2053. values
  2054. (
  2055. "%SYSBLDNAME%", 181, "Alter-ExternalName-NotEqual (Node,Node)",
  2056. "%SYSBLDUSER%", 0,
  2057. "alter function NotEqual (Node,Node)
  2058. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeNotEqual)"");
  2059. ",
  2060. "f",
  2061. "alter function NotEqual (Node,Node)
  2062. with (Modify External Name = ""NodeNotEqual"");
  2063. ",
  2064. "f"
  2065. );
  2066. insert into sysbldobjdepends
  2067. (
  2068. bld_id,
  2069. obj_kind,
  2070. obj_signature,
  2071. obj_owner,
  2072. need_obj_kind,
  2073. need_obj_signature,
  2074. need_obj_owner)
  2075. values
  2076. (
  2077. "%SYSBLDNAME%",
  2078. 181, "Alter-ExternalName-NotEqual (Node,Node)",
  2079. "%SYSBLDUSER%",
  2080. 5, "NotEqual (Node,Node)",
  2081. "%SYSBLDUSER%"
  2082. );
  2083. insert into sysbldobjects
  2084. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2085. create_can_fail, drop_sql, drop_can_fail)
  2086. values
  2087. (
  2088. "%SYSBLDNAME%", 37, "Alter-Parallelize-NotEqual (Node,Node)",
  2089. "%SYSBLDUSER%", 0,
  2090. "alter function NotEqual (Node,Node)
  2091. with (add parallelizable);
  2092. ",
  2093. "f",
  2094. "alter function NotEqual (Node,Node)
  2095. with (drop parallelizable);
  2096. ",
  2097. "f"
  2098. );
  2099. insert into sysbldobjdepends
  2100. (
  2101. bld_id,
  2102. obj_kind,
  2103. obj_signature,
  2104. obj_owner,
  2105. need_obj_kind,
  2106. need_obj_signature,
  2107. need_obj_owner)
  2108. values
  2109. (
  2110. "%SYSBLDNAME%",
  2111. 37, "Alter-Parallelize-NotEqual (Node,Node)",
  2112. "%SYSBLDUSER%",
  2113. 5, "NotEqual (Node,Node)",
  2114. "%SYSBLDUSER%"
  2115. );
  2116. insert into sysbldobjects
  2117. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2118. create_can_fail, drop_sql, drop_can_fail)
  2119. values
  2120. (
  2121. "%SYSBLDNAME%", 85, "Alter-Variant-NotEqual (Node,Node)",
  2122. "%SYSBLDUSER%", 0,
  2123. "alter function NotEqual (Node,Node)
  2124. with (add not variant);
  2125. ",
  2126. "f",
  2127. "alter function NotEqual (Node,Node)
  2128. with (drop not variant);
  2129. ",
  2130. "f"
  2131. );
  2132. insert into sysbldobjdepends
  2133. (
  2134. bld_id,
  2135. obj_kind,
  2136. obj_signature,
  2137. obj_owner,
  2138. need_obj_kind,
  2139. need_obj_signature,
  2140. need_obj_owner)
  2141. values
  2142. (
  2143. "%SYSBLDNAME%",
  2144. 85, "Alter-Variant-NotEqual (Node,Node)",
  2145. "%SYSBLDUSER%",
  2146. 5, "NotEqual (Node,Node)",
  2147. "%SYSBLDUSER%"
  2148. );
  2149. insert into sysbldobjects
  2150. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2151. create_can_fail, drop_sql, drop_can_fail)
  2152. values
  2153. (
  2154. "%SYSBLDNAME%", 95, "Alter-Negator-NotEqual (Node,Node)",
  2155. "%SYSBLDUSER%", 0,
  2156. "alter function NotEqual (Node,Node)
  2157. with (add negator=Equal);
  2158. ",
  2159. "f",
  2160. "alter function NotEqual (Node,Node)
  2161. with (drop negator);
  2162. ",
  2163. "f"
  2164. );
  2165. insert into sysbldobjdepends
  2166. (
  2167. bld_id,
  2168. obj_kind,
  2169. obj_signature,
  2170. obj_owner,
  2171. need_obj_kind,
  2172. need_obj_signature,
  2173. need_obj_owner)
  2174. values
  2175. (
  2176. "%SYSBLDNAME%",
  2177. 95, "Alter-Negator-NotEqual (Node,Node)",
  2178. "%SYSBLDUSER%",
  2179. 5, "NotEqual (Node,Node)",
  2180. "%SYSBLDUSER%"
  2181. );
  2182. insert into sysbldobjects
  2183. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2184. create_can_fail, drop_sql, drop_can_fail)
  2185. values
  2186. (
  2187. "%SYSBLDNAME%", 101, "Alter-Commutator-NotEqual (Node,Node)",
  2188. "%SYSBLDUSER%", 0,
  2189. "alter function NotEqual (Node,Node)
  2190. with (add Commutator=NotEqual);
  2191. ",
  2192. "f",
  2193. "alter function NotEqual (Node,Node)
  2194. with (drop Commutator);
  2195. ",
  2196. "f"
  2197. );
  2198. insert into sysbldobjdepends
  2199. (
  2200. bld_id,
  2201. obj_kind,
  2202. obj_signature,
  2203. obj_owner,
  2204. need_obj_kind,
  2205. need_obj_signature,
  2206. need_obj_owner)
  2207. values
  2208. (
  2209. "%SYSBLDNAME%",
  2210. 101, "Alter-Commutator-NotEqual (Node,Node)",
  2211. "%SYSBLDUSER%",
  2212. 5, "NotEqual (Node,Node)",
  2213. "%SYSBLDUSER%"
  2214. );
  2215. insert into sysbldobjects
  2216. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2217. create_can_fail, drop_sql, drop_can_fail)
  2218. values
  2219. (
  2220. "%SYSBLDNAME%", 69, "NotEqual (Node,Node)",
  2221. "%SYSBLDUSER%", 0,
  2222. "grant execute on function NotEqual (Node,Node) to public;
  2223. ",
  2224. "f",
  2225. "",
  2226. "f"
  2227. );
  2228. insert into sysbldobjdepends
  2229. (
  2230. bld_id,
  2231. obj_kind,
  2232. obj_signature,
  2233. obj_owner,
  2234. need_obj_kind,
  2235. need_obj_signature,
  2236. need_obj_owner)
  2237. values
  2238. (
  2239. "%SYSBLDNAME%",
  2240. 69, "NotEqual (Node,Node)",
  2241. "%SYSBLDUSER%",
  2242. 5, "NotEqual (Node,Node)",
  2243. "%SYSBLDUSER%"
  2244. );
  2245. insert into sysbldobjects
  2246. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2247. create_can_fail, drop_sql, drop_can_fail)
  2248. values
  2249. (
  2250. "%SYSBLDNAME%", 5, "LessThan (Node,Node)",
  2251. "%SYSBLDUSER%", 0,
  2252. "create function LessThan (Node,Node)
  2253. returns boolean
  2254. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeLessThan)"" language c;
  2255. ",
  2256. "f",
  2257. "drop function LessThan (Node,Node);
  2258. ",
  2259. "f"
  2260. );
  2261. insert into sysbldobjdepends
  2262. (
  2263. bld_id,
  2264. obj_kind,
  2265. obj_signature,
  2266. obj_owner,
  2267. need_obj_kind,
  2268. need_obj_signature,
  2269. need_obj_owner)
  2270. values
  2271. (
  2272. "%SYSBLDNAME%",
  2273. 5, "LessThan (Node,Node)",
  2274. "%SYSBLDUSER%",
  2275. 7, "Node",
  2276. "%SYSBLDUSER%"
  2277. );
  2278. insert into sysbldobjects
  2279. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2280. create_can_fail, drop_sql, drop_can_fail)
  2281. values
  2282. (
  2283. "%SYSBLDNAME%", 181, "Alter-ExternalName-LessThan (Node,Node)",
  2284. "%SYSBLDUSER%", 0,
  2285. "alter function LessThan (Node,Node)
  2286. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeLessThan)"");
  2287. ",
  2288. "f",
  2289. "alter function LessThan (Node,Node)
  2290. with (Modify External Name = ""NodeLessThan"");
  2291. ",
  2292. "f"
  2293. );
  2294. insert into sysbldobjdepends
  2295. (
  2296. bld_id,
  2297. obj_kind,
  2298. obj_signature,
  2299. obj_owner,
  2300. need_obj_kind,
  2301. need_obj_signature,
  2302. need_obj_owner)
  2303. values
  2304. (
  2305. "%SYSBLDNAME%",
  2306. 181, "Alter-ExternalName-LessThan (Node,Node)",
  2307. "%SYSBLDUSER%",
  2308. 5, "LessThan (Node,Node)",
  2309. "%SYSBLDUSER%"
  2310. );
  2311. insert into sysbldobjects
  2312. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2313. create_can_fail, drop_sql, drop_can_fail)
  2314. values
  2315. (
  2316. "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThan (Node,Node)",
  2317. "%SYSBLDUSER%", 0,
  2318. "alter function LessThan (Node,Node)
  2319. with (add parallelizable);
  2320. ",
  2321. "f",
  2322. "alter function LessThan (Node,Node)
  2323. with (drop parallelizable);
  2324. ",
  2325. "f"
  2326. );
  2327. insert into sysbldobjdepends
  2328. (
  2329. bld_id,
  2330. obj_kind,
  2331. obj_signature,
  2332. obj_owner,
  2333. need_obj_kind,
  2334. need_obj_signature,
  2335. need_obj_owner)
  2336. values
  2337. (
  2338. "%SYSBLDNAME%",
  2339. 37, "Alter-Parallelize-LessThan (Node,Node)",
  2340. "%SYSBLDUSER%",
  2341. 5, "LessThan (Node,Node)",
  2342. "%SYSBLDUSER%"
  2343. );
  2344. insert into sysbldobjects
  2345. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2346. create_can_fail, drop_sql, drop_can_fail)
  2347. values
  2348. (
  2349. "%SYSBLDNAME%", 85, "Alter-Variant-LessThan (Node,Node)",
  2350. "%SYSBLDUSER%", 0,
  2351. "alter function LessThan (Node,Node)
  2352. with (add not variant);
  2353. ",
  2354. "f",
  2355. "alter function LessThan (Node,Node)
  2356. with (drop not variant);
  2357. ",
  2358. "f"
  2359. );
  2360. insert into sysbldobjdepends
  2361. (
  2362. bld_id,
  2363. obj_kind,
  2364. obj_signature,
  2365. obj_owner,
  2366. need_obj_kind,
  2367. need_obj_signature,
  2368. need_obj_owner)
  2369. values
  2370. (
  2371. "%SYSBLDNAME%",
  2372. 85, "Alter-Variant-LessThan (Node,Node)",
  2373. "%SYSBLDUSER%",
  2374. 5, "LessThan (Node,Node)",
  2375. "%SYSBLDUSER%"
  2376. );
  2377. insert into sysbldobjects
  2378. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2379. create_can_fail, drop_sql, drop_can_fail)
  2380. values
  2381. (
  2382. "%SYSBLDNAME%", 95, "Alter-Negator-LessThan (Node,Node)",
  2383. "%SYSBLDUSER%", 0,
  2384. "alter function LessThan (Node,Node)
  2385. with (add negator=GreaterThanOrEqual);
  2386. ",
  2387. "f",
  2388. "alter function LessThan (Node,Node)
  2389. with (drop negator);
  2390. ",
  2391. "f"
  2392. );
  2393. insert into sysbldobjdepends
  2394. (
  2395. bld_id,
  2396. obj_kind,
  2397. obj_signature,
  2398. obj_owner,
  2399. need_obj_kind,
  2400. need_obj_signature,
  2401. need_obj_owner)
  2402. values
  2403. (
  2404. "%SYSBLDNAME%",
  2405. 95, "Alter-Negator-LessThan (Node,Node)",
  2406. "%SYSBLDUSER%",
  2407. 5, "LessThan (Node,Node)",
  2408. "%SYSBLDUSER%"
  2409. );
  2410. insert into sysbldobjects
  2411. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2412. create_can_fail, drop_sql, drop_can_fail)
  2413. values
  2414. (
  2415. "%SYSBLDNAME%", 101, "Alter-Commutator-LessThan (Node,Node)",
  2416. "%SYSBLDUSER%", 0,
  2417. "alter function LessThan (Node,Node)
  2418. with (add Commutator=GreaterThanOrEqual);
  2419. ",
  2420. "f",
  2421. "alter function LessThan (Node,Node)
  2422. with (drop Commutator);
  2423. ",
  2424. "f"
  2425. );
  2426. insert into sysbldobjdepends
  2427. (
  2428. bld_id,
  2429. obj_kind,
  2430. obj_signature,
  2431. obj_owner,
  2432. need_obj_kind,
  2433. need_obj_signature,
  2434. need_obj_owner)
  2435. values
  2436. (
  2437. "%SYSBLDNAME%",
  2438. 101, "Alter-Commutator-LessThan (Node,Node)",
  2439. "%SYSBLDUSER%",
  2440. 5, "LessThan (Node,Node)",
  2441. "%SYSBLDUSER%"
  2442. );
  2443. insert into sysbldobjects
  2444. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2445. create_can_fail, drop_sql, drop_can_fail)
  2446. values
  2447. (
  2448. "%SYSBLDNAME%", 69, "LessThan (Node,Node)",
  2449. "%SYSBLDUSER%", 0,
  2450. "grant execute on function LessThan (Node,Node) to public;
  2451. ",
  2452. "f",
  2453. "",
  2454. "f"
  2455. );
  2456. insert into sysbldobjdepends
  2457. (
  2458. bld_id,
  2459. obj_kind,
  2460. obj_signature,
  2461. obj_owner,
  2462. need_obj_kind,
  2463. need_obj_signature,
  2464. need_obj_owner)
  2465. values
  2466. (
  2467. "%SYSBLDNAME%",
  2468. 69, "LessThan (Node,Node)",
  2469. "%SYSBLDUSER%",
  2470. 5, "LessThan (Node,Node)",
  2471. "%SYSBLDUSER%"
  2472. );
  2473. insert into sysbldobjects
  2474. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2475. create_can_fail, drop_sql, drop_can_fail)
  2476. values
  2477. (
  2478. "%SYSBLDNAME%", 5, "GreaterThan (Node,Node)",
  2479. "%SYSBLDUSER%", 0,
  2480. "create function GreaterThan (Node,Node)
  2481. returns boolean
  2482. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGreaterThan)"" language c;
  2483. ",
  2484. "f",
  2485. "drop function GreaterThan (Node,Node);
  2486. ",
  2487. "f"
  2488. );
  2489. insert into sysbldobjdepends
  2490. (
  2491. bld_id,
  2492. obj_kind,
  2493. obj_signature,
  2494. obj_owner,
  2495. need_obj_kind,
  2496. need_obj_signature,
  2497. need_obj_owner)
  2498. values
  2499. (
  2500. "%SYSBLDNAME%",
  2501. 5, "GreaterThan (Node,Node)",
  2502. "%SYSBLDUSER%",
  2503. 7, "Node",
  2504. "%SYSBLDUSER%"
  2505. );
  2506. insert into sysbldobjects
  2507. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2508. create_can_fail, drop_sql, drop_can_fail)
  2509. values
  2510. (
  2511. "%SYSBLDNAME%", 181, "Alter-ExternalName-GreaterThan (Node,Node)",
  2512. "%SYSBLDUSER%", 0,
  2513. "alter function GreaterThan (Node,Node)
  2514. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGreaterThan)"");
  2515. ",
  2516. "f",
  2517. "alter function GreaterThan (Node,Node)
  2518. with (Modify External Name = ""NodeGreaterThan"");
  2519. ",
  2520. "f"
  2521. );
  2522. insert into sysbldobjdepends
  2523. (
  2524. bld_id,
  2525. obj_kind,
  2526. obj_signature,
  2527. obj_owner,
  2528. need_obj_kind,
  2529. need_obj_signature,
  2530. need_obj_owner)
  2531. values
  2532. (
  2533. "%SYSBLDNAME%",
  2534. 181, "Alter-ExternalName-GreaterThan (Node,Node)",
  2535. "%SYSBLDUSER%",
  2536. 5, "GreaterThan (Node,Node)",
  2537. "%SYSBLDUSER%"
  2538. );
  2539. insert into sysbldobjects
  2540. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2541. create_can_fail, drop_sql, drop_can_fail)
  2542. values
  2543. (
  2544. "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThan (Node,Node)",
  2545. "%SYSBLDUSER%", 0,
  2546. "alter function GreaterThan (Node,Node)
  2547. with (add parallelizable);
  2548. ",
  2549. "f",
  2550. "alter function GreaterThan (Node,Node)
  2551. with (drop parallelizable);
  2552. ",
  2553. "f"
  2554. );
  2555. insert into sysbldobjdepends
  2556. (
  2557. bld_id,
  2558. obj_kind,
  2559. obj_signature,
  2560. obj_owner,
  2561. need_obj_kind,
  2562. need_obj_signature,
  2563. need_obj_owner)
  2564. values
  2565. (
  2566. "%SYSBLDNAME%",
  2567. 37, "Alter-Parallelize-GreaterThan (Node,Node)",
  2568. "%SYSBLDUSER%",
  2569. 5, "GreaterThan (Node,Node)",
  2570. "%SYSBLDUSER%"
  2571. );
  2572. insert into sysbldobjects
  2573. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2574. create_can_fail, drop_sql, drop_can_fail)
  2575. values
  2576. (
  2577. "%SYSBLDNAME%", 85, "Alter-Variant-GreaterThan (Node,Node)",
  2578. "%SYSBLDUSER%", 0,
  2579. "alter function GreaterThan (Node,Node)
  2580. with (add not variant);
  2581. ",
  2582. "f",
  2583. "alter function GreaterThan (Node,Node)
  2584. with (drop not variant);
  2585. ",
  2586. "f"
  2587. );
  2588. insert into sysbldobjdepends
  2589. (
  2590. bld_id,
  2591. obj_kind,
  2592. obj_signature,
  2593. obj_owner,
  2594. need_obj_kind,
  2595. need_obj_signature,
  2596. need_obj_owner)
  2597. values
  2598. (
  2599. "%SYSBLDNAME%",
  2600. 85, "Alter-Variant-GreaterThan (Node,Node)",
  2601. "%SYSBLDUSER%",
  2602. 5, "GreaterThan (Node,Node)",
  2603. "%SYSBLDUSER%"
  2604. );
  2605. insert into sysbldobjects
  2606. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2607. create_can_fail, drop_sql, drop_can_fail)
  2608. values
  2609. (
  2610. "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThan (Node,Node)",
  2611. "%SYSBLDUSER%", 0,
  2612. "alter function GreaterThan (Node,Node)
  2613. with (add negator=LessThanOrEqual);
  2614. ",
  2615. "f",
  2616. "alter function GreaterThan (Node,Node)
  2617. with (drop negator);
  2618. ",
  2619. "f"
  2620. );
  2621. insert into sysbldobjdepends
  2622. (
  2623. bld_id,
  2624. obj_kind,
  2625. obj_signature,
  2626. obj_owner,
  2627. need_obj_kind,
  2628. need_obj_signature,
  2629. need_obj_owner)
  2630. values
  2631. (
  2632. "%SYSBLDNAME%",
  2633. 95, "Alter-Negator-GreaterThan (Node,Node)",
  2634. "%SYSBLDUSER%",
  2635. 5, "GreaterThan (Node,Node)",
  2636. "%SYSBLDUSER%"
  2637. );
  2638. insert into sysbldobjects
  2639. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2640. create_can_fail, drop_sql, drop_can_fail)
  2641. values
  2642. (
  2643. "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThan (Node,Node)",
  2644. "%SYSBLDUSER%", 0,
  2645. "alter function GreaterThan (Node,Node)
  2646. with (add Commutator=LessThanOrEqual);
  2647. ",
  2648. "f",
  2649. "alter function GreaterThan (Node,Node)
  2650. with (drop Commutator);
  2651. ",
  2652. "f"
  2653. );
  2654. insert into sysbldobjdepends
  2655. (
  2656. bld_id,
  2657. obj_kind,
  2658. obj_signature,
  2659. obj_owner,
  2660. need_obj_kind,
  2661. need_obj_signature,
  2662. need_obj_owner)
  2663. values
  2664. (
  2665. "%SYSBLDNAME%",
  2666. 101, "Alter-Commutator-GreaterThan (Node,Node)",
  2667. "%SYSBLDUSER%",
  2668. 5, "GreaterThan (Node,Node)",
  2669. "%SYSBLDUSER%"
  2670. );
  2671. insert into sysbldobjects
  2672. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2673. create_can_fail, drop_sql, drop_can_fail)
  2674. values
  2675. (
  2676. "%SYSBLDNAME%", 69, "GreaterThan (Node,Node)",
  2677. "%SYSBLDUSER%", 0,
  2678. "grant execute on function GreaterThan (Node,Node) to public;
  2679. ",
  2680. "f",
  2681. "",
  2682. "f"
  2683. );
  2684. insert into sysbldobjdepends
  2685. (
  2686. bld_id,
  2687. obj_kind,
  2688. obj_signature,
  2689. obj_owner,
  2690. need_obj_kind,
  2691. need_obj_signature,
  2692. need_obj_owner)
  2693. values
  2694. (
  2695. "%SYSBLDNAME%",
  2696. 69, "GreaterThan (Node,Node)",
  2697. "%SYSBLDUSER%",
  2698. 5, "GreaterThan (Node,Node)",
  2699. "%SYSBLDUSER%"
  2700. );
  2701. insert into sysbldobjects
  2702. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2703. create_can_fail, drop_sql, drop_can_fail)
  2704. values
  2705. (
  2706. "%SYSBLDNAME%", 5, "LessThanOrEqual (Node,Node)",
  2707. "%SYSBLDUSER%", 0,
  2708. "create function LessThanOrEqual (Node,Node)
  2709. returns boolean
  2710. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeLessThanOrEqual)"" language c;
  2711. ",
  2712. "f",
  2713. "drop function LessThanOrEqual (Node,Node);
  2714. ",
  2715. "f"
  2716. );
  2717. insert into sysbldobjdepends
  2718. (
  2719. bld_id,
  2720. obj_kind,
  2721. obj_signature,
  2722. obj_owner,
  2723. need_obj_kind,
  2724. need_obj_signature,
  2725. need_obj_owner)
  2726. values
  2727. (
  2728. "%SYSBLDNAME%",
  2729. 5, "LessThanOrEqual (Node,Node)",
  2730. "%SYSBLDUSER%",
  2731. 7, "Node",
  2732. "%SYSBLDUSER%"
  2733. );
  2734. insert into sysbldobjects
  2735. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2736. create_can_fail, drop_sql, drop_can_fail)
  2737. values
  2738. (
  2739. "%SYSBLDNAME%", 181, "Alter-ExternalName-LessThanOrEqual (Node,Node)",
  2740. "%SYSBLDUSER%", 0,
  2741. "alter function LessThanOrEqual (Node,Node)
  2742. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeLessThanOrEqual)"");
  2743. ",
  2744. "f",
  2745. "alter function LessThanOrEqual (Node,Node)
  2746. with (Modify External Name = ""NodeLessThanOrEqual"");
  2747. ",
  2748. "f"
  2749. );
  2750. insert into sysbldobjdepends
  2751. (
  2752. bld_id,
  2753. obj_kind,
  2754. obj_signature,
  2755. obj_owner,
  2756. need_obj_kind,
  2757. need_obj_signature,
  2758. need_obj_owner)
  2759. values
  2760. (
  2761. "%SYSBLDNAME%",
  2762. 181, "Alter-ExternalName-LessThanOrEqual (Node,Node)",
  2763. "%SYSBLDUSER%",
  2764. 5, "LessThanOrEqual (Node,Node)",
  2765. "%SYSBLDUSER%"
  2766. );
  2767. insert into sysbldobjects
  2768. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2769. create_can_fail, drop_sql, drop_can_fail)
  2770. values
  2771. (
  2772. "%SYSBLDNAME%", 37, "Alter-Parallelize-LessThanOrEqual (Node,Node)",
  2773. "%SYSBLDUSER%", 0,
  2774. "alter function LessThanOrEqual (Node,Node)
  2775. with (add parallelizable);
  2776. ",
  2777. "f",
  2778. "alter function LessThanOrEqual (Node,Node)
  2779. with (drop parallelizable);
  2780. ",
  2781. "f"
  2782. );
  2783. insert into sysbldobjdepends
  2784. (
  2785. bld_id,
  2786. obj_kind,
  2787. obj_signature,
  2788. obj_owner,
  2789. need_obj_kind,
  2790. need_obj_signature,
  2791. need_obj_owner)
  2792. values
  2793. (
  2794. "%SYSBLDNAME%",
  2795. 37, "Alter-Parallelize-LessThanOrEqual (Node,Node)",
  2796. "%SYSBLDUSER%",
  2797. 5, "LessThanOrEqual (Node,Node)",
  2798. "%SYSBLDUSER%"
  2799. );
  2800. insert into sysbldobjects
  2801. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2802. create_can_fail, drop_sql, drop_can_fail)
  2803. values
  2804. (
  2805. "%SYSBLDNAME%", 85, "Alter-Variant-LessThanOrEqual (Node,Node)",
  2806. "%SYSBLDUSER%", 0,
  2807. "alter function LessThanOrEqual (Node,Node)
  2808. with (add not variant);
  2809. ",
  2810. "f",
  2811. "alter function LessThanOrEqual (Node,Node)
  2812. with (drop not variant);
  2813. ",
  2814. "f"
  2815. );
  2816. insert into sysbldobjdepends
  2817. (
  2818. bld_id,
  2819. obj_kind,
  2820. obj_signature,
  2821. obj_owner,
  2822. need_obj_kind,
  2823. need_obj_signature,
  2824. need_obj_owner)
  2825. values
  2826. (
  2827. "%SYSBLDNAME%",
  2828. 85, "Alter-Variant-LessThanOrEqual (Node,Node)",
  2829. "%SYSBLDUSER%",
  2830. 5, "LessThanOrEqual (Node,Node)",
  2831. "%SYSBLDUSER%"
  2832. );
  2833. insert into sysbldobjects
  2834. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2835. create_can_fail, drop_sql, drop_can_fail)
  2836. values
  2837. (
  2838. "%SYSBLDNAME%", 95, "Alter-Negator-LessThanOrEqual (Node,Node)",
  2839. "%SYSBLDUSER%", 0,
  2840. "alter function LessThanOrEqual (Node,Node)
  2841. with (add negator=GreaterThan);
  2842. ",
  2843. "f",
  2844. "alter function LessThanOrEqual (Node,Node)
  2845. with (drop negator);
  2846. ",
  2847. "f"
  2848. );
  2849. insert into sysbldobjdepends
  2850. (
  2851. bld_id,
  2852. obj_kind,
  2853. obj_signature,
  2854. obj_owner,
  2855. need_obj_kind,
  2856. need_obj_signature,
  2857. need_obj_owner)
  2858. values
  2859. (
  2860. "%SYSBLDNAME%",
  2861. 95, "Alter-Negator-LessThanOrEqual (Node,Node)",
  2862. "%SYSBLDUSER%",
  2863. 5, "LessThanOrEqual (Node,Node)",
  2864. "%SYSBLDUSER%"
  2865. );
  2866. insert into sysbldobjects
  2867. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2868. create_can_fail, drop_sql, drop_can_fail)
  2869. values
  2870. (
  2871. "%SYSBLDNAME%", 101, "Alter-Commutator-LessThanOrEqual (Node,Node)",
  2872. "%SYSBLDUSER%", 0,
  2873. "alter function LessThanOrEqual (Node,Node)
  2874. with (add Commutator=GreaterThan);
  2875. ",
  2876. "f",
  2877. "alter function LessThanOrEqual (Node,Node)
  2878. with (drop Commutator);
  2879. ",
  2880. "f"
  2881. );
  2882. insert into sysbldobjdepends
  2883. (
  2884. bld_id,
  2885. obj_kind,
  2886. obj_signature,
  2887. obj_owner,
  2888. need_obj_kind,
  2889. need_obj_signature,
  2890. need_obj_owner)
  2891. values
  2892. (
  2893. "%SYSBLDNAME%",
  2894. 101, "Alter-Commutator-LessThanOrEqual (Node,Node)",
  2895. "%SYSBLDUSER%",
  2896. 5, "LessThanOrEqual (Node,Node)",
  2897. "%SYSBLDUSER%"
  2898. );
  2899. insert into sysbldobjects
  2900. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2901. create_can_fail, drop_sql, drop_can_fail)
  2902. values
  2903. (
  2904. "%SYSBLDNAME%", 69, "LessThanOrEqual (Node,Node)",
  2905. "%SYSBLDUSER%", 0,
  2906. "grant execute on function LessThanOrEqual (Node,Node) to public;
  2907. ",
  2908. "f",
  2909. "",
  2910. "f"
  2911. );
  2912. insert into sysbldobjdepends
  2913. (
  2914. bld_id,
  2915. obj_kind,
  2916. obj_signature,
  2917. obj_owner,
  2918. need_obj_kind,
  2919. need_obj_signature,
  2920. need_obj_owner)
  2921. values
  2922. (
  2923. "%SYSBLDNAME%",
  2924. 69, "LessThanOrEqual (Node,Node)",
  2925. "%SYSBLDUSER%",
  2926. 5, "LessThanOrEqual (Node,Node)",
  2927. "%SYSBLDUSER%"
  2928. );
  2929. insert into sysbldobjects
  2930. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2931. create_can_fail, drop_sql, drop_can_fail)
  2932. values
  2933. (
  2934. "%SYSBLDNAME%", 5, "GreaterThanOrEqual (Node,Node)",
  2935. "%SYSBLDUSER%", 0,
  2936. "create function GreaterThanOrEqual (Node,Node)
  2937. returns boolean
  2938. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGreaterThanOrEqual)"" language c;
  2939. ",
  2940. "f",
  2941. "drop function GreaterThanOrEqual (Node,Node);
  2942. ",
  2943. "f"
  2944. );
  2945. insert into sysbldobjdepends
  2946. (
  2947. bld_id,
  2948. obj_kind,
  2949. obj_signature,
  2950. obj_owner,
  2951. need_obj_kind,
  2952. need_obj_signature,
  2953. need_obj_owner)
  2954. values
  2955. (
  2956. "%SYSBLDNAME%",
  2957. 5, "GreaterThanOrEqual (Node,Node)",
  2958. "%SYSBLDUSER%",
  2959. 7, "Node",
  2960. "%SYSBLDUSER%"
  2961. );
  2962. insert into sysbldobjects
  2963. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2964. create_can_fail, drop_sql, drop_can_fail)
  2965. values
  2966. (
  2967. "%SYSBLDNAME%", 181, "Alter-ExternalName-GreaterThanOrEqual (Node,Node)",
  2968. "%SYSBLDUSER%", 0,
  2969. "alter function GreaterThanOrEqual (Node,Node)
  2970. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGreaterThanOrEqual)"");
  2971. ",
  2972. "f",
  2973. "alter function GreaterThanOrEqual (Node,Node)
  2974. with (Modify External Name = ""NodeGreaterThanOrEqual"");
  2975. ",
  2976. "f"
  2977. );
  2978. insert into sysbldobjdepends
  2979. (
  2980. bld_id,
  2981. obj_kind,
  2982. obj_signature,
  2983. obj_owner,
  2984. need_obj_kind,
  2985. need_obj_signature,
  2986. need_obj_owner)
  2987. values
  2988. (
  2989. "%SYSBLDNAME%",
  2990. 181, "Alter-ExternalName-GreaterThanOrEqual (Node,Node)",
  2991. "%SYSBLDUSER%",
  2992. 5, "GreaterThanOrEqual (Node,Node)",
  2993. "%SYSBLDUSER%"
  2994. );
  2995. insert into sysbldobjects
  2996. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  2997. create_can_fail, drop_sql, drop_can_fail)
  2998. values
  2999. (
  3000. "%SYSBLDNAME%", 37, "Alter-Parallelize-GreaterThanOrEqual (Node,Node)",
  3001. "%SYSBLDUSER%", 0,
  3002. "alter function GreaterThanOrEqual (Node,Node)
  3003. with (add parallelizable);
  3004. ",
  3005. "f",
  3006. "alter function GreaterThanOrEqual (Node,Node)
  3007. with (drop parallelizable);
  3008. ",
  3009. "f"
  3010. );
  3011. insert into sysbldobjdepends
  3012. (
  3013. bld_id,
  3014. obj_kind,
  3015. obj_signature,
  3016. obj_owner,
  3017. need_obj_kind,
  3018. need_obj_signature,
  3019. need_obj_owner)
  3020. values
  3021. (
  3022. "%SYSBLDNAME%",
  3023. 37, "Alter-Parallelize-GreaterThanOrEqual (Node,Node)",
  3024. "%SYSBLDUSER%",
  3025. 5, "GreaterThanOrEqual (Node,Node)",
  3026. "%SYSBLDUSER%"
  3027. );
  3028. insert into sysbldobjects
  3029. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3030. create_can_fail, drop_sql, drop_can_fail)
  3031. values
  3032. (
  3033. "%SYSBLDNAME%", 85, "Alter-Variant-GreaterThanOrEqual (Node,Node)",
  3034. "%SYSBLDUSER%", 0,
  3035. "alter function GreaterThanOrEqual (Node,Node)
  3036. with (add not variant);
  3037. ",
  3038. "f",
  3039. "alter function GreaterThanOrEqual (Node,Node)
  3040. with (drop not variant);
  3041. ",
  3042. "f"
  3043. );
  3044. insert into sysbldobjdepends
  3045. (
  3046. bld_id,
  3047. obj_kind,
  3048. obj_signature,
  3049. obj_owner,
  3050. need_obj_kind,
  3051. need_obj_signature,
  3052. need_obj_owner)
  3053. values
  3054. (
  3055. "%SYSBLDNAME%",
  3056. 85, "Alter-Variant-GreaterThanOrEqual (Node,Node)",
  3057. "%SYSBLDUSER%",
  3058. 5, "GreaterThanOrEqual (Node,Node)",
  3059. "%SYSBLDUSER%"
  3060. );
  3061. insert into sysbldobjects
  3062. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3063. create_can_fail, drop_sql, drop_can_fail)
  3064. values
  3065. (
  3066. "%SYSBLDNAME%", 95, "Alter-Negator-GreaterThanOrEqual (Node,Node)",
  3067. "%SYSBLDUSER%", 0,
  3068. "alter function GreaterThanOrEqual (Node,Node)
  3069. with (add negator=LessThan);
  3070. ",
  3071. "f",
  3072. "alter function GreaterThanOrEqual (Node,Node)
  3073. with (drop negator);
  3074. ",
  3075. "f"
  3076. );
  3077. insert into sysbldobjdepends
  3078. (
  3079. bld_id,
  3080. obj_kind,
  3081. obj_signature,
  3082. obj_owner,
  3083. need_obj_kind,
  3084. need_obj_signature,
  3085. need_obj_owner)
  3086. values
  3087. (
  3088. "%SYSBLDNAME%",
  3089. 95, "Alter-Negator-GreaterThanOrEqual (Node,Node)",
  3090. "%SYSBLDUSER%",
  3091. 5, "GreaterThanOrEqual (Node,Node)",
  3092. "%SYSBLDUSER%"
  3093. );
  3094. insert into sysbldobjects
  3095. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3096. create_can_fail, drop_sql, drop_can_fail)
  3097. values
  3098. (
  3099. "%SYSBLDNAME%", 101, "Alter-Commutator-GreaterThanOrEqual (Node,Node)",
  3100. "%SYSBLDUSER%", 0,
  3101. "alter function GreaterThanOrEqual (Node,Node)
  3102. with (add Commutator=LessThan);
  3103. ",
  3104. "f",
  3105. "alter function GreaterThanOrEqual (Node,Node)
  3106. with (drop Commutator);
  3107. ",
  3108. "f"
  3109. );
  3110. insert into sysbldobjdepends
  3111. (
  3112. bld_id,
  3113. obj_kind,
  3114. obj_signature,
  3115. obj_owner,
  3116. need_obj_kind,
  3117. need_obj_signature,
  3118. need_obj_owner)
  3119. values
  3120. (
  3121. "%SYSBLDNAME%",
  3122. 101, "Alter-Commutator-GreaterThanOrEqual (Node,Node)",
  3123. "%SYSBLDUSER%",
  3124. 5, "GreaterThanOrEqual (Node,Node)",
  3125. "%SYSBLDUSER%"
  3126. );
  3127. insert into sysbldobjects
  3128. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3129. create_can_fail, drop_sql, drop_can_fail)
  3130. values
  3131. (
  3132. "%SYSBLDNAME%", 69, "GreaterThanOrEqual (Node,Node)",
  3133. "%SYSBLDUSER%", 0,
  3134. "grant execute on function GreaterThanOrEqual (Node,Node) to public;
  3135. ",
  3136. "f",
  3137. "",
  3138. "f"
  3139. );
  3140. insert into sysbldobjdepends
  3141. (
  3142. bld_id,
  3143. obj_kind,
  3144. obj_signature,
  3145. obj_owner,
  3146. need_obj_kind,
  3147. need_obj_signature,
  3148. need_obj_owner)
  3149. values
  3150. (
  3151. "%SYSBLDNAME%",
  3152. 69, "GreaterThanOrEqual (Node,Node)",
  3153. "%SYSBLDUSER%",
  3154. 5, "GreaterThanOrEqual (Node,Node)",
  3155. "%SYSBLDUSER%"
  3156. );
  3157. insert into sysbldobjects
  3158. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3159. create_can_fail, drop_sql, drop_can_fail)
  3160. values
  3161. (
  3162. "%SYSBLDNAME%", 0, "ER",
  3163. "%SYSBLDUSER%", 0,
  3164. "create function streamread (stream, OUT Node) returns integer
  3165. with (not variant, parallelizable) external name
  3166. '$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeStreamRead)' language c;
  3167. grant execute on function streamread(stream,Node) to public;
  3168. create function streamwrite(stream, Node) returns integer
  3169. with (not variant, parallelizable) external name
  3170. '$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeStreamWrite)' language c;
  3171. grant execute on function streamwrite(stream, Node) to public;
  3172. ",
  3173. "f",
  3174. "drop function streamread(stream, Node);
  3175. drop function streamwrite(stream, Node);
  3176. ",
  3177. "f"
  3178. );
  3179. insert into sysbldobjdepends
  3180. (
  3181. bld_id,
  3182. obj_kind,
  3183. obj_signature,
  3184. obj_owner,
  3185. need_obj_kind,
  3186. need_obj_signature,
  3187. need_obj_owner)
  3188. values
  3189. (
  3190. "%SYSBLDNAME%",
  3191. 0, "ER",
  3192. "%SYSBLDUSER%",
  3193. 7, "Node",
  3194. "%SYSBLDUSER%"
  3195. );
  3196. insert into sysbldobjects
  3197. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3198. create_can_fail, drop_sql, drop_can_fail)
  3199. values
  3200. (
  3201. "%SYSBLDNAME%", 5, "Increment (Node,integer)",
  3202. "%SYSBLDUSER%", 0,
  3203. "create function Increment (Node,integer)
  3204. returns Node
  3205. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIncrCnt)"" language c;
  3206. ",
  3207. "f",
  3208. "drop function Increment (Node,integer);
  3209. ",
  3210. "f"
  3211. );
  3212. insert into sysbldobjdepends
  3213. (
  3214. bld_id,
  3215. obj_kind,
  3216. obj_signature,
  3217. obj_owner,
  3218. need_obj_kind,
  3219. need_obj_signature,
  3220. need_obj_owner)
  3221. values
  3222. (
  3223. "%SYSBLDNAME%",
  3224. 5, "Increment (Node,integer)",
  3225. "%SYSBLDUSER%",
  3226. 7, "Node",
  3227. "%SYSBLDUSER%"
  3228. );
  3229. insert into sysbldobjects
  3230. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3231. create_can_fail, drop_sql, drop_can_fail)
  3232. values
  3233. (
  3234. "%SYSBLDNAME%", 181, "Alter-ExternalName-Increment (Node,integer)",
  3235. "%SYSBLDUSER%", 0,
  3236. "alter function Increment (Node,integer)
  3237. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIncrCnt)"");
  3238. ",
  3239. "f",
  3240. "alter function Increment (Node,integer)
  3241. with (Modify External Name = ""NodeIncrCnt"");
  3242. ",
  3243. "f"
  3244. );
  3245. insert into sysbldobjdepends
  3246. (
  3247. bld_id,
  3248. obj_kind,
  3249. obj_signature,
  3250. obj_owner,
  3251. need_obj_kind,
  3252. need_obj_signature,
  3253. need_obj_owner)
  3254. values
  3255. (
  3256. "%SYSBLDNAME%",
  3257. 181, "Alter-ExternalName-Increment (Node,integer)",
  3258. "%SYSBLDUSER%",
  3259. 5, "Increment (Node,integer)",
  3260. "%SYSBLDUSER%"
  3261. );
  3262. insert into sysbldobjects
  3263. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3264. create_can_fail, drop_sql, drop_can_fail)
  3265. values
  3266. (
  3267. "%SYSBLDNAME%", 37, "Alter-Parallelize-Increment (Node,integer)",
  3268. "%SYSBLDUSER%", 0,
  3269. "alter function Increment (Node,integer)
  3270. with (add parallelizable);
  3271. ",
  3272. "f",
  3273. "alter function Increment (Node,integer)
  3274. with (drop parallelizable);
  3275. ",
  3276. "f"
  3277. );
  3278. insert into sysbldobjdepends
  3279. (
  3280. bld_id,
  3281. obj_kind,
  3282. obj_signature,
  3283. obj_owner,
  3284. need_obj_kind,
  3285. need_obj_signature,
  3286. need_obj_owner)
  3287. values
  3288. (
  3289. "%SYSBLDNAME%",
  3290. 37, "Alter-Parallelize-Increment (Node,integer)",
  3291. "%SYSBLDUSER%",
  3292. 5, "Increment (Node,integer)",
  3293. "%SYSBLDUSER%"
  3294. );
  3295. insert into sysbldobjects
  3296. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3297. create_can_fail, drop_sql, drop_can_fail)
  3298. values
  3299. (
  3300. "%SYSBLDNAME%", 85, "Alter-Variant-Increment (Node,integer)",
  3301. "%SYSBLDUSER%", 0,
  3302. "alter function Increment (Node,integer)
  3303. with (add not variant);
  3304. ",
  3305. "f",
  3306. "alter function Increment (Node,integer)
  3307. with (drop not variant);
  3308. ",
  3309. "f"
  3310. );
  3311. insert into sysbldobjdepends
  3312. (
  3313. bld_id,
  3314. obj_kind,
  3315. obj_signature,
  3316. obj_owner,
  3317. need_obj_kind,
  3318. need_obj_signature,
  3319. need_obj_owner)
  3320. values
  3321. (
  3322. "%SYSBLDNAME%",
  3323. 85, "Alter-Variant-Increment (Node,integer)",
  3324. "%SYSBLDUSER%",
  3325. 5, "Increment (Node,integer)",
  3326. "%SYSBLDUSER%"
  3327. );
  3328. insert into sysbldobjects
  3329. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3330. create_can_fail, drop_sql, drop_can_fail)
  3331. values
  3332. (
  3333. "%SYSBLDNAME%", 69, "Increment (Node,integer)",
  3334. "%SYSBLDUSER%", 0,
  3335. "grant execute on function Increment (Node,integer) to public;
  3336. ",
  3337. "f",
  3338. "",
  3339. "f"
  3340. );
  3341. insert into sysbldobjdepends
  3342. (
  3343. bld_id,
  3344. obj_kind,
  3345. obj_signature,
  3346. obj_owner,
  3347. need_obj_kind,
  3348. need_obj_signature,
  3349. need_obj_owner)
  3350. values
  3351. (
  3352. "%SYSBLDNAME%",
  3353. 69, "Increment (Node,integer)",
  3354. "%SYSBLDUSER%",
  3355. 5, "Increment (Node,integer)",
  3356. "%SYSBLDUSER%"
  3357. );
  3358. insert into sysbldobjects
  3359. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3360. create_can_fail, drop_sql, drop_can_fail)
  3361. values
  3362. (
  3363. "%SYSBLDNAME%", 5, "Increment (Node)",
  3364. "%SYSBLDUSER%", 0,
  3365. "create function Increment (Node)
  3366. returns Node
  3367. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIncr)"" language c;
  3368. ",
  3369. "f",
  3370. "drop function Increment (Node);
  3371. ",
  3372. "f"
  3373. );
  3374. insert into sysbldobjdepends
  3375. (
  3376. bld_id,
  3377. obj_kind,
  3378. obj_signature,
  3379. obj_owner,
  3380. need_obj_kind,
  3381. need_obj_signature,
  3382. need_obj_owner)
  3383. values
  3384. (
  3385. "%SYSBLDNAME%",
  3386. 5, "Increment (Node)",
  3387. "%SYSBLDUSER%",
  3388. 7, "Node",
  3389. "%SYSBLDUSER%"
  3390. );
  3391. insert into sysbldobjects
  3392. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3393. create_can_fail, drop_sql, drop_can_fail)
  3394. values
  3395. (
  3396. "%SYSBLDNAME%", 181, "Alter-ExternalName-Increment (Node)",
  3397. "%SYSBLDUSER%", 0,
  3398. "alter function Increment (Node)
  3399. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIncr)"");
  3400. ",
  3401. "f",
  3402. "alter function Increment (Node)
  3403. with (Modify External Name = ""NodeIncr"");
  3404. ",
  3405. "f"
  3406. );
  3407. insert into sysbldobjdepends
  3408. (
  3409. bld_id,
  3410. obj_kind,
  3411. obj_signature,
  3412. obj_owner,
  3413. need_obj_kind,
  3414. need_obj_signature,
  3415. need_obj_owner)
  3416. values
  3417. (
  3418. "%SYSBLDNAME%",
  3419. 181, "Alter-ExternalName-Increment (Node)",
  3420. "%SYSBLDUSER%",
  3421. 5, "Increment (Node)",
  3422. "%SYSBLDUSER%"
  3423. );
  3424. insert into sysbldobjects
  3425. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3426. create_can_fail, drop_sql, drop_can_fail)
  3427. values
  3428. (
  3429. "%SYSBLDNAME%", 37, "Alter-Parallelize-Increment (Node)",
  3430. "%SYSBLDUSER%", 0,
  3431. "alter function Increment (Node)
  3432. with (add parallelizable);
  3433. ",
  3434. "f",
  3435. "alter function Increment (Node)
  3436. with (drop parallelizable);
  3437. ",
  3438. "f"
  3439. );
  3440. insert into sysbldobjdepends
  3441. (
  3442. bld_id,
  3443. obj_kind,
  3444. obj_signature,
  3445. obj_owner,
  3446. need_obj_kind,
  3447. need_obj_signature,
  3448. need_obj_owner)
  3449. values
  3450. (
  3451. "%SYSBLDNAME%",
  3452. 37, "Alter-Parallelize-Increment (Node)",
  3453. "%SYSBLDUSER%",
  3454. 5, "Increment (Node)",
  3455. "%SYSBLDUSER%"
  3456. );
  3457. insert into sysbldobjects
  3458. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3459. create_can_fail, drop_sql, drop_can_fail)
  3460. values
  3461. (
  3462. "%SYSBLDNAME%", 85, "Alter-Variant-Increment (Node)",
  3463. "%SYSBLDUSER%", 0,
  3464. "alter function Increment (Node)
  3465. with (add not variant);
  3466. ",
  3467. "f",
  3468. "alter function Increment (Node)
  3469. with (drop not variant);
  3470. ",
  3471. "f"
  3472. );
  3473. insert into sysbldobjdepends
  3474. (
  3475. bld_id,
  3476. obj_kind,
  3477. obj_signature,
  3478. obj_owner,
  3479. need_obj_kind,
  3480. need_obj_signature,
  3481. need_obj_owner)
  3482. values
  3483. (
  3484. "%SYSBLDNAME%",
  3485. 85, "Alter-Variant-Increment (Node)",
  3486. "%SYSBLDUSER%",
  3487. 5, "Increment (Node)",
  3488. "%SYSBLDUSER%"
  3489. );
  3490. insert into sysbldobjects
  3491. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3492. create_can_fail, drop_sql, drop_can_fail)
  3493. values
  3494. (
  3495. "%SYSBLDNAME%", 69, "Increment (Node)",
  3496. "%SYSBLDUSER%", 0,
  3497. "grant execute on function Increment (Node) to public;
  3498. ",
  3499. "f",
  3500. "",
  3501. "f"
  3502. );
  3503. insert into sysbldobjdepends
  3504. (
  3505. bld_id,
  3506. obj_kind,
  3507. obj_signature,
  3508. obj_owner,
  3509. need_obj_kind,
  3510. need_obj_signature,
  3511. need_obj_owner)
  3512. values
  3513. (
  3514. "%SYSBLDNAME%",
  3515. 69, "Increment (Node)",
  3516. "%SYSBLDUSER%",
  3517. 5, "Increment (Node)",
  3518. "%SYSBLDUSER%"
  3519. );
  3520. insert into sysbldobjects
  3521. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3522. create_can_fail, drop_sql, drop_can_fail)
  3523. values
  3524. (
  3525. "%SYSBLDNAME%", 5, "Depth (Node)",
  3526. "%SYSBLDUSER%", 0,
  3527. "create function Depth (Node)
  3528. returns integer
  3529. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeDepth)"" language c;
  3530. ",
  3531. "f",
  3532. "drop function Depth (Node);
  3533. ",
  3534. "f"
  3535. );
  3536. insert into sysbldobjdepends
  3537. (
  3538. bld_id,
  3539. obj_kind,
  3540. obj_signature,
  3541. obj_owner,
  3542. need_obj_kind,
  3543. need_obj_signature,
  3544. need_obj_owner)
  3545. values
  3546. (
  3547. "%SYSBLDNAME%",
  3548. 5, "Depth (Node)",
  3549. "%SYSBLDUSER%",
  3550. 7, "Node",
  3551. "%SYSBLDUSER%"
  3552. );
  3553. insert into sysbldobjects
  3554. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3555. create_can_fail, drop_sql, drop_can_fail)
  3556. values
  3557. (
  3558. "%SYSBLDNAME%", 181, "Alter-ExternalName-Depth (Node)",
  3559. "%SYSBLDUSER%", 0,
  3560. "alter function Depth (Node)
  3561. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeDepth)"");
  3562. ",
  3563. "f",
  3564. "alter function Depth (Node)
  3565. with (Modify External Name = ""NodeDepth"");
  3566. ",
  3567. "f"
  3568. );
  3569. insert into sysbldobjdepends
  3570. (
  3571. bld_id,
  3572. obj_kind,
  3573. obj_signature,
  3574. obj_owner,
  3575. need_obj_kind,
  3576. need_obj_signature,
  3577. need_obj_owner)
  3578. values
  3579. (
  3580. "%SYSBLDNAME%",
  3581. 181, "Alter-ExternalName-Depth (Node)",
  3582. "%SYSBLDUSER%",
  3583. 5, "Depth (Node)",
  3584. "%SYSBLDUSER%"
  3585. );
  3586. insert into sysbldobjects
  3587. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3588. create_can_fail, drop_sql, drop_can_fail)
  3589. values
  3590. (
  3591. "%SYSBLDNAME%", 37, "Alter-Parallelize-Depth (Node)",
  3592. "%SYSBLDUSER%", 0,
  3593. "alter function Depth (Node)
  3594. with (add parallelizable);
  3595. ",
  3596. "f",
  3597. "alter function Depth (Node)
  3598. with (drop parallelizable);
  3599. ",
  3600. "f"
  3601. );
  3602. insert into sysbldobjdepends
  3603. (
  3604. bld_id,
  3605. obj_kind,
  3606. obj_signature,
  3607. obj_owner,
  3608. need_obj_kind,
  3609. need_obj_signature,
  3610. need_obj_owner)
  3611. values
  3612. (
  3613. "%SYSBLDNAME%",
  3614. 37, "Alter-Parallelize-Depth (Node)",
  3615. "%SYSBLDUSER%",
  3616. 5, "Depth (Node)",
  3617. "%SYSBLDUSER%"
  3618. );
  3619. insert into sysbldobjects
  3620. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3621. create_can_fail, drop_sql, drop_can_fail)
  3622. values
  3623. (
  3624. "%SYSBLDNAME%", 85, "Alter-Variant-Depth (Node)",
  3625. "%SYSBLDUSER%", 0,
  3626. "alter function Depth (Node)
  3627. with (add not variant);
  3628. ",
  3629. "f",
  3630. "alter function Depth (Node)
  3631. with (drop not variant);
  3632. ",
  3633. "f"
  3634. );
  3635. insert into sysbldobjdepends
  3636. (
  3637. bld_id,
  3638. obj_kind,
  3639. obj_signature,
  3640. obj_owner,
  3641. need_obj_kind,
  3642. need_obj_signature,
  3643. need_obj_owner)
  3644. values
  3645. (
  3646. "%SYSBLDNAME%",
  3647. 85, "Alter-Variant-Depth (Node)",
  3648. "%SYSBLDUSER%",
  3649. 5, "Depth (Node)",
  3650. "%SYSBLDUSER%"
  3651. );
  3652. insert into sysbldobjects
  3653. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3654. create_can_fail, drop_sql, drop_can_fail)
  3655. values
  3656. (
  3657. "%SYSBLDNAME%", 69, "Depth (Node)",
  3658. "%SYSBLDUSER%", 0,
  3659. "grant execute on function Depth (Node) to public;
  3660. ",
  3661. "f",
  3662. "",
  3663. "f"
  3664. );
  3665. insert into sysbldobjdepends
  3666. (
  3667. bld_id,
  3668. obj_kind,
  3669. obj_signature,
  3670. obj_owner,
  3671. need_obj_kind,
  3672. need_obj_signature,
  3673. need_obj_owner)
  3674. values
  3675. (
  3676. "%SYSBLDNAME%",
  3677. 69, "Depth (Node)",
  3678. "%SYSBLDUSER%",
  3679. 5, "Depth (Node)",
  3680. "%SYSBLDUSER%"
  3681. );
  3682. insert into sysbldobjects
  3683. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3684. create_can_fail, drop_sql, drop_can_fail)
  3685. values
  3686. (
  3687. "%SYSBLDNAME%", 5, "GetMember (Node,integer)",
  3688. "%SYSBLDUSER%", 0,
  3689. "create function GetMember (Node,integer)
  3690. returns integer
  3691. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGetMember)"" language c;
  3692. ",
  3693. "f",
  3694. "drop function GetMember (Node,integer);
  3695. ",
  3696. "f"
  3697. );
  3698. insert into sysbldobjdepends
  3699. (
  3700. bld_id,
  3701. obj_kind,
  3702. obj_signature,
  3703. obj_owner,
  3704. need_obj_kind,
  3705. need_obj_signature,
  3706. need_obj_owner)
  3707. values
  3708. (
  3709. "%SYSBLDNAME%",
  3710. 5, "GetMember (Node,integer)",
  3711. "%SYSBLDUSER%",
  3712. 7, "Node",
  3713. "%SYSBLDUSER%"
  3714. );
  3715. insert into sysbldobjects
  3716. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3717. create_can_fail, drop_sql, drop_can_fail)
  3718. values
  3719. (
  3720. "%SYSBLDNAME%", 181, "Alter-ExternalName-GetMember (Node,integer)",
  3721. "%SYSBLDUSER%", 0,
  3722. "alter function GetMember (Node,integer)
  3723. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGetMember)"");
  3724. ",
  3725. "f",
  3726. "alter function GetMember (Node,integer)
  3727. with (Modify External Name = ""NodeGetMember"");
  3728. ",
  3729. "f"
  3730. );
  3731. insert into sysbldobjdepends
  3732. (
  3733. bld_id,
  3734. obj_kind,
  3735. obj_signature,
  3736. obj_owner,
  3737. need_obj_kind,
  3738. need_obj_signature,
  3739. need_obj_owner)
  3740. values
  3741. (
  3742. "%SYSBLDNAME%",
  3743. 181, "Alter-ExternalName-GetMember (Node,integer)",
  3744. "%SYSBLDUSER%",
  3745. 5, "GetMember (Node,integer)",
  3746. "%SYSBLDUSER%"
  3747. );
  3748. insert into sysbldobjects
  3749. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3750. create_can_fail, drop_sql, drop_can_fail)
  3751. values
  3752. (
  3753. "%SYSBLDNAME%", 37, "Alter-Parallelize-GetMember (Node,integer)",
  3754. "%SYSBLDUSER%", 0,
  3755. "alter function GetMember (Node,integer)
  3756. with (add parallelizable);
  3757. ",
  3758. "f",
  3759. "alter function GetMember (Node,integer)
  3760. with (drop parallelizable);
  3761. ",
  3762. "f"
  3763. );
  3764. insert into sysbldobjdepends
  3765. (
  3766. bld_id,
  3767. obj_kind,
  3768. obj_signature,
  3769. obj_owner,
  3770. need_obj_kind,
  3771. need_obj_signature,
  3772. need_obj_owner)
  3773. values
  3774. (
  3775. "%SYSBLDNAME%",
  3776. 37, "Alter-Parallelize-GetMember (Node,integer)",
  3777. "%SYSBLDUSER%",
  3778. 5, "GetMember (Node,integer)",
  3779. "%SYSBLDUSER%"
  3780. );
  3781. insert into sysbldobjects
  3782. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3783. create_can_fail, drop_sql, drop_can_fail)
  3784. values
  3785. (
  3786. "%SYSBLDNAME%", 85, "Alter-Variant-GetMember (Node,integer)",
  3787. "%SYSBLDUSER%", 0,
  3788. "alter function GetMember (Node,integer)
  3789. with (add not variant);
  3790. ",
  3791. "f",
  3792. "alter function GetMember (Node,integer)
  3793. with (drop not variant);
  3794. ",
  3795. "f"
  3796. );
  3797. insert into sysbldobjdepends
  3798. (
  3799. bld_id,
  3800. obj_kind,
  3801. obj_signature,
  3802. obj_owner,
  3803. need_obj_kind,
  3804. need_obj_signature,
  3805. need_obj_owner)
  3806. values
  3807. (
  3808. "%SYSBLDNAME%",
  3809. 85, "Alter-Variant-GetMember (Node,integer)",
  3810. "%SYSBLDUSER%",
  3811. 5, "GetMember (Node,integer)",
  3812. "%SYSBLDUSER%"
  3813. );
  3814. insert into sysbldobjects
  3815. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3816. create_can_fail, drop_sql, drop_can_fail)
  3817. values
  3818. (
  3819. "%SYSBLDNAME%", 69, "GetMember (Node,integer)",
  3820. "%SYSBLDUSER%", 0,
  3821. "grant execute on function GetMember (Node,integer) to public;
  3822. ",
  3823. "f",
  3824. "",
  3825. "f"
  3826. );
  3827. insert into sysbldobjdepends
  3828. (
  3829. bld_id,
  3830. obj_kind,
  3831. obj_signature,
  3832. obj_owner,
  3833. need_obj_kind,
  3834. need_obj_signature,
  3835. need_obj_owner)
  3836. values
  3837. (
  3838. "%SYSBLDNAME%",
  3839. 69, "GetMember (Node,integer)",
  3840. "%SYSBLDUSER%",
  3841. 5, "GetMember (Node,integer)",
  3842. "%SYSBLDUSER%"
  3843. );
  3844. insert into sysbldobjects
  3845. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3846. create_can_fail, drop_sql, drop_can_fail)
  3847. values
  3848. (
  3849. "%SYSBLDNAME%", 5, "GetParent (Node)",
  3850. "%SYSBLDUSER%", 0,
  3851. "create function GetParent (Node)
  3852. returns Node
  3853. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGetParent)"" language c;
  3854. ",
  3855. "f",
  3856. "drop function GetParent (Node);
  3857. ",
  3858. "f"
  3859. );
  3860. insert into sysbldobjdepends
  3861. (
  3862. bld_id,
  3863. obj_kind,
  3864. obj_signature,
  3865. obj_owner,
  3866. need_obj_kind,
  3867. need_obj_signature,
  3868. need_obj_owner)
  3869. values
  3870. (
  3871. "%SYSBLDNAME%",
  3872. 5, "GetParent (Node)",
  3873. "%SYSBLDUSER%",
  3874. 7, "Node",
  3875. "%SYSBLDUSER%"
  3876. );
  3877. insert into sysbldobjects
  3878. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3879. create_can_fail, drop_sql, drop_can_fail)
  3880. values
  3881. (
  3882. "%SYSBLDNAME%", 181, "Alter-ExternalName-GetParent (Node)",
  3883. "%SYSBLDUSER%", 0,
  3884. "alter function GetParent (Node)
  3885. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGetParent)"");
  3886. ",
  3887. "f",
  3888. "alter function GetParent (Node)
  3889. with (Modify External Name = ""NodeGetParent"");
  3890. ",
  3891. "f"
  3892. );
  3893. insert into sysbldobjdepends
  3894. (
  3895. bld_id,
  3896. obj_kind,
  3897. obj_signature,
  3898. obj_owner,
  3899. need_obj_kind,
  3900. need_obj_signature,
  3901. need_obj_owner)
  3902. values
  3903. (
  3904. "%SYSBLDNAME%",
  3905. 181, "Alter-ExternalName-GetParent (Node)",
  3906. "%SYSBLDUSER%",
  3907. 5, "GetParent (Node)",
  3908. "%SYSBLDUSER%"
  3909. );
  3910. insert into sysbldobjects
  3911. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3912. create_can_fail, drop_sql, drop_can_fail)
  3913. values
  3914. (
  3915. "%SYSBLDNAME%", 37, "Alter-Parallelize-GetParent (Node)",
  3916. "%SYSBLDUSER%", 0,
  3917. "alter function GetParent (Node)
  3918. with (add parallelizable);
  3919. ",
  3920. "f",
  3921. "alter function GetParent (Node)
  3922. with (drop parallelizable);
  3923. ",
  3924. "f"
  3925. );
  3926. insert into sysbldobjdepends
  3927. (
  3928. bld_id,
  3929. obj_kind,
  3930. obj_signature,
  3931. obj_owner,
  3932. need_obj_kind,
  3933. need_obj_signature,
  3934. need_obj_owner)
  3935. values
  3936. (
  3937. "%SYSBLDNAME%",
  3938. 37, "Alter-Parallelize-GetParent (Node)",
  3939. "%SYSBLDUSER%",
  3940. 5, "GetParent (Node)",
  3941. "%SYSBLDUSER%"
  3942. );
  3943. insert into sysbldobjects
  3944. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3945. create_can_fail, drop_sql, drop_can_fail)
  3946. values
  3947. (
  3948. "%SYSBLDNAME%", 85, "Alter-Variant-GetParent (Node)",
  3949. "%SYSBLDUSER%", 0,
  3950. "alter function GetParent (Node)
  3951. with (add not variant);
  3952. ",
  3953. "f",
  3954. "alter function GetParent (Node)
  3955. with (drop not variant);
  3956. ",
  3957. "f"
  3958. );
  3959. insert into sysbldobjdepends
  3960. (
  3961. bld_id,
  3962. obj_kind,
  3963. obj_signature,
  3964. obj_owner,
  3965. need_obj_kind,
  3966. need_obj_signature,
  3967. need_obj_owner)
  3968. values
  3969. (
  3970. "%SYSBLDNAME%",
  3971. 85, "Alter-Variant-GetParent (Node)",
  3972. "%SYSBLDUSER%",
  3973. 5, "GetParent (Node)",
  3974. "%SYSBLDUSER%"
  3975. );
  3976. insert into sysbldobjects
  3977. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  3978. create_can_fail, drop_sql, drop_can_fail)
  3979. values
  3980. (
  3981. "%SYSBLDNAME%", 69, "GetParent (Node)",
  3982. "%SYSBLDUSER%", 0,
  3983. "grant execute on function GetParent (Node) to public;
  3984. ",
  3985. "f",
  3986. "",
  3987. "f"
  3988. );
  3989. insert into sysbldobjdepends
  3990. (
  3991. bld_id,
  3992. obj_kind,
  3993. obj_signature,
  3994. obj_owner,
  3995. need_obj_kind,
  3996. need_obj_signature,
  3997. need_obj_owner)
  3998. values
  3999. (
  4000. "%SYSBLDNAME%",
  4001. 69, "GetParent (Node)",
  4002. "%SYSBLDUSER%",
  4003. 5, "GetParent (Node)",
  4004. "%SYSBLDUSER%"
  4005. );
  4006. insert into sysbldobjects
  4007. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4008. create_can_fail, drop_sql, drop_can_fail)
  4009. values
  4010. (
  4011. "%SYSBLDNAME%", 5, "IsParent (Node,Node)",
  4012. "%SYSBLDUSER%", 0,
  4013. "create function IsParent (Node,Node)
  4014. returns boolean
  4015. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsParent)"" language c;
  4016. ",
  4017. "f",
  4018. "drop function IsParent (Node,Node);
  4019. ",
  4020. "f"
  4021. );
  4022. insert into sysbldobjdepends
  4023. (
  4024. bld_id,
  4025. obj_kind,
  4026. obj_signature,
  4027. obj_owner,
  4028. need_obj_kind,
  4029. need_obj_signature,
  4030. need_obj_owner)
  4031. values
  4032. (
  4033. "%SYSBLDNAME%",
  4034. 5, "IsParent (Node,Node)",
  4035. "%SYSBLDUSER%",
  4036. 7, "Node",
  4037. "%SYSBLDUSER%"
  4038. );
  4039. insert into sysbldobjects
  4040. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4041. create_can_fail, drop_sql, drop_can_fail)
  4042. values
  4043. (
  4044. "%SYSBLDNAME%", 181, "Alter-ExternalName-IsParent (Node,Node)",
  4045. "%SYSBLDUSER%", 0,
  4046. "alter function IsParent (Node,Node)
  4047. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsParent)"");
  4048. ",
  4049. "f",
  4050. "alter function IsParent (Node,Node)
  4051. with (Modify External Name = ""NodeIsParent"");
  4052. ",
  4053. "f"
  4054. );
  4055. insert into sysbldobjdepends
  4056. (
  4057. bld_id,
  4058. obj_kind,
  4059. obj_signature,
  4060. obj_owner,
  4061. need_obj_kind,
  4062. need_obj_signature,
  4063. need_obj_owner)
  4064. values
  4065. (
  4066. "%SYSBLDNAME%",
  4067. 181, "Alter-ExternalName-IsParent (Node,Node)",
  4068. "%SYSBLDUSER%",
  4069. 5, "IsParent (Node,Node)",
  4070. "%SYSBLDUSER%"
  4071. );
  4072. insert into sysbldobjects
  4073. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4074. create_can_fail, drop_sql, drop_can_fail)
  4075. values
  4076. (
  4077. "%SYSBLDNAME%", 37, "Alter-Parallelize-IsParent (Node,Node)",
  4078. "%SYSBLDUSER%", 0,
  4079. "alter function IsParent (Node,Node)
  4080. with (add parallelizable);
  4081. ",
  4082. "f",
  4083. "alter function IsParent (Node,Node)
  4084. with (drop parallelizable);
  4085. ",
  4086. "f"
  4087. );
  4088. insert into sysbldobjdepends
  4089. (
  4090. bld_id,
  4091. obj_kind,
  4092. obj_signature,
  4093. obj_owner,
  4094. need_obj_kind,
  4095. need_obj_signature,
  4096. need_obj_owner)
  4097. values
  4098. (
  4099. "%SYSBLDNAME%",
  4100. 37, "Alter-Parallelize-IsParent (Node,Node)",
  4101. "%SYSBLDUSER%",
  4102. 5, "IsParent (Node,Node)",
  4103. "%SYSBLDUSER%"
  4104. );
  4105. insert into sysbldobjects
  4106. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4107. create_can_fail, drop_sql, drop_can_fail)
  4108. values
  4109. (
  4110. "%SYSBLDNAME%", 85, "Alter-Variant-IsParent (Node,Node)",
  4111. "%SYSBLDUSER%", 0,
  4112. "alter function IsParent (Node,Node)
  4113. with (add not variant);
  4114. ",
  4115. "f",
  4116. "alter function IsParent (Node,Node)
  4117. with (drop not variant);
  4118. ",
  4119. "f"
  4120. );
  4121. insert into sysbldobjdepends
  4122. (
  4123. bld_id,
  4124. obj_kind,
  4125. obj_signature,
  4126. obj_owner,
  4127. need_obj_kind,
  4128. need_obj_signature,
  4129. need_obj_owner)
  4130. values
  4131. (
  4132. "%SYSBLDNAME%",
  4133. 85, "Alter-Variant-IsParent (Node,Node)",
  4134. "%SYSBLDUSER%",
  4135. 5, "IsParent (Node,Node)",
  4136. "%SYSBLDUSER%"
  4137. );
  4138. insert into sysbldobjects
  4139. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4140. create_can_fail, drop_sql, drop_can_fail)
  4141. values
  4142. (
  4143. "%SYSBLDNAME%", 69, "IsParent (Node,Node)",
  4144. "%SYSBLDUSER%", 0,
  4145. "grant execute on function IsParent (Node,Node) to public;
  4146. ",
  4147. "f",
  4148. "",
  4149. "f"
  4150. );
  4151. insert into sysbldobjdepends
  4152. (
  4153. bld_id,
  4154. obj_kind,
  4155. obj_signature,
  4156. obj_owner,
  4157. need_obj_kind,
  4158. need_obj_signature,
  4159. need_obj_owner)
  4160. values
  4161. (
  4162. "%SYSBLDNAME%",
  4163. 69, "IsParent (Node,Node)",
  4164. "%SYSBLDUSER%",
  4165. 5, "IsParent (Node,Node)",
  4166. "%SYSBLDUSER%"
  4167. );
  4168. insert into sysbldobjects
  4169. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4170. create_can_fail, drop_sql, drop_can_fail)
  4171. values
  4172. (
  4173. "%SYSBLDNAME%", 5, "IsChild (Node,Node)",
  4174. "%SYSBLDUSER%", 0,
  4175. "create function IsChild (Node,Node)
  4176. returns boolean
  4177. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsChild)"" language c;
  4178. ",
  4179. "f",
  4180. "drop function IsChild (Node,Node);
  4181. ",
  4182. "f"
  4183. );
  4184. insert into sysbldobjdepends
  4185. (
  4186. bld_id,
  4187. obj_kind,
  4188. obj_signature,
  4189. obj_owner,
  4190. need_obj_kind,
  4191. need_obj_signature,
  4192. need_obj_owner)
  4193. values
  4194. (
  4195. "%SYSBLDNAME%",
  4196. 5, "IsChild (Node,Node)",
  4197. "%SYSBLDUSER%",
  4198. 7, "Node",
  4199. "%SYSBLDUSER%"
  4200. );
  4201. insert into sysbldobjects
  4202. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4203. create_can_fail, drop_sql, drop_can_fail)
  4204. values
  4205. (
  4206. "%SYSBLDNAME%", 181, "Alter-ExternalName-IsChild (Node,Node)",
  4207. "%SYSBLDUSER%", 0,
  4208. "alter function IsChild (Node,Node)
  4209. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsChild)"");
  4210. ",
  4211. "f",
  4212. "alter function IsChild (Node,Node)
  4213. with (Modify External Name = ""NodeIsChild"");
  4214. ",
  4215. "f"
  4216. );
  4217. insert into sysbldobjdepends
  4218. (
  4219. bld_id,
  4220. obj_kind,
  4221. obj_signature,
  4222. obj_owner,
  4223. need_obj_kind,
  4224. need_obj_signature,
  4225. need_obj_owner)
  4226. values
  4227. (
  4228. "%SYSBLDNAME%",
  4229. 181, "Alter-ExternalName-IsChild (Node,Node)",
  4230. "%SYSBLDUSER%",
  4231. 5, "IsChild (Node,Node)",
  4232. "%SYSBLDUSER%"
  4233. );
  4234. insert into sysbldobjects
  4235. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4236. create_can_fail, drop_sql, drop_can_fail)
  4237. values
  4238. (
  4239. "%SYSBLDNAME%", 37, "Alter-Parallelize-IsChild (Node,Node)",
  4240. "%SYSBLDUSER%", 0,
  4241. "alter function IsChild (Node,Node)
  4242. with (add parallelizable);
  4243. ",
  4244. "f",
  4245. "alter function IsChild (Node,Node)
  4246. with (drop parallelizable);
  4247. ",
  4248. "f"
  4249. );
  4250. insert into sysbldobjdepends
  4251. (
  4252. bld_id,
  4253. obj_kind,
  4254. obj_signature,
  4255. obj_owner,
  4256. need_obj_kind,
  4257. need_obj_signature,
  4258. need_obj_owner)
  4259. values
  4260. (
  4261. "%SYSBLDNAME%",
  4262. 37, "Alter-Parallelize-IsChild (Node,Node)",
  4263. "%SYSBLDUSER%",
  4264. 5, "IsChild (Node,Node)",
  4265. "%SYSBLDUSER%"
  4266. );
  4267. insert into sysbldobjects
  4268. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4269. create_can_fail, drop_sql, drop_can_fail)
  4270. values
  4271. (
  4272. "%SYSBLDNAME%", 85, "Alter-Variant-IsChild (Node,Node)",
  4273. "%SYSBLDUSER%", 0,
  4274. "alter function IsChild (Node,Node)
  4275. with (add not variant);
  4276. ",
  4277. "f",
  4278. "alter function IsChild (Node,Node)
  4279. with (drop not variant);
  4280. ",
  4281. "f"
  4282. );
  4283. insert into sysbldobjdepends
  4284. (
  4285. bld_id,
  4286. obj_kind,
  4287. obj_signature,
  4288. obj_owner,
  4289. need_obj_kind,
  4290. need_obj_signature,
  4291. need_obj_owner)
  4292. values
  4293. (
  4294. "%SYSBLDNAME%",
  4295. 85, "Alter-Variant-IsChild (Node,Node)",
  4296. "%SYSBLDUSER%",
  4297. 5, "IsChild (Node,Node)",
  4298. "%SYSBLDUSER%"
  4299. );
  4300. insert into sysbldobjects
  4301. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4302. create_can_fail, drop_sql, drop_can_fail)
  4303. values
  4304. (
  4305. "%SYSBLDNAME%", 69, "IsChild (Node,Node)",
  4306. "%SYSBLDUSER%", 0,
  4307. "grant execute on function IsChild (Node,Node) to public;
  4308. ",
  4309. "f",
  4310. "",
  4311. "f"
  4312. );
  4313. insert into sysbldobjdepends
  4314. (
  4315. bld_id,
  4316. obj_kind,
  4317. obj_signature,
  4318. obj_owner,
  4319. need_obj_kind,
  4320. need_obj_signature,
  4321. need_obj_owner)
  4322. values
  4323. (
  4324. "%SYSBLDNAME%",
  4325. 69, "IsChild (Node,Node)",
  4326. "%SYSBLDUSER%",
  4327. 5, "IsChild (Node,Node)",
  4328. "%SYSBLDUSER%"
  4329. );
  4330. insert into sysbldobjects
  4331. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4332. create_can_fail, drop_sql, drop_can_fail)
  4333. values
  4334. (
  4335. "%SYSBLDNAME%", 5, "Ancestors (Node)",
  4336. "%SYSBLDUSER%", 0,
  4337. "create function Ancestors (Node)
  4338. returns Node
  4339. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeAncestors)"" language c;
  4340. ",
  4341. "f",
  4342. "drop function Ancestors (Node);
  4343. ",
  4344. "f"
  4345. );
  4346. insert into sysbldobjdepends
  4347. (
  4348. bld_id,
  4349. obj_kind,
  4350. obj_signature,
  4351. obj_owner,
  4352. need_obj_kind,
  4353. need_obj_signature,
  4354. need_obj_owner)
  4355. values
  4356. (
  4357. "%SYSBLDNAME%",
  4358. 5, "Ancestors (Node)",
  4359. "%SYSBLDUSER%",
  4360. 7, "Node",
  4361. "%SYSBLDUSER%"
  4362. );
  4363. insert into sysbldobjects
  4364. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4365. create_can_fail, drop_sql, drop_can_fail)
  4366. values
  4367. (
  4368. "%SYSBLDNAME%", 181, "Alter-ExternalName-Ancestors (Node)",
  4369. "%SYSBLDUSER%", 0,
  4370. "alter function Ancestors (Node)
  4371. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeAncestors)"");
  4372. ",
  4373. "f",
  4374. "alter function Ancestors (Node)
  4375. with (Modify External Name = ""NodeAncestors"");
  4376. ",
  4377. "f"
  4378. );
  4379. insert into sysbldobjdepends
  4380. (
  4381. bld_id,
  4382. obj_kind,
  4383. obj_signature,
  4384. obj_owner,
  4385. need_obj_kind,
  4386. need_obj_signature,
  4387. need_obj_owner)
  4388. values
  4389. (
  4390. "%SYSBLDNAME%",
  4391. 181, "Alter-ExternalName-Ancestors (Node)",
  4392. "%SYSBLDUSER%",
  4393. 5, "Ancestors (Node)",
  4394. "%SYSBLDUSER%"
  4395. );
  4396. insert into sysbldobjects
  4397. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4398. create_can_fail, drop_sql, drop_can_fail)
  4399. values
  4400. (
  4401. "%SYSBLDNAME%", 111, "Alter-Iterator-Ancestors (Node)",
  4402. "%SYSBLDUSER%", 0,
  4403. "alter function Ancestors (Node)
  4404. with (add iterator);
  4405. ",
  4406. "f",
  4407. "alter function Ancestors (Node)
  4408. with (drop iterator);
  4409. ",
  4410. "f"
  4411. );
  4412. insert into sysbldobjdepends
  4413. (
  4414. bld_id,
  4415. obj_kind,
  4416. obj_signature,
  4417. obj_owner,
  4418. need_obj_kind,
  4419. need_obj_signature,
  4420. need_obj_owner)
  4421. values
  4422. (
  4423. "%SYSBLDNAME%",
  4424. 111, "Alter-Iterator-Ancestors (Node)",
  4425. "%SYSBLDUSER%",
  4426. 5, "Ancestors (Node)",
  4427. "%SYSBLDUSER%"
  4428. );
  4429. insert into sysbldobjects
  4430. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4431. create_can_fail, drop_sql, drop_can_fail)
  4432. values
  4433. (
  4434. "%SYSBLDNAME%", 69, "Ancestors (Node)",
  4435. "%SYSBLDUSER%", 0,
  4436. "grant execute on function Ancestors (Node) to public;
  4437. ",
  4438. "f",
  4439. "",
  4440. "f"
  4441. );
  4442. insert into sysbldobjdepends
  4443. (
  4444. bld_id,
  4445. obj_kind,
  4446. obj_signature,
  4447. obj_owner,
  4448. need_obj_kind,
  4449. need_obj_signature,
  4450. need_obj_owner)
  4451. values
  4452. (
  4453. "%SYSBLDNAME%",
  4454. 69, "Ancestors (Node)",
  4455. "%SYSBLDUSER%",
  4456. 5, "Ancestors (Node)",
  4457. "%SYSBLDUSER%"
  4458. );
  4459. insert into sysbldobjects
  4460. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4461. create_can_fail, drop_sql, drop_can_fail)
  4462. values
  4463. (
  4464. "%SYSBLDNAME%", 5, "IsAncestor (Node,Node)",
  4465. "%SYSBLDUSER%", 0,
  4466. "create function IsAncestor (Node,Node)
  4467. returns boolean
  4468. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsAncestor)"" language c;
  4469. ",
  4470. "f",
  4471. "drop function IsAncestor (Node,Node);
  4472. ",
  4473. "f"
  4474. );
  4475. insert into sysbldobjdepends
  4476. (
  4477. bld_id,
  4478. obj_kind,
  4479. obj_signature,
  4480. obj_owner,
  4481. need_obj_kind,
  4482. need_obj_signature,
  4483. need_obj_owner)
  4484. values
  4485. (
  4486. "%SYSBLDNAME%",
  4487. 5, "IsAncestor (Node,Node)",
  4488. "%SYSBLDUSER%",
  4489. 7, "Node",
  4490. "%SYSBLDUSER%"
  4491. );
  4492. insert into sysbldobjects
  4493. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4494. create_can_fail, drop_sql, drop_can_fail)
  4495. values
  4496. (
  4497. "%SYSBLDNAME%", 181, "Alter-ExternalName-IsAncestor (Node,Node)",
  4498. "%SYSBLDUSER%", 0,
  4499. "alter function IsAncestor (Node,Node)
  4500. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsAncestor)"");
  4501. ",
  4502. "f",
  4503. "alter function IsAncestor (Node,Node)
  4504. with (Modify External Name = ""NodeIsAncestor"");
  4505. ",
  4506. "f"
  4507. );
  4508. insert into sysbldobjdepends
  4509. (
  4510. bld_id,
  4511. obj_kind,
  4512. obj_signature,
  4513. obj_owner,
  4514. need_obj_kind,
  4515. need_obj_signature,
  4516. need_obj_owner)
  4517. values
  4518. (
  4519. "%SYSBLDNAME%",
  4520. 181, "Alter-ExternalName-IsAncestor (Node,Node)",
  4521. "%SYSBLDUSER%",
  4522. 5, "IsAncestor (Node,Node)",
  4523. "%SYSBLDUSER%"
  4524. );
  4525. insert into sysbldobjects
  4526. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4527. create_can_fail, drop_sql, drop_can_fail)
  4528. values
  4529. (
  4530. "%SYSBLDNAME%", 37, "Alter-Parallelize-IsAncestor (Node,Node)",
  4531. "%SYSBLDUSER%", 0,
  4532. "alter function IsAncestor (Node,Node)
  4533. with (add parallelizable);
  4534. ",
  4535. "f",
  4536. "alter function IsAncestor (Node,Node)
  4537. with (drop parallelizable);
  4538. ",
  4539. "f"
  4540. );
  4541. insert into sysbldobjdepends
  4542. (
  4543. bld_id,
  4544. obj_kind,
  4545. obj_signature,
  4546. obj_owner,
  4547. need_obj_kind,
  4548. need_obj_signature,
  4549. need_obj_owner)
  4550. values
  4551. (
  4552. "%SYSBLDNAME%",
  4553. 37, "Alter-Parallelize-IsAncestor (Node,Node)",
  4554. "%SYSBLDUSER%",
  4555. 5, "IsAncestor (Node,Node)",
  4556. "%SYSBLDUSER%"
  4557. );
  4558. insert into sysbldobjects
  4559. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4560. create_can_fail, drop_sql, drop_can_fail)
  4561. values
  4562. (
  4563. "%SYSBLDNAME%", 85, "Alter-Variant-IsAncestor (Node,Node)",
  4564. "%SYSBLDUSER%", 0,
  4565. "alter function IsAncestor (Node,Node)
  4566. with (add not variant);
  4567. ",
  4568. "f",
  4569. "alter function IsAncestor (Node,Node)
  4570. with (drop not variant);
  4571. ",
  4572. "f"
  4573. );
  4574. insert into sysbldobjdepends
  4575. (
  4576. bld_id,
  4577. obj_kind,
  4578. obj_signature,
  4579. obj_owner,
  4580. need_obj_kind,
  4581. need_obj_signature,
  4582. need_obj_owner)
  4583. values
  4584. (
  4585. "%SYSBLDNAME%",
  4586. 85, "Alter-Variant-IsAncestor (Node,Node)",
  4587. "%SYSBLDUSER%",
  4588. 5, "IsAncestor (Node,Node)",
  4589. "%SYSBLDUSER%"
  4590. );
  4591. insert into sysbldobjects
  4592. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4593. create_can_fail, drop_sql, drop_can_fail)
  4594. values
  4595. (
  4596. "%SYSBLDNAME%", 69, "IsAncestor (Node,Node)",
  4597. "%SYSBLDUSER%", 0,
  4598. "grant execute on function IsAncestor (Node,Node) to public;
  4599. ",
  4600. "f",
  4601. "",
  4602. "f"
  4603. );
  4604. insert into sysbldobjdepends
  4605. (
  4606. bld_id,
  4607. obj_kind,
  4608. obj_signature,
  4609. obj_owner,
  4610. need_obj_kind,
  4611. need_obj_signature,
  4612. need_obj_owner)
  4613. values
  4614. (
  4615. "%SYSBLDNAME%",
  4616. 69, "IsAncestor (Node,Node)",
  4617. "%SYSBLDUSER%",
  4618. 5, "IsAncestor (Node,Node)",
  4619. "%SYSBLDUSER%"
  4620. );
  4621. insert into sysbldobjects
  4622. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4623. create_can_fail, drop_sql, drop_can_fail)
  4624. values
  4625. (
  4626. "%SYSBLDNAME%", 5, "IsDescendant (Node,Node)",
  4627. "%SYSBLDUSER%", 0,
  4628. "create function IsDescendant (Node,Node)
  4629. returns boolean
  4630. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsDescendant)"" language c;
  4631. ",
  4632. "f",
  4633. "drop function IsDescendant (Node,Node);
  4634. ",
  4635. "f"
  4636. );
  4637. insert into sysbldobjdepends
  4638. (
  4639. bld_id,
  4640. obj_kind,
  4641. obj_signature,
  4642. obj_owner,
  4643. need_obj_kind,
  4644. need_obj_signature,
  4645. need_obj_owner)
  4646. values
  4647. (
  4648. "%SYSBLDNAME%",
  4649. 5, "IsDescendant (Node,Node)",
  4650. "%SYSBLDUSER%",
  4651. 7, "Node",
  4652. "%SYSBLDUSER%"
  4653. );
  4654. insert into sysbldobjects
  4655. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4656. create_can_fail, drop_sql, drop_can_fail)
  4657. values
  4658. (
  4659. "%SYSBLDNAME%", 181, "Alter-ExternalName-IsDescendant (Node,Node)",
  4660. "%SYSBLDUSER%", 0,
  4661. "alter function IsDescendant (Node,Node)
  4662. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeIsDescendant)"");
  4663. ",
  4664. "f",
  4665. "alter function IsDescendant (Node,Node)
  4666. with (Modify External Name = ""NodeIsDescendant"");
  4667. ",
  4668. "f"
  4669. );
  4670. insert into sysbldobjdepends
  4671. (
  4672. bld_id,
  4673. obj_kind,
  4674. obj_signature,
  4675. obj_owner,
  4676. need_obj_kind,
  4677. need_obj_signature,
  4678. need_obj_owner)
  4679. values
  4680. (
  4681. "%SYSBLDNAME%",
  4682. 181, "Alter-ExternalName-IsDescendant (Node,Node)",
  4683. "%SYSBLDUSER%",
  4684. 5, "IsDescendant (Node,Node)",
  4685. "%SYSBLDUSER%"
  4686. );
  4687. insert into sysbldobjects
  4688. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4689. create_can_fail, drop_sql, drop_can_fail)
  4690. values
  4691. (
  4692. "%SYSBLDNAME%", 85, "Alter-Variant-IsDescendant (Node,Node)",
  4693. "%SYSBLDUSER%", 0,
  4694. "alter function IsDescendant (Node,Node)
  4695. with (add not variant);
  4696. ",
  4697. "f",
  4698. "alter function IsDescendant (Node,Node)
  4699. with (drop not variant);
  4700. ",
  4701. "f"
  4702. );
  4703. insert into sysbldobjdepends
  4704. (
  4705. bld_id,
  4706. obj_kind,
  4707. obj_signature,
  4708. obj_owner,
  4709. need_obj_kind,
  4710. need_obj_signature,
  4711. need_obj_owner)
  4712. values
  4713. (
  4714. "%SYSBLDNAME%",
  4715. 85, "Alter-Variant-IsDescendant (Node,Node)",
  4716. "%SYSBLDUSER%",
  4717. 5, "IsDescendant (Node,Node)",
  4718. "%SYSBLDUSER%"
  4719. );
  4720. insert into sysbldobjects
  4721. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4722. create_can_fail, drop_sql, drop_can_fail)
  4723. values
  4724. (
  4725. "%SYSBLDNAME%", 69, "IsDescendant (Node,Node)",
  4726. "%SYSBLDUSER%", 0,
  4727. "grant execute on function IsDescendant (Node,Node) to public;
  4728. ",
  4729. "f",
  4730. "",
  4731. "f"
  4732. );
  4733. insert into sysbldobjdepends
  4734. (
  4735. bld_id,
  4736. obj_kind,
  4737. obj_signature,
  4738. obj_owner,
  4739. need_obj_kind,
  4740. need_obj_signature,
  4741. need_obj_owner)
  4742. values
  4743. (
  4744. "%SYSBLDNAME%",
  4745. 69, "IsDescendant (Node,Node)",
  4746. "%SYSBLDUSER%",
  4747. 5, "IsDescendant (Node,Node)",
  4748. "%SYSBLDUSER%"
  4749. );
  4750. insert into sysbldobjects
  4751. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4752. create_can_fail, drop_sql, drop_can_fail)
  4753. values
  4754. (
  4755. "%SYSBLDNAME%", 5, "NewLevel (Node)",
  4756. "%SYSBLDUSER%", 0,
  4757. "create function NewLevel (Node)
  4758. returns Node
  4759. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeNewLevel)"" language c;
  4760. ",
  4761. "f",
  4762. "drop function NewLevel (Node);
  4763. ",
  4764. "f"
  4765. );
  4766. insert into sysbldobjdepends
  4767. (
  4768. bld_id,
  4769. obj_kind,
  4770. obj_signature,
  4771. obj_owner,
  4772. need_obj_kind,
  4773. need_obj_signature,
  4774. need_obj_owner)
  4775. values
  4776. (
  4777. "%SYSBLDNAME%",
  4778. 5, "NewLevel (Node)",
  4779. "%SYSBLDUSER%",
  4780. 7, "Node",
  4781. "%SYSBLDUSER%"
  4782. );
  4783. insert into sysbldobjects
  4784. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4785. create_can_fail, drop_sql, drop_can_fail)
  4786. values
  4787. (
  4788. "%SYSBLDNAME%", 181, "Alter-ExternalName-NewLevel (Node)",
  4789. "%SYSBLDUSER%", 0,
  4790. "alter function NewLevel (Node)
  4791. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeNewLevel)"");
  4792. ",
  4793. "f",
  4794. "alter function NewLevel (Node)
  4795. with (Modify External Name = ""NodeNewLevel"");
  4796. ",
  4797. "f"
  4798. );
  4799. insert into sysbldobjdepends
  4800. (
  4801. bld_id,
  4802. obj_kind,
  4803. obj_signature,
  4804. obj_owner,
  4805. need_obj_kind,
  4806. need_obj_signature,
  4807. need_obj_owner)
  4808. values
  4809. (
  4810. "%SYSBLDNAME%",
  4811. 181, "Alter-ExternalName-NewLevel (Node)",
  4812. "%SYSBLDUSER%",
  4813. 5, "NewLevel (Node)",
  4814. "%SYSBLDUSER%"
  4815. );
  4816. insert into sysbldobjects
  4817. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4818. create_can_fail, drop_sql, drop_can_fail)
  4819. values
  4820. (
  4821. "%SYSBLDNAME%", 37, "Alter-Parallelize-NewLevel (Node)",
  4822. "%SYSBLDUSER%", 0,
  4823. "alter function NewLevel (Node)
  4824. with (add parallelizable);
  4825. ",
  4826. "f",
  4827. "alter function NewLevel (Node)
  4828. with (drop parallelizable);
  4829. ",
  4830. "f"
  4831. );
  4832. insert into sysbldobjdepends
  4833. (
  4834. bld_id,
  4835. obj_kind,
  4836. obj_signature,
  4837. obj_owner,
  4838. need_obj_kind,
  4839. need_obj_signature,
  4840. need_obj_owner)
  4841. values
  4842. (
  4843. "%SYSBLDNAME%",
  4844. 37, "Alter-Parallelize-NewLevel (Node)",
  4845. "%SYSBLDUSER%",
  4846. 5, "NewLevel (Node)",
  4847. "%SYSBLDUSER%"
  4848. );
  4849. insert into sysbldobjects
  4850. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4851. create_can_fail, drop_sql, drop_can_fail)
  4852. values
  4853. (
  4854. "%SYSBLDNAME%", 85, "Alter-Variant-NewLevel (Node)",
  4855. "%SYSBLDUSER%", 0,
  4856. "alter function NewLevel (Node)
  4857. with (add not variant);
  4858. ",
  4859. "f",
  4860. "alter function NewLevel (Node)
  4861. with (drop not variant);
  4862. ",
  4863. "f"
  4864. );
  4865. insert into sysbldobjdepends
  4866. (
  4867. bld_id,
  4868. obj_kind,
  4869. obj_signature,
  4870. obj_owner,
  4871. need_obj_kind,
  4872. need_obj_signature,
  4873. need_obj_owner)
  4874. values
  4875. (
  4876. "%SYSBLDNAME%",
  4877. 85, "Alter-Variant-NewLevel (Node)",
  4878. "%SYSBLDUSER%",
  4879. 5, "NewLevel (Node)",
  4880. "%SYSBLDUSER%"
  4881. );
  4882. insert into sysbldobjects
  4883. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4884. create_can_fail, drop_sql, drop_can_fail)
  4885. values
  4886. (
  4887. "%SYSBLDNAME%", 69, "NewLevel (Node)",
  4888. "%SYSBLDUSER%", 0,
  4889. "grant execute on function NewLevel (Node) to public;
  4890. ",
  4891. "f",
  4892. "",
  4893. "f"
  4894. );
  4895. insert into sysbldobjdepends
  4896. (
  4897. bld_id,
  4898. obj_kind,
  4899. obj_signature,
  4900. obj_owner,
  4901. need_obj_kind,
  4902. need_obj_signature,
  4903. need_obj_owner)
  4904. values
  4905. (
  4906. "%SYSBLDNAME%",
  4907. 69, "NewLevel (Node)",
  4908. "%SYSBLDUSER%",
  4909. 5, "NewLevel (Node)",
  4910. "%SYSBLDUSER%"
  4911. );
  4912. insert into sysbldobjects
  4913. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4914. create_can_fail, drop_sql, drop_can_fail)
  4915. values
  4916. (
  4917. "%SYSBLDNAME%", 5, "Graft (Node,Node,Node)",
  4918. "%SYSBLDUSER%", 0,
  4919. "create function Graft (Node,Node,Node)
  4920. returns Node
  4921. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGraft)"" language c;
  4922. ",
  4923. "f",
  4924. "drop function Graft (Node,Node,Node);
  4925. ",
  4926. "f"
  4927. );
  4928. insert into sysbldobjdepends
  4929. (
  4930. bld_id,
  4931. obj_kind,
  4932. obj_signature,
  4933. obj_owner,
  4934. need_obj_kind,
  4935. need_obj_signature,
  4936. need_obj_owner)
  4937. values
  4938. (
  4939. "%SYSBLDNAME%",
  4940. 5, "Graft (Node,Node,Node)",
  4941. "%SYSBLDUSER%",
  4942. 7, "Node",
  4943. "%SYSBLDUSER%"
  4944. );
  4945. insert into sysbldobjects
  4946. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4947. create_can_fail, drop_sql, drop_can_fail)
  4948. values
  4949. (
  4950. "%SYSBLDNAME%", 181, "Alter-ExternalName-Graft (Node,Node,Node)",
  4951. "%SYSBLDUSER%", 0,
  4952. "alter function Graft (Node,Node,Node)
  4953. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeGraft)"");
  4954. ",
  4955. "f",
  4956. "alter function Graft (Node,Node,Node)
  4957. with (Modify External Name = ""NodeGraft"");
  4958. ",
  4959. "f"
  4960. );
  4961. insert into sysbldobjdepends
  4962. (
  4963. bld_id,
  4964. obj_kind,
  4965. obj_signature,
  4966. obj_owner,
  4967. need_obj_kind,
  4968. need_obj_signature,
  4969. need_obj_owner)
  4970. values
  4971. (
  4972. "%SYSBLDNAME%",
  4973. 181, "Alter-ExternalName-Graft (Node,Node,Node)",
  4974. "%SYSBLDUSER%",
  4975. 5, "Graft (Node,Node,Node)",
  4976. "%SYSBLDUSER%"
  4977. );
  4978. insert into sysbldobjects
  4979. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  4980. create_can_fail, drop_sql, drop_can_fail)
  4981. values
  4982. (
  4983. "%SYSBLDNAME%", 37, "Alter-Parallelize-Graft (Node,Node,Node)",
  4984. "%SYSBLDUSER%", 0,
  4985. "alter function Graft (Node,Node,Node)
  4986. with (add parallelizable);
  4987. ",
  4988. "f",
  4989. "alter function Graft (Node,Node,Node)
  4990. with (drop parallelizable);
  4991. ",
  4992. "f"
  4993. );
  4994. insert into sysbldobjdepends
  4995. (
  4996. bld_id,
  4997. obj_kind,
  4998. obj_signature,
  4999. obj_owner,
  5000. need_obj_kind,
  5001. need_obj_signature,
  5002. need_obj_owner)
  5003. values
  5004. (
  5005. "%SYSBLDNAME%",
  5006. 37, "Alter-Parallelize-Graft (Node,Node,Node)",
  5007. "%SYSBLDUSER%",
  5008. 5, "Graft (Node,Node,Node)",
  5009. "%SYSBLDUSER%"
  5010. );
  5011. insert into sysbldobjects
  5012. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5013. create_can_fail, drop_sql, drop_can_fail)
  5014. values
  5015. (
  5016. "%SYSBLDNAME%", 85, "Alter-Variant-Graft (Node,Node,Node)",
  5017. "%SYSBLDUSER%", 0,
  5018. "alter function Graft (Node,Node,Node)
  5019. with (add not variant);
  5020. ",
  5021. "f",
  5022. "alter function Graft (Node,Node,Node)
  5023. with (drop not variant);
  5024. ",
  5025. "f"
  5026. );
  5027. insert into sysbldobjdepends
  5028. (
  5029. bld_id,
  5030. obj_kind,
  5031. obj_signature,
  5032. obj_owner,
  5033. need_obj_kind,
  5034. need_obj_signature,
  5035. need_obj_owner)
  5036. values
  5037. (
  5038. "%SYSBLDNAME%",
  5039. 85, "Alter-Variant-Graft (Node,Node,Node)",
  5040. "%SYSBLDUSER%",
  5041. 5, "Graft (Node,Node,Node)",
  5042. "%SYSBLDUSER%"
  5043. );
  5044. insert into sysbldobjects
  5045. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5046. create_can_fail, drop_sql, drop_can_fail)
  5047. values
  5048. (
  5049. "%SYSBLDNAME%", 69, "Graft (Node,Node,Node)",
  5050. "%SYSBLDUSER%", 0,
  5051. "grant execute on function Graft (Node,Node,Node) to public;
  5052. ",
  5053. "f",
  5054. "",
  5055. "f"
  5056. );
  5057. insert into sysbldobjdepends
  5058. (
  5059. bld_id,
  5060. obj_kind,
  5061. obj_signature,
  5062. obj_owner,
  5063. need_obj_kind,
  5064. need_obj_signature,
  5065. need_obj_owner)
  5066. values
  5067. (
  5068. "%SYSBLDNAME%",
  5069. 69, "Graft (Node,Node,Node)",
  5070. "%SYSBLDUSER%",
  5071. 5, "Graft (Node,Node,Node)",
  5072. "%SYSBLDUSER%"
  5073. );
  5074. insert into sysbldobjects
  5075. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5076. create_can_fail, drop_sql, drop_can_fail)
  5077. values
  5078. (
  5079. "%SYSBLDNAME%", 5, "Length (Node)",
  5080. "%SYSBLDUSER%", 0,
  5081. "create function Length (Node)
  5082. returns integer
  5083. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeDepth)"" language c;
  5084. ",
  5085. "f",
  5086. "drop function Length (Node);
  5087. ",
  5088. "f"
  5089. );
  5090. insert into sysbldobjdepends
  5091. (
  5092. bld_id,
  5093. obj_kind,
  5094. obj_signature,
  5095. obj_owner,
  5096. need_obj_kind,
  5097. need_obj_signature,
  5098. need_obj_owner)
  5099. values
  5100. (
  5101. "%SYSBLDNAME%",
  5102. 5, "Length (Node)",
  5103. "%SYSBLDUSER%",
  5104. 7, "Node",
  5105. "%SYSBLDUSER%"
  5106. );
  5107. insert into sysbldobjects
  5108. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5109. create_can_fail, drop_sql, drop_can_fail)
  5110. values
  5111. (
  5112. "%SYSBLDNAME%", 181, "Alter-ExternalName-Length (Node)",
  5113. "%SYSBLDUSER%", 0,
  5114. "alter function Length (Node)
  5115. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeDepth)"");
  5116. ",
  5117. "f",
  5118. "alter function Length (Node)
  5119. with (Modify External Name = ""NodeDepth"");
  5120. ",
  5121. "f"
  5122. );
  5123. insert into sysbldobjdepends
  5124. (
  5125. bld_id,
  5126. obj_kind,
  5127. obj_signature,
  5128. obj_owner,
  5129. need_obj_kind,
  5130. need_obj_signature,
  5131. need_obj_owner)
  5132. values
  5133. (
  5134. "%SYSBLDNAME%",
  5135. 181, "Alter-ExternalName-Length (Node)",
  5136. "%SYSBLDUSER%",
  5137. 5, "Length (Node)",
  5138. "%SYSBLDUSER%"
  5139. );
  5140. insert into sysbldobjects
  5141. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5142. create_can_fail, drop_sql, drop_can_fail)
  5143. values
  5144. (
  5145. "%SYSBLDNAME%", 37, "Alter-Parallelize-Length (Node)",
  5146. "%SYSBLDUSER%", 0,
  5147. "alter function Length (Node)
  5148. with (add parallelizable);
  5149. ",
  5150. "f",
  5151. "alter function Length (Node)
  5152. with (drop parallelizable);
  5153. ",
  5154. "f"
  5155. );
  5156. insert into sysbldobjdepends
  5157. (
  5158. bld_id,
  5159. obj_kind,
  5160. obj_signature,
  5161. obj_owner,
  5162. need_obj_kind,
  5163. need_obj_signature,
  5164. need_obj_owner)
  5165. values
  5166. (
  5167. "%SYSBLDNAME%",
  5168. 37, "Alter-Parallelize-Length (Node)",
  5169. "%SYSBLDUSER%",
  5170. 5, "Length (Node)",
  5171. "%SYSBLDUSER%"
  5172. );
  5173. insert into sysbldobjects
  5174. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5175. create_can_fail, drop_sql, drop_can_fail)
  5176. values
  5177. (
  5178. "%SYSBLDNAME%", 69, "Length (Node)",
  5179. "%SYSBLDUSER%", 0,
  5180. "grant execute on function Length (Node) to public;
  5181. ",
  5182. "f",
  5183. "",
  5184. "f"
  5185. );
  5186. insert into sysbldobjdepends
  5187. (
  5188. bld_id,
  5189. obj_kind,
  5190. obj_signature,
  5191. obj_owner,
  5192. need_obj_kind,
  5193. need_obj_signature,
  5194. need_obj_owner)
  5195. values
  5196. (
  5197. "%SYSBLDNAME%",
  5198. 69, "Length (Node)",
  5199. "%SYSBLDUSER%",
  5200. 5, "Length (Node)",
  5201. "%SYSBLDUSER%"
  5202. );
  5203. insert into sysbldobjects
  5204. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5205. create_can_fail, drop_sql, drop_can_fail)
  5206. values
  5207. (
  5208. "%SYSBLDNAME%", 5, "NodeRelease ()",
  5209. "%SYSBLDUSER%", 0,
  5210. "create function NodeRelease ()
  5211. returns lvarchar
  5212. external name ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeRelease)"" language c;
  5213. ",
  5214. "f",
  5215. "drop function NodeRelease ();
  5216. ",
  5217. "f"
  5218. );
  5219. insert into sysbldobjects
  5220. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5221. create_can_fail, drop_sql, drop_can_fail)
  5222. values
  5223. (
  5224. "%SYSBLDNAME%", 181, "Alter-ExternalName-NodeRelease ()",
  5225. "%SYSBLDUSER%", 0,
  5226. "alter function NodeRelease ()
  5227. with (Modify External Name = ""$INFORMIXDIR/extend/%SYSBLDDIR%/Node.bld(NodeRelease)"");
  5228. ",
  5229. "f",
  5230. "alter function NodeRelease ()
  5231. with (Modify External Name = ""NodeRelease"");
  5232. ",
  5233. "f"
  5234. );
  5235. insert into sysbldobjdepends
  5236. (
  5237. bld_id,
  5238. obj_kind,
  5239. obj_signature,
  5240. obj_owner,
  5241. need_obj_kind,
  5242. need_obj_signature,
  5243. need_obj_owner)
  5244. values
  5245. (
  5246. "%SYSBLDNAME%",
  5247. 181, "Alter-ExternalName-NodeRelease ()",
  5248. "%SYSBLDUSER%",
  5249. 5, "NodeRelease ()",
  5250. "%SYSBLDUSER%"
  5251. );
  5252. insert into sysbldobjects
  5253. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5254. create_can_fail, drop_sql, drop_can_fail)
  5255. values
  5256. (
  5257. "%SYSBLDNAME%", 37, "Alter-Parallelize-NodeRelease ()",
  5258. "%SYSBLDUSER%", 0,
  5259. "alter function NodeRelease ()
  5260. with (add parallelizable);
  5261. ",
  5262. "f",
  5263. "alter function NodeRelease ()
  5264. with (drop parallelizable);
  5265. ",
  5266. "f"
  5267. );
  5268. insert into sysbldobjdepends
  5269. (
  5270. bld_id,
  5271. obj_kind,
  5272. obj_signature,
  5273. obj_owner,
  5274. need_obj_kind,
  5275. need_obj_signature,
  5276. need_obj_owner)
  5277. values
  5278. (
  5279. "%SYSBLDNAME%",
  5280. 37, "Alter-Parallelize-NodeRelease ()",
  5281. "%SYSBLDUSER%",
  5282. 5, "NodeRelease ()",
  5283. "%SYSBLDUSER%"
  5284. );
  5285. insert into sysbldobjects
  5286. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5287. create_can_fail, drop_sql, drop_can_fail)
  5288. values
  5289. (
  5290. "%SYSBLDNAME%", 55, "Alter-HandleNul-NodeRelease ()",
  5291. "%SYSBLDUSER%", 0,
  5292. "alter function NodeRelease ()
  5293. with (add handlesnulls);
  5294. ",
  5295. "f",
  5296. "alter function NodeRelease ()
  5297. with (drop handlesnulls);
  5298. ",
  5299. "f"
  5300. );
  5301. insert into sysbldobjdepends
  5302. (
  5303. bld_id,
  5304. obj_kind,
  5305. obj_signature,
  5306. obj_owner,
  5307. need_obj_kind,
  5308. need_obj_signature,
  5309. need_obj_owner)
  5310. values
  5311. (
  5312. "%SYSBLDNAME%",
  5313. 55, "Alter-HandleNul-NodeRelease ()",
  5314. "%SYSBLDUSER%",
  5315. 5, "NodeRelease ()",
  5316. "%SYSBLDUSER%"
  5317. );
  5318. insert into sysbldobjects
  5319. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5320. create_can_fail, drop_sql, drop_can_fail)
  5321. values
  5322. (
  5323. "%SYSBLDNAME%", 85, "Alter-Variant-NodeRelease ()",
  5324. "%SYSBLDUSER%", 0,
  5325. "alter function NodeRelease ()
  5326. with (add not variant);
  5327. ",
  5328. "f",
  5329. "alter function NodeRelease ()
  5330. with (drop not variant);
  5331. ",
  5332. "f"
  5333. );
  5334. insert into sysbldobjdepends
  5335. (
  5336. bld_id,
  5337. obj_kind,
  5338. obj_signature,
  5339. obj_owner,
  5340. need_obj_kind,
  5341. need_obj_signature,
  5342. need_obj_owner)
  5343. values
  5344. (
  5345. "%SYSBLDNAME%",
  5346. 85, "Alter-Variant-NodeRelease ()",
  5347. "%SYSBLDUSER%",
  5348. 5, "NodeRelease ()",
  5349. "%SYSBLDUSER%"
  5350. );
  5351. insert into sysbldobjects
  5352. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5353. create_can_fail, drop_sql, drop_can_fail)
  5354. values
  5355. (
  5356. "%SYSBLDNAME%", 69, "NodeRelease ()",
  5357. "%SYSBLDUSER%", 0,
  5358. "grant execute on function NodeRelease () to public;
  5359. ",
  5360. "f",
  5361. "",
  5362. "f"
  5363. );
  5364. insert into sysbldobjdepends
  5365. (
  5366. bld_id,
  5367. obj_kind,
  5368. obj_signature,
  5369. obj_owner,
  5370. need_obj_kind,
  5371. need_obj_signature,
  5372. need_obj_owner)
  5373. values
  5374. (
  5375. "%SYSBLDNAME%",
  5376. 69, "NodeRelease ()",
  5377. "%SYSBLDUSER%",
  5378. 5, "NodeRelease ()",
  5379. "%SYSBLDUSER%"
  5380. );
  5381. insert into sysbldobjects
  5382. (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql,
  5383. create_can_fail, drop_sql, drop_can_fail)
  5384. values
  5385. (
  5386. "%SYSBLDNAME%", 0, "sysbldregistered",
  5387. "%SYSBLDUSER%", 0,
  5388. "insert into sysbldregistered
  5389. (bld_id)
  5390. values
  5391. (
  5392. ""%SYSBLDNAME%""
  5393. );
  5394. ",
  5395. "f",
  5396. "delete from sysbldregistered
  5397. where bld_id = ""%SYSBLDNAME%"";
  5398. ",
  5399. "f"
  5400. );