Unable to see fully qualified name in a trigger for seme instance

we have created as view using fully qualified name but while getting schema it is not showing complete DB address.

scenario is given below.

create table test_table (
col1 int,
col2 varchar(20),
col3 datetime year to second
default current year to second
);

create table aelog
(
sr serial not null ,
usr varchar(100),
tstamp datetime year to second
default current year to second,
pk bigint
);

create trigger aetrg select of col2 on test_table referencing old as prv
for each row
when ((USER != 'root' ) )
(
insert into testdb@inst0016_net_02:aelog (usr,pk) values (USER ,prv.col1 ));

while getting schema it is not showing the name like testdb@inst0016_net_02

We have used following commnad to fetch schema but unable to get exact detail of trigger .
dbschema -d testdb -t test_table

{ TABLE "informix".test_table row size = 33 number of columns = 3 index size = 0 }

create table "informix".test_table
(
col1 integer,
col2 varchar(20),
col3 datetime year to second
default current year to second
);

revoke all on "informix".test_table from "public" as "informix";

create trigger "informix".aetrg select of col2 on "informix".test_table
referencing old as prv
for each row
when ((USER != 'root' ) )
(
insert into "informix".aelog (usr,pk) values (USER
,prv.col1 ));

Needed By

Not sure -- Just thought it was cool

Post comment

Guest

Reply
| May 22, 2024

Surely this should be raised as a defect!

0 reply Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Unable to see fully qualified name in a trigger for seme instance