In a stored procedure i want to know in which database the procedure is working ? how can we retreive this name ?
we're using same procedure in logged and non logged db.
in logged we've has to use transaction : begin-commit-rollback, in non logged we get error -256 when used;
If we know the database of the procedure we could retreive column is_logging from sysmaster:sysdatabases for that database and make a variable syntax in the SPL. like "if logging = 1 then begin work ; end if;"