Steve wrote:
How can I check the logging status of the current session? I thought
I might be able to call dbmsinfo, but I don't see an option for logging.
Logging is one of those terms (like "key") that is so overloaded with
meanings that I could lead you seriously astray if I just assume I
know what logging is of interest.
If you mean transaction logging: Ingres just does it. You can (if you
are very bold or very careful) turn it off, but you can't turn it off
by accident. Running with transaction logging turned off is potentially
a catastrophe waiting to happen. If you think it's not turned on you
should probably shut Ingres down till you find out who did it and send
them for re-education.
If you mean journaling: HELP TABLE will tell you if a specific table is journalled. All tables are created with journalling on by default
unless that default has been changed. The default can be examined (and
changed) using CBF. Sessions cannot control whether their activity is journalled; it is system-wide behaviour.
If you mean SC930/session activity logging: I don't think there is a way
to ask the session. You can take a look in the configured logging
location (ingprenv II_SC930_LOC if you're using Ingres 9/10.x) to see if
there is an appropriately named file with a recent/changing timestamp.
But perhaps you mean another kind of logging...
Roy
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)