Here is some of the functions.
create opaque type "informix".sysbldsqltext
(
internallength=variable,
maxlen=24000,
alignment=1
);
grant usage on type "informix".sysbldsqltext to 'public' as "informix";
create opaque type "informix".lld_lob
(
internallength=76,
alignment=8
);
grant usage on type "informix".lld_lob to 'public' as "informix";
create row type "informix".lld_locator
(
lo_protocol char(18),
lo_pointer lld_lob,
lo_location lvarchar
);
grant usage on type "informix".lld_locator to 'public' as "informix";
create opaque type "informix".ifxmrdata
(
internallength=variable,
maxlen=2048,
alignment=4,
cannothash
);
grant usage on type "informix".ifxmrdata to 'public' as "informix";
create row type "informix".ifxdocdesc
(
format varchar(18),
version varchar(10),
location lld_locator,
params lvarchar
);
grant usage on type "informix".ifxdocdesc to 'public' as "informix";
create row type "informix".etx_internalhilite
(
amparam lvarchar,
part_num integer,
index_name varchar(18),
sbspace varchar(18),
expanded_clue lvarchar
);
grant usage on type "informix".etx_internalhilite to 'public' as "informix";
create row type "informix".etx_returntype
(
score smallfloat,
hilite_info etx_internalhilite
);
grant usage on type "informix".etx_returntype to 'public' as "informix";
create row type "informix".etxfsestoragerow
(
sto_name char(255),
num_buckets integer,
bucket_num integer,
bucket blob
);
grant usage on type "informix".etxfsestoragerow to 'public' as "informix";
create distinct type "informix".etxfsestoarearow as etxfsestoragerow ;
grant usage on type "informix".etxfsestoarearow to 'public' as "informix";
create row type "informix".etx_hilitetype
(
vec_offset clob,
viewer_doc blob
);
grant usage on type "informix".etx_hilitetype to 'public' as "informix";
create row type "informix".etx_fragfreq
(
fragment integer,
frequency integer
);
grant usage on type "informix".etx_fragfreq to 'public' as "informix";
create row type "informix".etx_fragnumwords
(
fragment integer,
total integer,
unique integer
);
grant usage on type "informix".etx_fragnumwords to 'public' as "informix";
create row type "informix".etx_numwords
(
total integer,
unique integer
);
grant usage on type "informix".etx_numwords to 'public' as "informix";
create implicit cast (lvarchar as sysbldsqltext with "informix".sysbldsqltextin);
create explicit cast (sysbldsqltext as lvarchar with "informix".sysbldsqltextout);
create explicit cast (sysbldsqltext as sendrecv with "informix".sysbldsqltextsend);
create implicit cast (sendrecv as sysbldsqltext with "informix".sysbldsqltextrecv);
create implicit cast (impexp as sysbldsqltext with "informix".sysbldsqltextimpt);
create explicit cast (sysbldsqltext as impexp with "informix".sysbldsqltextexpt);
create implicit cast (impexpbin as sysbldsqltext with "informix".sysbldsqltextimpb);
create explicit cast (sysbldsqltext as impexpbin with "informix".sysbldsqltextexpb);
create implicit cast (lvarchar as lld_lob with "informix".lld_lobin);
create explicit cast (lld_lob as lvarchar with "informix".lld_lobout);
create explicit cast (lld_lob as sendrecv with "informix".lld_lobsend);
create implicit cast (sendrecv as lld_lob with "informix".lld_lobrecv);
create implicit cast (impexp as lld_lob with "informix".lld_lobimpt);
create explicit cast (lld_lob as impexp with "informix".lld_lobexpt);
create implicit cast (blob as lld_lob with "informix".lld_lobcast);
create implicit cast (clob as lld_lob with "informix".lld_lobcast);
create implicit cast (lld_lob as blob with "informix".blobcast);
create implicit cast (lld_lob as clob with "informix".clobcast);
create implicit cast (lvarchar as ifxmrdata with "informix".ifxmrdatain);
create explicit cast (ifxmrdata as lvarchar with "informix".ifxmrdataout);
create explicit cast (ifxmrdata as sendrecv with "informix".ifxmrdatasend);
create implicit cast (sendrecv as ifxmrdata with "informix".ifxmrdatarecv);
create implicit cast (impexp as ifxmrdata with "informix".ifxmrdataimpt);
create explicit cast (ifxmrdata as impexp with "informix".ifxmrdataexpt);
create explicit cast (row as ifxmrdata with "informix".ifxmrdatacast);
create explicit cast (lvarchar as ifxdocdesc with "informix".rowinput);
create function "informix".enable_slc_session ( integer ) returns integer external name '(mi_enable_sql_logical_char_db)' language C
;
create function "informix".disable_slc_session ( ) returns integer external name '(mi_disable_sql_logical_char_db)' language C
;
create function "informix".txt_release ()
returns lvarchar
external name "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)" language c;
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
create function "informix".etx_begin_scan (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_begin_scan)"
language c;
create function "informix".etx_check_index (pointer,integer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_check_index)"
language c;
create function "informix".etx_close_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_close_index)"
language c;
create function "informix".etx_create_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_create_index)"
language c;
create function "informix".etx_delete_index (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_delete_index)"
language c;
create function "informix".etx_drop_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_drop_index)"
language c;
create function "informix".etx_end_scan (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_end_scan)"
language c;
create function "informix".etx_get_next (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_get_next)"
language c;
create function "informix".etx_insert_index (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_insert_index)"
language c;
create function "informix".etx_rescan_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_rescan_index)"
language c;
create function "informix".etx_scan_cost (pointer,pointer)
returns real
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_scan_cost)"
language c;
create function "informix".etx_update_index (pointer,pointer,pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_update_index)"
language c;
create function "informix".etx_contains (
doc lvarchar,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc varchar(255),
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc char,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc lvarchar,
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc varchar(255),
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc char,
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc clob,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains9)'
language C not variant;
create function "informix".etx_contains (
doc blob,
query ROW(clue varchar(255))
Thanks, Jeff