Re: The last executed SQL statement
Alexander Nikiforenko wrote on 04/17/99:
>
> Thanks a lot for your Information.
>
> But I want to get triggering statement in a stored procedure
> used as triggered action and then store it in the database.
Try this
-----------
create table track_test (
c1 serial,
c2 int,
c3 char(10)
);
create table track_sql (
id serial,
sid int,
tstamp datetime year to second default current year to second,
sql char(512)
);
create procedure sp_track_upd( )
define i_sesid int;
let i_sesid = dbinfo( 'sessionid' );
insert into track_sql
select 0, i_sesid, current year to second, sqs_statement
from sysmaster:syssqlstat
where sqs_sessionid = i_sesid
;
end procedure;
create trigger track_upd update of c2 on track_test
before (
execute procedure sp_track_upd( )
);
insert into track_test values ( 0, 1, "Hello" );
update track_test set c2 = 55 where c1 < 2;
-----------
HTH
Vardan Aroustamian
>
> Alexander Nikiforenko
> BelCAF, Minsk.
>
> Harinath Venkata
>
> In article <7f829t$g37$1@news.xmission.com>,
> have01@handelsbanken.se wrote:
> >
> > Within the Stored Procedure :
> >
> > SET DEBUG FILE TO "foo.dbg";
> > TRACE ON;
> >
> > This will allow you to trace all the sql statements. If you require to
monitor
> > the statements try running "tail -f foo.dbg"
> >
> > HTH
> >
> > Harinath Venkata
> > Svenska Handelsbanken
> > New York.
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
--
vaar@geocities.com