Check if flag on or off in Sybase ASE

Question

In Sybase ASE, is there a way to check if any of the flags is on or off via a query?

Answer 1

Yes, there is a way to do so based on the sysconfigures table, which contains all configuration flags.

You can list them all using this SQL query:

SELECT cr.name, cr.value, cr.status
FROM sysconfigures cr
WHERE cr.name = 'flag_name';

I am sure this returns what you need, but may need some adjustments to better fit you your case. Let us know how it goes. Finally, you may hit permission issues since the sysconfigures table is a system table.