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

Cameron%20Taggart's gravatar image

Cameron Taggart
1076610
accept rate: 0%


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:

  1. the function CONNECTION_PROPERTY, as in SELECT CONNECTION_PROPERTY ( 'non_keywords' );

  2. the system procedure sa_conn_info()

  3. the system procedure sa_conn_options() (version 10 and up).
permanent link

answered 14 May '10, 22:39

Glenn%20Paulley's gravatar image

Glenn Paulley
10.7k571104
accept rate: 43%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×14

question asked: 14 May '10, 20:44

question was seen: 741 times

last updated: 14 May '10, 22:39