Finding if table has SRLA (Selective Row Level Aud
Posted in 2014
Hello,
Informix = 11.70FC7
System = RHEL 6.5
Is there a way to write a query to find if a table has or is defined "with
audit" ?
I have an application DB where a small percentage of tables have SLRA on and
would like to be able to identify them with SQL calls, I know I can get the
information with "dbschema -d DB -t TAB -ss " but the tools I am working with
would be easier to construct a query and run against SMI or system catalogs.
I have not been able to find or figure out where the flags are located that
indicate "with audit".
Thanks,
George.
This electronic message transmission contains information from the Company
that may be proprietary, confidential and/or privileged. The information is
intended only for the use of the individual(s) or entity named above. If you
are not the intended recipient, be aware that any disclosure, copying or
distribution or use of the contents of this information is prohibited. If you
have received this electronic transmission in error, please notify the sender
immediately by replying to the address listed in the "From:" field.