Hi, I have IBM Informix schema and want to extract data with Splunk from it like this:
table name | Index | Trigger
grupo_oper | type_idx | upload
Here is the sample schema:
grant dba to "informix";
{ TABLE "informix".grupo_oper row size = 8 number of columns = 2 index size = 0 }
create table "informix".**grupo_oper**
(
cod_gru_operat integer,
cod_operatoria integer
);
revoke all on "informix".grupo_oper from "public";
create index "informix".**type_idx** on "informix".utility (type)
create trigger "informix".**upload** insert on "informix"
grant select on "informix".grupo_oper to "public" as "informix";
grant update on "informix".grupo_oper to "public" as "informix";
grant insert on "informix".grupo_oper to "public" as "informix";
grant delete on "informix".grupo_oper to "public" as "informix";
grant index on "informix".grupo_oper to "public" as "informix";
create procedure "informix".sgc_var_param_var( c char(30)) returning smallint;
-- created by valau
return 1;
end procedure;
grant execute on "informix".sgc_var_param_var to "public" as "informix";
Any recommendation?