How do I see what options are set for the current database?
The database is supposed to have this option set: set option non_keywords = 'merge';
How can I see if this is actually set?
asked 14 May '10, 20:44
Querying the catalog view SYSOPTION (or SYSOPTIONS, which gives you a slightly different result) will tell you what the permanent settings are for a particular option - note that there may exist multiple settings for this option, one for PUBLIC certainly and then one for each user who has set their permanent setting as well.
In order to determine what the actual value is for a connection - and to handle the fact that temporary changes to options are not written to the catalog table ISYSOPTION - you need to use one of:
answered 14 May '10, 22:39