Re:

Keith, The sysmaster database is not a normal database and therfore triggers don't work. It says so in the manuals. The way I get around this (if you really need to)is by polling it. I wrote an articule about this a while back that's on our web site. http://www.advancedatatools.com/Articles/sysmast.htm Regards - Lester "Lewis, Keith A." wrote: > > Hello, > I am trying to create a trigger on table sysmaster:syssdblock. It > lets me create the trigger but it does not seem to working. > > The trigger is: > create trigger chk_sql_stmt insert on sysmaster:syssdblock > referencing new as new_sql > for each row (insert into "bbudba".sqlstmts values ( > new_sql.sdb_sessionid));> > The the priviledge to insert into 'bbudba'.sqlstmts is open to public and > the same with sysmaster:syssdblock but nothing gets put into the sqlstmts > table when a query is run. What am I missing? > > Thanks for any help. > > > > Keith A. Lewis > The Timken Company > lewis@timken.com > (330) 471-4119 > (330) 471-4034 (FAX) -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Visit our Web page: http://www.advancedatatools.com Washington Area Informix User Group: http://www.iiug.org/~waiug/ ______________________________________________________________________