Hi all!
I need to create a "log writer" procedure which can be called for every store procedure in de database, but it must be "transaction independent" because I could call this "annotation utility" several times in the same "work unit". Ej:
CREATE PROCEDURE BDI.PRUEBAS
P1: BEGIN
insert into bdi.lines values ('90519','ITEM');
call bdi.agregate_data;
call bdi.csii_log('Data agregated',00.0);
call bdi.alter_data;
call bdi.csii_log('Data altered',00.0);
rollback;
END P1
This example has not more sense, but i'm making tests.
The final idea is to call diferente process from one master process and rollback all the work if something fails, but i need to get a log of the diferent steps..... And i would like this "log writer" will be "independent".
Could someone help me please? I don't see a solution.
Thanks a lot and sorry for my english
Juan Carlos
I need to create a "log writer" procedure which can be called for every store procedure in de database, but it must be "transaction independent" because I could call this "annotation utility" several times in the same "work unit". Ej:
CREATE PROCEDURE BDI.PRUEBAS
P1: BEGIN
insert into bdi.lines values ('90519','ITEM');
call bdi.agregate_data;
call bdi.csii_log('Data agregated',00.0);
call bdi.alter_data;
call bdi.csii_log('Data altered',00.0);
rollback;
END P1
This example has not more sense, but i'm making tests.
The final idea is to call diferente process from one master process and rollback all the work if something fails, but i need to get a log of the diferent steps..... And i would like this "log writer" will be "independent".
Could someone help me please? I don't see a solution.
Thanks a lot and sorry for my english
Juan Carlos