-- Generated by BladeSmith 3.40.TC1, DO NOT MODIFY -- execute procedure ifx_allow_newline('t'); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "createsysbuiltintypes", "%SYSBLDUSER%", 0, "create table informix.sysbuiltintypes (extended_id SERIAL, domain CHAR(1), mode CHAR(1), owner CHAR(8), name CHAR(18), type SMALLINT, source INTEGER, maxlen INTEGER, length INTEGER, byvalue CHAR(1), cannothash CHAR(1), align SMALLINT, locator INTEGER); grant select on informix.sysbuiltintypes to public as informix; ", "f", "drop table informix.sysbuiltintypes; ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltintypes", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'char', 0, NULL, 32767,0, 'F', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'smallint', 1, NULL, 0, 2, 'T', NULL, 2, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'integer', 2, NULL, 0, 4, 'T', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'float', 3, NULL, 0, 8, 'F', NULL, 8, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'smallfloat', 4, NULL, 0, 4, 'T', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'decimal', 5, NULL, 0, 17, 'F', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'serial', 6, NULL, 0, 4, 'T', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'date', 7, NULL, 0, 4, 'F', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'money', 8, NULL, 0, 17, 'F', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'null', 9, NULL, 0, NULL,NULL,NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'datetime', 10, NULL, 0, 7, 'F', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'byte', 11, NULL, 0, 1, 'F', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'text', 12, NULL, 0, NULL,'T', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'varchar', 13, NULL, 255, 0, 'F', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'interval', 14, NULL, 0, NULL,'F', NULL, 4, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'nchar', 15, NULL, 32767,0, 'F', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'nvarchar', 16, NULL, 255, 0, 'F', NULL, 1, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'integer8', 17, NULL, 0, 10, 'F', NULL, 8, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'serial8', 18, NULL, 0, 10, 'F', NULL, 8, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'set', 19, NULL, 0, 64, 'F', NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'multiset', 20, NULL, 0, 64, 'F', NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'list', 21, NULL, 0, 64, 'F', NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'row', 22, NULL, 0, NULL,'F', NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'collection', 23, NULL, 0, 64, 'F', NULL, NULL, NULL); insert into informix.sysbuiltintypes values (0, '', '', 'informix', 'rowref', 24, NULL, 0, NULL,'F', NULL, NULL, NULL); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "createsysbuiltinroutines", "%SYSBLDUSER%", 0, "create table informix.sysbuiltinroutines (procname char(18), owner char(8), procid SERIAL, mode char(1), retsize integer, symsize integer, datasize integer, codesize integer, numargs integer, isproc char(1), specificname varchar(128), externalname varchar(255), paramstyle char(1), langid integer, paramtypes lvarchar, variant boolean, client boolean, handlesnulls boolean, iterator boolean, percallcost integer, commutator char(18), negator char(18), selfunc char(18), internal boolean, class char(18), stack integer, rettypes lvarchar, paramtypeids lvarchar, rettypeids lvarchar); grant select on informix.sysbuiltinroutines to public as informix; ", "f", "drop table informix.sysbuiltinroutines; ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "createsysbuiltinprocauth", "%SYSBLDUSER%", 0, "create table informix.sysbuiltinprocauth (grantor char(8), grantee char(8), procid integer, procauth char(1)); grant select on informix.sysbuiltinprocauth to public as informix; ", "f", "drop table informix.sysbuiltinprocauth; ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinprocauth01", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinprocauth values ('informix', 'public', -1, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -2, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -3, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -4, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -5, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -6, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -7, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -8, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -9, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -10, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -11, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -12, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -13, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -14, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -15, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -16, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -17, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -18, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -19, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -20, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -21, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -22, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -23, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -24, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -25, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -26, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -27, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -28, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -29, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -30, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -31, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -32, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -33, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -34, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -35, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -36, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -37, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -38, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -39, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -40, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -41, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -42, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -43, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -44, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -45, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -46, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -47, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -48, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -49, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -50, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -51, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -52, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -53, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -54, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -55, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -56, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -57, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -58, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -59, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -60, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -61, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -62, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -63, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -64, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -65, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -66, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -67, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -68, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -69, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -70, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -71, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -72, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -73, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -74, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -75, 'e'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinprocauth02", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinprocauth values ('informix', 'public', -76, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -77, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -78, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -79, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -80, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -81, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -82, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -83, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -84, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -85, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -86, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -87, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -88, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -89, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -90, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -91, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -92, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -93, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -94, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -95, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -96, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -97, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -98, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -99, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -100, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -101, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -102, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -103, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -104, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -105, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -106, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -107, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -108, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -109, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -110, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -111, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -112, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -113, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -114, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -115, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -116, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -117, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -118, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -119, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -120, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -121, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -122, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -123, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -124, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -125, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -126, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -127, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -128, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -129, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -130, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -131, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -132, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -133, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -134, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -135, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -136, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -137, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -138, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -139, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -140, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -141, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -142, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -143, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -144, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -145, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -146, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -147, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -148, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -149, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -150, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -151, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -152, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -153, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -154, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -155, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -156, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -157, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -158, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -159, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -160, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -161, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -162, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -163, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -164, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -165, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -166, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -167, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -168, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -169, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -170, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -171, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -172, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -173, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -174, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -175, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -176, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -177, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -178, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -179, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -180, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -181, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -182, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -183, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -184, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -185, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -186, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -187, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -188, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -189, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -190, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -191, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -192, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -193, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -194, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -195, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -196, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -197, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -198, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -199, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -200, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -201, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -202, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -203, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -204, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -205, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -206, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -207, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -208, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -209, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -210, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -211, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -212, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -213, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -214, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -215, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -216, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -217, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -218, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -219, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -220, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -221, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -222, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -223, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -224, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -225, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -226, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -227, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -228, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -229, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -230, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -231, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -232, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -233, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -234, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -235, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -236, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -237, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -238, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -239, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -240, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -241, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -242, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -243, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -244, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -245, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -246, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -247, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -248, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -249, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -250, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -251, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -252, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -253, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -254, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -255, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -256, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -257, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -258, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -259, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -260, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -261, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -262, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -263, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -264, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -265, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -266, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -267, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -268, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -269, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -270, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -271, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -272, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -273, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -274, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -275, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -276, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -277, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -278, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -279, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -280, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -281, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -282, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -283, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -284, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -285, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -286, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -287, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -288, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -289, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -290, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -291, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -292, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -293, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -294, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -295, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -296, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -297, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -298, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -299, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -300, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -301, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -302, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -303, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -304, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -305, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -306, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -307, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -308, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -309, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -310, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -311, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -312, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -313, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -314, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -315, 'e'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinprocauth03", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinprocauth values ('informix', 'public', -316, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -317, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -318, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -319, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -320, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -321, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -322, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -323, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -324, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -325, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -326, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -327, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -328, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -329, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -330, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -331, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -332, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -333, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -334, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -335, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -336, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -337, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -338, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -339, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -340, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -341, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -342, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -343, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -344, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -345, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -346, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -347, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -348, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -349, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -350, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -351, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -352, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -353, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -354, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -355, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -356, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -357, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -358, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -359, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -360, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -361, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -362, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -363, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -364, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -365, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -366, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -367, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -368, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -369, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -370, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -371, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -372, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -373, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -374, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -375, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -376, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -377, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -378, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -379, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -380, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -381, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -382, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -383, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -384, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -385, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -386, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -387, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -388, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -389, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -390, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -391, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -392, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -393, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -394, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -395, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -396, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -397, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -398, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -399, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -400, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -401, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -402, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -403, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -404, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -405, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -406, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -407, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -408, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -409, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -410, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -411, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -412, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -413, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -414, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -415, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -416, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -417, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -418, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -419, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -420, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -421, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -422, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -423, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -424, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -425, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -426, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -427, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -428, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -429, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -430, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -431, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -432, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -433, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -434, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -435, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -436, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -437, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -438, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -439, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -440, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -441, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -442, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -443, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -444, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -445, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -446, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -447, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -448, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -449, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -450, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -451, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -452, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -453, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -454, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -455, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -456, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -457, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -458, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -459, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -460, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -461, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -462, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -463, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -464, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -465, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -466, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -467, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -468, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -469, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -470, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -471, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -472, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -473, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -474, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -475, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -476, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -477, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -478, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -479, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -480, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -481, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -482, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -483, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -484, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -485, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -486, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -487, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -488, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -489, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -490, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -491, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -492, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -493, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -494, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -495, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -496, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -497, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -498, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -499, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -500, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -501, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -502, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -503, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -504, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -505, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -506, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -507, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -508, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -509, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -510, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -511, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -512, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -513, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -514, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -515, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -516, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -517, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -518, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -519, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -520, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -521, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -522, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -523, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -524, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -525, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -526, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -527, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -528, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -529, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -530, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -531, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -532, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -533, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -534, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -535, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -536, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -537, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -538, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -539, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -540, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -541, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -542, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -543, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -544, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -545, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -546, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -547, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -548, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -549, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -550, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -551, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -552, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -553, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -554, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -555, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -556, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -557, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -558, 'e'); insert into informix.sysbuiltinprocauth values ('informix', 'public', -559, 'e'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines01", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('cardinality', 'informix', 1, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'set', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(19,-20)', '(2, -3)'); insert into informix.sysbuiltinroutines values('cardinality', 'informix', 2, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'multiset', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(20,-21)', '(2, -3)'); insert into informix.sysbuiltinroutines values('cardinality', 'informix', 3, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'list', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(21,-22)', '(2, -3)'); insert into informix.sysbuiltinroutines values('cardinality', 'informix', 4, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'collection', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(23,-24)', '(2, -3)'); insert into informix.sysbuiltinroutines values('dbinfo', 'informix', 5, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('dbinfo', 'informix', 6, 'P', NULL, NULL, NULL, NULL, 2, 'f', NULL, NULL, 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(13,-14),(13,-14)', '(0,-1)'); insert into informix.sysbuiltinroutines values('date', 'informix', 7, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(0,-1)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 8, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'vchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(13,-14)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 9, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'datetime', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(10,-11)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 10, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'decimal', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(5,-6)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 11, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'money', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(8,-9)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 12, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallint', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(1,-2)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 13, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(2,-3)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 14, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'int8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(17,-18)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 15, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(6,-7)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 16, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(18,-19)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 17, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(4,-5)', '(7,-8)'); insert into informix.sysbuiltinroutines values('date', 'informix', 18, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'float', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(3,-4)', '(7,-8)'); insert into informix.sysbuiltinroutines values('day', 'informix', 19, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'date', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(7,-8)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 20, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'datetime', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(10,-11)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 21, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 22, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 23, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'decimal', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(5,-6)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 24, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'money', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(8,-9)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 25, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallint', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(1,-2)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 26, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 27, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'int8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(17,-18)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 28, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(6,-7)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 29, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(18,-19)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 30, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(4,-5)', '(2,-3)'); insert into informix.sysbuiltinroutines values('day', 'informix', 31, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'float', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(3,-4)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 32, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'date', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(7,-8)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 33, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'datetime', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(10,-11)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 34, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 35, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 36, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'decimal', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(5,-6)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 37, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'money', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(8,-9)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 38, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallint', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(1,-2)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 39, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 40, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'int8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(17,-18)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 41, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(6,-7)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 42, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(18,-19)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 43, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(4,-5)', '(2,-3)'); insert into informix.sysbuiltinroutines values('month', 'informix', 44, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'float', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(3,-4)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 45, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'date', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(7,-8)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 46, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'datetime', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(10,-11)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 47, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 48, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 49, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'decimal', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(5,-6)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 50, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'money', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(8,-9)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 51, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallint', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(1,-2)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 52, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 53, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'int8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(17,-18)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 54, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(6,-7)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 55, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(18,-19)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 56, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(4,-5)', '(2,-3)'); insert into informix.sysbuiltinroutines values('weekday', 'informix', 57, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'float', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(3,-4)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 58, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'date', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(7,-8)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 59, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'datetime', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(10,-11)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 60, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 61, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 62, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'decimal', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(5,-6)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 63, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'money', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(8,-9)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 64, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallint', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(1,-2)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 65, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 66, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'int8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(17,-18)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 67, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(6,-7)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 68, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'serial8', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(18,-19)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 69, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(4,-5)', '(2,-3)'); insert into informix.sysbuiltinroutines values('year', 'informix', 70, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'float', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(3,-4)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mdy', 'informix', 71, 'P', NULL, NULL, NULL, NULL, 3, 'f', NULL, NULL, 'I', 0, 'integer,integer,integer', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(2,-3),(2,-3),(2,-3)', '(7,-8)'); insert into informix.sysbuiltinroutines values('mdy', 'informix', 72, 'P', NULL, NULL, NULL, NULL, 3, 'f', NULL, NULL, 'I', 0, 'char,char,char', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(0,-1),(0,-1),(0,-1)', '(7,-8)'); insert into informix.sysbuiltinroutines values('mdy', 'informix', 73, 'P', NULL, NULL, NULL, NULL, 3, 'f', NULL, NULL, 'I', 0, 'varchar,varchar,varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(13,-14),(13,-14),(13,-14)', '(7,-8)'); insert into informix.sysbuiltinroutines values('trim', 'informix', 74, 'P', NULL, NULL, NULL, NULL, 1, 'f', NULL, NULL, 'I', 0, 'varchar', 'f', 'f', 'f', 'f', NULL, NULL, NULL, NULL,'f', 'CPU', NULL, 'varchar', '(13,-14)', '(13,-14)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines02", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('equal', 'informix', 75, 'P', 132, 416, 7, 4, 2, 'f', NULL, '(boolean_equal)', 'I', 1, 'boolean,boolean', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(41,5),(41,5)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 76, 'P', 132, 416, 7, 4, 2, 'f', NULL, '(boolean_notequal)', 'I', 1, 'boolean,boolean', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(41,5),(41,5)', '(41,5)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 77, 'P', 67, 351, 7, 4, 2, 'f', NULL, '(boolean_compare)', 'I', 1, 'boolean,boolean', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(41,5),(41,5)', '(2,-3)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 78, 'P', 67, 221, 7, 4, 2, 'f', NULL, '(rowcompare)', 'I', 1, 'row,row', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(22,-23),(22,-23)', '(2,-3)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 79, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(rowequal)', 'I', 1, 'row,row', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(22,-23),(22,-23)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 80, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(rownotequal)', 'I', 1, 'row,row', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(22,-23),(22,-23)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 81, 'P', 132, 410, 7, 4, 2, 'f', NULL, '(clob_equal)', 'I', 1, 'blob,blob', 't', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(41,10),(41,10)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 82, 'P', 132, 410, 7, 4, 2, 'f', NULL, '(clob_equal)', 'I', 1, 'clob,clob', 't', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(41,11),(41,11)', '(41,5)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 83, 'P', 67, 345, 7, 4, 2, 'f', NULL, '(blob_cmp)', 'I', 1, 'blob,blob', 't', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(41,10),(41,10)', '(2,-3)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 84, 'P', 67, 345, 7, 4, 2, 'f', NULL, '(blob_cmp)', 'I', 1, 'clob,clob', 't', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(41,11),(41,11)', '(2,-3)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 85, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_equal', '9', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 86, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_equal', '9', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 87, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_equal', '9', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 88, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_equal', '9', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 89, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_equal', '9', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 90, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_equal', '9', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 91, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_equal', '9', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 92, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_equal', '9', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 93, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_equal', '9', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 94, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_equal', '9', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 95, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_equal', '9', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 96, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_equal', '9', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 97, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_equal', '9', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 98, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_equal', '9', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 99, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_equal', '9', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 100, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_equal', '9', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 101, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_not_equal', '26', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 102, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_not_equal', '26', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 103, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_not_equal', '26', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 104, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_not_equal', '26', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 105, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_not_equal', '26', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 106, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_not_equal', '26', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 107, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_not_equal', '26', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 108, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_not_equal', '26', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 109, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_not_equal', '26', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 110, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_not_equal', '26', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 111, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_not_equal', '26', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 112, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_not_equal', '26', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 113, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_not_equal', '26', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 114, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_not_equal', '26', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 115, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_not_equal', '26', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 116, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_not_equal', '26', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 117, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_greater_than', '13', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 118, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_greater_than', '13', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 119, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_greater_than', '13', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 120, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_greater_than', '13', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 121, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_greater_than', '13', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 122, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_greater_than', '13', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 123, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_greater_than', '13', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 124, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_greater_than', '13', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 125, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_greater_than', '13', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 126, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_greater_than', '13', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 127, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_greater_than', '13', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 128, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_greater_than', '13', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 129, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_greater_than', '13', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 130, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_greater_than', '13', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 131, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_greater_than', '13', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 132, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_greater_than', '13', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 133, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_less_than', '18', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 134, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_less_than', '18', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 135, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_less_than', '18', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 136, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_less_than', '18', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 137, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_less_than', '18', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 138, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_less_than', '18', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 139, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_less_than', '18', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 140, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_less_than', '18', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 141, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_less_than', '18', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 142, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_less_than', '18', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 143, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_less_than', '18', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 144, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_less_than', '18', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 145, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_less_than', '18', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 146, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_less_than', '18', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 147, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_less_than', '18', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 148, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_less_than', '18', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 149, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_greater_than_or_equal', '12', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines03", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 150, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_greater_than_or_equal', '12', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 151, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_greater_than_or_equal', '12', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 152, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_greater_than_or_equal', '12', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 153, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_greater_than_or_equal', '12', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 154, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_greater_than_or_equal', '12', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 155, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_greater_than_or_equal', '12', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 156, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_greater_than_or_equal', '12', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 157, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_greater_than_or_equal', '12', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 158, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_greater_than_or_equal', '12', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 159, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_greater_than_or_equal', '12', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 160, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_greater_than_or_equal', '12', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 161, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_greater_than_or_equal', '12', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 162, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_greater_than_or_equal', '12', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 163, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_greater_than_or_equal', '12', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 164, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_greater_than_or_equal', '12', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 165, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_less_than_or_equal', '15', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 166, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_less_than_or_equal', '15', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 167, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_less_than_or_equal', '15', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 168, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_less_than_or_equal', '15', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 169, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_smallint_less_than_or_equal', '15', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(1,-2),(1,-2)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 170, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int_less_than_or_equal', '15', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(2,-3),(2,-3)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 171, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_int8_less_than_or_equal', '15', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(17,-18),(17,-18)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 172, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_decimal_less_than_or_equal', '15', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(5,-6),(5,-6)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 173, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_real_less_than_or_equal', '15', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(4,-5),(4,-5)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 174, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_float_less_than_or_equal', '15', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(3,-4),(3,-4)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 175, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_date_less_than_or_equal', '15', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(7,-8),(7,-8)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 176, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_datetime_less_than_or_equal', '15', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(10,-11),(10,-11)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 177, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_interval_less_than_or_equal', '15', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(14,-15),(14,-15)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 178, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_money_less_than_or_equal', '15', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(8,-9),(8,-9)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 179, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_text_less_than_or_equal', '15', 'I', 0, 'references text, references text', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(12,-13),(12,-13)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 180, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_byte_less_than_or_equal', '15', 'I', 0, 'references byte, references byte', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(11,-12),(11,-12)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 181, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_like_with_no_escape', '17', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 182, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_like_with_no_escape', '17', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 183, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_like_with_no_escape', '17', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 184, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_like_with_no_escape', '17', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 185, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_char_like_with_escape', '17', 'I', 0, 'char,char,char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 186, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_nchar_like_with_escape', '17', 'I', 0, 'nchar,nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 187, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_varchar_like_with_escape', '17', 'I', 0, 'varchar,varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 188, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_nvarchar_like_with_escape', '17', 'I', 0, 'nvarchar,nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 189, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_char_matches_binary', '19', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 190, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nchar_matches_binary', '19', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 191, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_varchar_matches_binary', '19', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 192, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_nvarchar_matches_binary', '19', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 193, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_char_matches_trinary', '19', 'I', 0, 'char,char,char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(0,-1),(0,-1),(0,-1)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 194, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_nchar_matches_trinary', '19', 'I', 0, 'nchar,nchar,nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(15,-16),(15,-16),(15,-16)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 195, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_varchar_matches_trinary', '19', 'I', 0, 'varchar,varchar,varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(13,-14),(13,-14),(13,-14)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 196, 'P', 132, 356, 7, 4, 3, 'f', 'ifx_nvarchar_matches_trinary', '19', 'I', 0, 'nvarchar,nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(16,-17),(16,-17),(16,-17)', '(41,5)'); insert into informix.sysbuiltinroutines values('concat', 'informix', 197, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_char_concat', '43', 'I', 0, 'char,char', 'f', 'f', 'f', 'f', 0, 'concat', NULL, NULL,'f', 'CPU', NULL, 'char', '(0,-1),(0,-1)', '(0,-1)'); insert into informix.sysbuiltinroutines values('concat', 'informix', 198, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nchar_concat', '43', 'I', 0, 'nchar,nchar', 'f', 'f', 'f', 'f', 0, 'concat', NULL, NULL,'f', 'CPU', NULL, 'nchar', '(15,-16),(15,-16)', '(15,-16)'); insert into informix.sysbuiltinroutines values('concat', 'informix', 199, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_varchar_concat', '43', 'I', 0, 'varchar,varchar', 'f', 'f', 'f', 'f', 0, 'concat', NULL, NULL,'f', 'CPU', NULL, 'varchar', '(13,-14),(13,-14)', '(13,-14)'); insert into informix.sysbuiltinroutines values('concat', 'informix', 200, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nvarchar_concat', '43', 'I', 0, 'nvarchar,nvarchar', 'f', 'f', 'f', 'f', 0, 'concat', NULL, NULL,'f', 'CPU', NULL, 'nvarchar', '(16,-17),(16,-17)', '(16,-17)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 201, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_negate', '23', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallint', '(1,-2)', '(1,-2)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 202, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int_negate', '23', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 203, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_negate', '23', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'int8', '(17,-18)', '(17,-18)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 204, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_negate', '23', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 205, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_real_negate', '23', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallfloat', '(4,-5)', '(4,-5)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 206, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_negate', '23', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 207, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_negate', '23', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 208, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_minus', '23', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(1,-2)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 209, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int_minus', '23', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 210, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_minus', '23', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(17,-18)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 211, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_minus', '23', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 212, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_real_minus', '23', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(4,-5)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 213, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_minus', '23', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(3,-4)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 214, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_date_minus', '23', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(7,-8),(7,-8)', '(7,-8)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 215, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_datetime_minus2', '23', 'I', 0, 'datetime,datetime', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'interval', '(10,-11),(10,-11)', '(14,-15)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 216, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_datetime_minus', '23', 'I', 0, 'datetime,interval', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'interval', '(10,-11),(14,-15)', '(14,-15)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 217, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_interval_minus', '23', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'interval', '(14,-15),(14,-15)', '(14,-15)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 218, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_minus', '23', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9),(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 219, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_positive', '35', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallint', '(1,-2)', '(1,-2)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 220, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int_positive', '35', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 221, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_positive', '35', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'int8', '(17,-18)', '(17,-18)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 222, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_positive', '35', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 223, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_real_positive', '35', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallfloat', '(4,-5)', '(4,-5)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 224, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_positive', '35', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines04", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('positive', 'informix', 225, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_positive', '35', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 226, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_plus', '35', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(1,-2)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 227, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int_plus', '35', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 228, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_plus', '35', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(17,-18)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 229, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_plus', '35', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 230, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_real_plus', '35', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(4,-5)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 231, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_plus', '35', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(3,-4)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 232, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_date_plus', '35', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'date', '(7,-8),(7,-8)', '(7,-8)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 233, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_datetime_plus', '35', 'I', 0, 'datetime,interval', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'datetime', '(10,-11),(14,-15)', '(10,-11)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 234, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_interval_plus', '35', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'interval', '(14,-15),(14,-15)', '(14,-15)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 235, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_plus', '35', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9),(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('times', 'informix', 236, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_times', '25', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(1,-2)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 237, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int_times', '25', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 238, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_times', '25', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(17,-18)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 239, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_times', '25', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 240, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_real_times', '25', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(4,-5)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 241, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_times', '25', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(3,-4)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 242, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_date_times', '25', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'date', '(7,-8),(7,-8)', '(7,-8)'); insert into informix.sysbuiltinroutines values('times', 'informix', 243, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_interval_times', '25', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'interval', '(14,-15),(14,-15)', '(14,-15)'); insert into informix.sysbuiltinroutines values('times', 'informix', 244, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_times', '25', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9),(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 245, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_divide', '8', 'I', 0, 'smallint,smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(1,-2)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 246, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int_divide', '8', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 247, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_divide', '8', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(17,-18)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 248, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_divide', '8', 'I', 0, 'decimal,decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 249, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_real_divide', '8', 'I', 0, 'smallfloat,smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(4,-5)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 250, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_divide', '8', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(3,-4)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 251, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_date_divide', '8', 'I', 0, 'date,date', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'date', '(7,-8),(7,-8)', '(7,-8)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 252, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_interval_divide', '8', 'I', 0, 'interval,interval', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'interval', '(14,-15),(14,-15)', '(14,-15)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 253, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_divide', '8', 'I', 0, 'money,money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(8,-9),(8,-9)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 254, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_abs', '100', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 255, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_abs', '100', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallint', '(1,-2)', '(1,-2)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 256, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_abs', '100', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'int8', '(17,-18)', '(17,-18)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 257, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_abs', '100', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 258, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_abs', '100', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'smallfloat', '(4,-5)', '(4,-5)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 259, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_abs', '100', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 260, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_abs', '100', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'money', '(8,-9)', '(8,-9)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 261, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_abs', '100', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(13,-14)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 262, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_abs', '100', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(0,-1)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 263, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_abs', '100', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(16,-17)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 264, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_abs', '100', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(15,-16)', '(5,-6)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 265, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_exp', '103', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 266, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_exp', '103', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 267, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_exp', '103', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 268, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_exp', '103', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 269, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_exp', '103', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 270, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_exp', '103', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 271, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_exp', '103', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 272, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_exp', '103', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 273, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_exp', '103', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 274, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_exp', '103', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 275, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_exp', '103', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 276, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_hex', '92', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(2,-3)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 277, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_hex', '92', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(1,-2)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 278, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_hex', '92', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(17,-18)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 279, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_hex', '92', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(3,-4)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 280, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_hex', '92', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(4,-5)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 281, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_hex', '92', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(5,-6)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 282, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_hex', '92', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(8,-9)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 283, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_hex', '92', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(13,-14)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 284, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_hex', '92', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(0,-1)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 285, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_hex', '92', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(16,-17)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 286, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_hex', '92', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(15,-16)', '(0,-1)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 287, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_log10', '102', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 288, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_log10', '102', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 289, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_log10', '102', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 290, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_log10', '102', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 291, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_log10', '102', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 292, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_log10', '102', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 293, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_log10', '102', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 294, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_log10', '102', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 295, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_log10', '102', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 296, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_log10', '102', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 297, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_log10', '102', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 298, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_logn', '101', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 299, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_logn', '101', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines05", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('logn', 'informix', 300, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_logn', '101', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 301, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_logn', '101', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 302, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_logn', '101', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 303, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_logn', '101', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 304, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_logn', '101', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 305, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_logn', '101', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 306, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_logn', '101', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 307, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_logn', '101', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 308, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_logn', '101', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 309, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_integer_mod', '104', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(2,-3),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 310, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_mod', '104', 'I', 0, 'smallint,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(1,-2),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 311, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_mod', '104', 'I', 0, 'int8,int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'int8', '(17,-18),(17,-18)', '(17,-18)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 312, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_mod', '104', 'I', 0, 'float,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(3,-4),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 313, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallfloat_mod', '104', 'I', 0, 'smallfloat,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(4,-5),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 314, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_mod', '104', 'I', 0, 'decimal,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(5,-6),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 315, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_mod', '104', 'I', 0, 'money,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(8,-9),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 316, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_varchar_mod', '104', 'I', 0, 'varchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 317, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_char_mod', '104', 'I', 0, 'char,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 318, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nvarchar_mod', '104', 'I', 0, 'nvarchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(16,-17),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 319, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nchar_mod', '104', 'I', 0, 'nchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(15,-16),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 320, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_integer_pow', '105', 'I', 0, 'integer,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 321, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_pow', '105', 'I', 0, 'smallint,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 322, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_pow', '105', 'I', 0, 'int8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 323, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_pow', '105', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 324, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallfloat_pow', '105', 'I', 0, 'smallfloat,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 325, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_pow', '105', 'I', 0, 'decimal,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 326, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_pow', '105', 'I', 0, 'money,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 327, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_varchar_pow', '105', 'I', 0, 'varchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 328, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_char_pow', '105', 'I', 0, 'char,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 329, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nvarchar_pow', '105', 'I', 0, 'nvarchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 330, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nchar_pow', '105', 'I', 0, 'nchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 331, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_integer_root', '106', 'I', 0, 'integer,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 332, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_smallint_root', '106', 'I', 0, 'smallint,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 333, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_int8_root', '106', 'I', 0, 'int8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 334, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_float_root', '106', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 335, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_smallfloat_root', '106', 'I', 0, 'smallfloat,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 336, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_decimal_root', '106', 'I', 0, 'decimal,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 337, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_money_root', '106', 'I', 0, 'money,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 338, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_varchar_root', '106', 'I', 0, 'varchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 339, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_char_root', '106', 'I', 0, 'char,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 340, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_nvarchar_root', '106', 'I', 0, 'nvarchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 341, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_nchar_root', '106', 'I', 0, 'nchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('round', 'informix', 342, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_integer_round', '90', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 343, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_smallint_round', '90', 'I', 0, 'smallint,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 344, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_int8_round', '90', 'I', 0, 'int8,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 345, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_float_round', '90', 'I', 0, 'float,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 346, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_smallfloat_round', '90', 'I', 0, 'smallfloat,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 347, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_decimal_round', '90', 'I', 0, 'decimal,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 348, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_money_round', '90', 'I', 0, 'money,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(8,-9),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 349, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_varchar_round', '90', 'I', 0, 'varchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(13,-14),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 350, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_char_round', '90', 'I', 0, 'char,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(0,-1),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 351, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_nvarchar_round', '90', 'I', 0, 'nvarchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(16,-17),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 352, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_nchar_round', '90', 'I', 0, 'nchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(15,-16),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 353, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_sqrt', '107', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 354, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_sqrt', '107', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 355, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_sqrt', '107', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 356, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_sqrt', '107', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 357, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_sqrt', '107', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 358, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_sqrt', '107', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 359, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_sqrt', '107', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 360, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_sqrt', '107', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 361, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_sqrt', '107', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 362, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_sqrt', '107', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 363, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_sqrt', '107', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 364, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_integer_trunc', '91', 'I', 0, 'integer,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(2,-3),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 365, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_smallint_trunc', '91', 'I', 0, 'smallint,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(1,-2),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 366, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_int8_trunc', '91', 'I', 0, 'int8,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(17,-18),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 367, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_float_trunc', '91', 'I', 0, 'float,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(3,-4),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 368, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_smallfloat_trunc', '91', 'I', 0, 'smallfloat,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(4,-5),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 369, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_decimal_trunc', '91', 'I', 0, 'decimal,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(5,-6),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 370, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_money_trunc', '91', 'I', 0, 'money,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(8,-9),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 371, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_varchar_trunc', '91', 'I', 0, 'varchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(13,-14),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 372, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_char_trunc', '91', 'I', 0, 'char,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(0,-1),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 373, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_nvarchar_trunc', '91', 'I', 0, 'nvarchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(16,-17),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 374, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_nchar_trunc', '91', 'I', 0, 'nchar,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(15,-16),(2,-3)', '(5,-6)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines06", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('cos', 'informix', 375, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_cos', '97', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 376, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_cos', '97', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 377, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_cos', '97', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 378, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_cos', '97', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 379, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_cos', '97', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 380, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_cos', '97', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 381, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_cos', '97', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 382, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_cos', '97', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 383, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_cos', '97', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 384, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_cos', '97', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 385, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_cos', '97', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 386, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_sin', '96', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 387, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_sin', '96', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 388, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_sin', '96', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 389, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_sin', '96', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 390, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_sin', '96', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 391, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_sin', '96', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 392, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_sin', '96', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 393, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_sin', '96', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 394, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_sin', '96', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 395, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_sin', '96', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 396, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_sin', '96', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 397, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_tan', '93', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 398, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_tan', '93', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 399, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_tan', '93', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 400, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_tan', '93', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 401, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_tan', '93', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 402, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_tan', '93', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 403, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_tan', '93', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 404, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_tan', '93', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 405, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_tan', '93', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 406, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_tan', '93', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 407, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_tan', '93', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 408, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_acos', '99', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 409, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_acos', '99', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 410, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_acos', '99', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 411, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_acos', '99', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 412, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_acos', '99', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 413, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_acos', '99', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 414, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_acos', '99', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 415, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_acos', '99', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 416, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_acos', '99', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 417, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_acos', '99', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 418, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_acos', '99', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 419, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_asin', '98', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 420, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_asin', '98', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 421, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_asin', '98', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 422, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_asin', '98', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 423, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_asin', '98', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 424, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_asin', '98', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 425, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_asin', '98', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 426, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_asin', '98', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 427, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_asin', '98', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 428, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_asin', '98', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 429, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_asin', '98', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 430, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_integer_atan', '94', 'I', 0, 'integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 431, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallint_atan', '94', 'I', 0, 'smallint', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 432, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_int8_atan', '94', 'I', 0, 'int8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 433, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_float_atan', '94', 'I', 0, 'float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 434, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_smallfloat_atan', '94', 'I', 0, 'smallfloat', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 435, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_decimal_atan', '94', 'I', 0, 'decimal', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 436, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_money_atan', '94', 'I', 0, 'money', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 437, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_atan', '94', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 438, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_atan', '94', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 439, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_atan', '94', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 440, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_atan', '94', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 441, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_integer_atan2', '95', 'I', 0, 'integer,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(2,-3),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 442, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallint_atan2', '95', 'I', 0, 'smallint,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(1,-2),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 443, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_int8_atan2', '95', 'I', 0, 'int8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(17,-18),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 444, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_float_atan2', '95', 'I', 0, 'float,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(3,-4),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 445, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_smallfloat_atan2', '95', 'I', 0, 'smallfloat,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(4,-5),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 446, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_decimal_atan2', '95', 'I', 0, 'decimal,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(5,-6),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 447, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_money_atan2', '95', 'I', 0, 'money,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(8,-9),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 448, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_varchar_atan2', '95', 'I', 0, 'varchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(13,-14),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 449, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_char_atan2', '95', 'I', 0, 'char,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(0,-1),(3,-4)', '(3,-4)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines07", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('atan2', 'informix', 450, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nvarchar_atan2', '95', 'I', 0, 'nvarchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(16,-17),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 451, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_nchar_atan2', '95', 'I', 0, 'nchar,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(15,-16),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('length', 'informix', 452, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_length', '16', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('length', 'informix', 453, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_length', '16', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('length', 'informix', 454, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_length', '16', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(16,-17)', '(2,-3)'); insert into informix.sysbuiltinroutines values('length', 'informix', 455, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_length', '16', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(15,-16)', '(2,-3)'); insert into informix.sysbuiltinroutines values('length', 'informix', 456, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_bytes_length', '16', 'I', 0, 'references byte', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(11,-12)', '(2,-3)'); insert into informix.sysbuiltinroutines values('length', 'informix', 457, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_text_length', '16', 'I', 0, 'references text', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(12,-13)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 458, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_octet_length', '74', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 459, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_octet_length', '74', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 460, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_octet_length', '74', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(16,-17)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 461, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_octet_length', '74', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(15,-16)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 462, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_bytes_octet_length', '74', 'I', 0, 'references byte', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(11,-12)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 463, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_text_octet_length', '74', 'I', 0, 'references text', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(12,-13)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 464, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_char_length', '75', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 465, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_char_length', '75', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 466, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_char_length', '75', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(16,-17)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 467, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_char_length', '75', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(15,-16)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 468, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_bytes_char_length', '75', 'I', 0, 'references byte', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(11,-12)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 469, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_text_char_length', '75', 'I', 0, 'references text', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(12,-13)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 470, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_varchar_character_length', '75', 'I', 0, 'varchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(13,-14)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 471, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_char_character_length', '75', 'I', 0, 'char', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(0,-1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 472, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nvarchar_character_length', '75', 'I', 0, 'nvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(16,-17)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 473, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_nchar_character_length', '75', 'I', 0, 'nchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(15,-16)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 474, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_bytes_character_length', '75', 'I', 0, 'references byte', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(11,-12)', '(2,-3)'); insert into informix.sysbuiltinroutines values('character_length', 'informix', 475, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_text_character_length', '75', 'I', 0, 'references text', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(12,-13)', '(2,-3)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 476, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_equal)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 477, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_notequal)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 478, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_greaterthan)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 479, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_lessthan)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 480, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_gte)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 481, 'P', 132, 418, 7, 4, 2, 'f', NULL, '(lvarchar_lte)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 482, 'P', 67, 353, 7, 4, 2, 'f', NULL, '(lvarchar_compare)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(40,1),(40,1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 483, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_equal', '9', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 484, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_equal', '9', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, 'equal', 'notequal', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 485, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_not_equal', '26', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 486, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_not_equal', '26', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, 'notequal', 'equal', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 487, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_greater_than', '13', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthan', 'informix', 488, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_greater_than', '13', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, 'lessthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 489, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_less_than', '18', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthan', 'informix', 490, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_less_than', '18', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthanorequal', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 491, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_greater_than_or_equal', '12', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('greaterthanorequal', 'informix', 492, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_greater_than_or_equal', '12', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, 'lessthan', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 493, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial_less_than_or_equal', '15', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(6,-7),(6,-7)', '(41,5)'); insert into informix.sysbuiltinroutines values('lessthanorequal', 'informix', 494, 'P', 132, 286, 7, 4, 2, 'f', 'ifx_serial8_less_than_or_equal', '15', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, 'greaterthan', NULL,'f', 'CPU', NULL, 'boolean', '(18,-19),(18,-19)', '(41,5)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 495, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_negate', '23', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial', '(6,-7)', '(6,-7)'); insert into informix.sysbuiltinroutines values('negate', 'informix', 496, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_negate', '23', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial8', '(18,-19)', '(18,-19)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 497, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_minus', '23', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(6,-7)', '(5,-6)'); insert into informix.sysbuiltinroutines values('minus', 'informix', 498, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_minus', '23', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(18,-19)', '(5,-6)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 499, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_positive', '35', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial', '(6,-7)', '(6,-7)'); insert into informix.sysbuiltinroutines values('positive', 'informix', 500, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_positive', '35', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial8', '(18,-19)', '(18,-19)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 501, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_plus', '35', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(6,-7)', '(5,-6)'); insert into informix.sysbuiltinroutines values('plus', 'informix', 502, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_plus', '35', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, 'plus', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(18,-19)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 503, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_times', '25', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(6,-7)', '(5,-6)'); insert into informix.sysbuiltinroutines values('times', 'informix', 504, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_times', '25', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, 'times', NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(18,-19)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 505, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_divide', '8', 'I', 0, 'serial,serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(6,-7)', '(5,-6)'); insert into informix.sysbuiltinroutines values('divide', 'informix', 506, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_divide', '8', 'I', 0, 'serial8,serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(18,-19)', '(5,-6)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 507, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_abs', '100', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial', '(6,-7)', '(6,-7)'); insert into informix.sysbuiltinroutines values('abs', 'informix', 508, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_abs', '100', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'serial8', '(18,-19)', '(18,-19)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 509, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_exp', '103', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('exp', 'informix', 510, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_exp', '103', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 511, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_hex', '92', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(6,-7)', '(0,-1)'); insert into informix.sysbuiltinroutines values('hex', 'informix', 512, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_hex', '92', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'char', '(18,-19)', '(0,-1)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 513, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_log10', '102', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('log10', 'informix', 514, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_log10', '102', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 515, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_logn', '101', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('logn', 'informix', 516, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_logn', '101', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 517, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_mod', '104', 'I', 0, 'serial,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(6,-7),(2,-3)', '(2,-3)'); insert into informix.sysbuiltinroutines values('mod', 'informix', 518, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_mod', '104', 'I', 0, 'serial8,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'int8', '(18,-19),(2,-3)', '(17,-18)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 519, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_pow', '105', 'I', 0, 'serial,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('pow', 'informix', 520, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_pow', '105', 'I', 0, 'serial8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 521, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_serial_root', '106', 'I', 0, 'serial,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('root', 'informix', 522, 'P', 67, 251, 7, 4, 2, 'f', 'ifx_serial8_root', '106', 'I', 0, 'serial8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('round', 'informix', 523, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_serial_round', '90', 'I', 0, 'serial,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('round', 'informix', 524, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_serial8_round', '90', 'I', 0, 'serial8,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(2,-3)', '(5,-6)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "insertsysbuiltinroutines08", "%SYSBLDUSER%", 0, "insert into informix.sysbuiltinroutines values('sqrt', 'informix', 525, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_sqrt', '107', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sqrt', 'informix', 526, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_sqrt', '107', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 527, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_serial_trunc', '91', 'I', 0, 'serial,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(6,-7),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('trunc', 'informix', 528, 'P', 67, 233, 7, 4, 2, 'f', 'ifx_serial8_trunc', '91', 'I', 0, 'serial8,integer', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'decimal', '(18,-19),(2,-3)', '(5,-6)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 529, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_cos', '97', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('cos', 'informix', 530, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_cos', '97', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 531, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_sin', '96', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('sin', 'informix', 532, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_sin', '96', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 533, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_tan', '93', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('tan', 'informix', 534, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_tan', '93', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 535, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_acos', '99', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('acos', 'informix', 536, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_acos', '99', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 537, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_asin', '98', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('asin', 'informix', 538, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_asin', '98', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 539, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial_atan', '94', 'I', 0, 'serial', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan', 'informix', 540, 'P', 67, 151, 7, 4, 1, 'f', 'ifx_serial8_atan', '94', 'I', 0, 'serial8', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 541, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial_atan2', '95', 'I', 0, 'serial,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(6,-7),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('atan2', 'informix', 542, 'P', 67, 221, 7, 4, 2, 'f', 'ifx_serial8_atan2', '95', 'I', 0, 'serial8,float', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'float', '(18,-19),(3,-4)', '(3,-4)'); insert into informix.sysbuiltinroutines values('like', 'informix', 543, 'P', 132, 392, 7, 4, 2, 'f', 'ifx_lvarchar_like_with_no_escape', '17', 'I', 0, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('like', 'informix', 544, 'P', 132, 515, 7, 4, 3, 'f', 'ifx_lvarchar_like_with_escape', '17', 'I', 0, 'lvarchar,lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 545, 'P', 132, 392, 7, 4, 2, 'f', 'ifx_lvarchar_matches_binary', '19', 'I', 0, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('matches', 'informix', 546, 'P', 132, 515, 7, 4, 3, 'f', 'ifx_lvarchar_matches_trinary', '19', 'I', 0, 'lvarchar,lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'boolean', '(40,1),(40,1),(40,1)', '(41,5)'); insert into informix.sysbuiltinroutines values('concat', 'informix', 547, 'P', 133, 419, 7, 4, 2, 'f', NULL, '(lvarchar_concat)', 'I', 1, 'lvarchar,lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'lvarchar', '(40,1),(40,1)','(40,1)'); insert into informix.sysbuiltinroutines values('length', 'informix', 548, 'P', 67, 204, 7, 4, 1, 'f', 'ifx_lvarchar_length', '16', 'I', 0, 'lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(40,1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('octet_length', 'informix', 549, 'P', 67, 204, 7, 4, 1, 'f', 'ifx_lvarchar_octet_length', '74', 'I', 0, 'lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(40,1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('char_length', 'informix', 550, 'P', 67, 204, 7, 4, 1, 'f', 'ifx_lvarchar_char_length', '75', 'I', 0, 'lvarchar', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', 'CPU', NULL, 'integer', '(40,1)', '(2,-3)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 551, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collequal)', 'I', 1, 'set,set', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(19,-20),(19,-20)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 552, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collnotequal)', 'I', 1, 'set,set', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(19,-20),(19,-20)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 553, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collequal)', 'I', 1, 'list,list', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(21,-22),(21,-22)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 554, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collnotequal)', 'I', 1, 'list,list', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(21,-22),(21,-22)', '(41,5)'); insert into informix.sysbuiltinroutines values('equal', 'informix', 555, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collequal)', 'I', 1, 'multiset,multiset', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(20,-21),(20,-21)', '(41,5)'); insert into informix.sysbuiltinroutines values('notequal', 'informix', 556, 'P', 132, 286, 7, 4, 2, 'f', NULL, '(collnotequal)', 'I', 1, 'multiset,multiset', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'boolean', '(20,-21),(20,-21)', '(41,5)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 557, 'P', 67, 221, 7, 4, 2, 'f', NULL, '(collcompare)', 'I', 1, 'set,set', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(19,-20),(19,-20)', '(2,-3)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 558, 'P', 67, 221, 7, 4, 2, 'f', NULL, '(collcompare)', 'I', 1, 'multiset,multiset', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(20,-21),(20,-21)', '(2,-3)'); insert into informix.sysbuiltinroutines values('compare', 'informix', 559, 'P', 67, 221, 7, 4, 2, 'f', NULL, '(collcompare)', 'I', 1, 'list,list', 'f', 'f', 'f', 'f', 0, NULL, NULL, NULL,'f', NULL, NULL, 'integer', '(21,-22),(21,-22)', '(2,-3)'); ", "f", " ", "f" ); insert into sysbldobjects (bld_id, obj_kind, obj_signature, obj_owner, sequence, create_sql, create_can_fail, drop_sql, drop_can_fail) values ( "%SYSBLDNAME%", 0, "sysbldregistered", "%SYSBLDUSER%", 0, "insert into sysbldregistered (bld_id) values ( ""%SYSBLDNAME%"" ); ", "f", "delete from sysbldregistered where bld_id = ""%SYSBLDNAME%""; ", "f" );