[IQUG] [iqug] RE: Dynamic options IQ 16.0

Gehman, Kirby kirby.gehman at sap.com
Thu Dec 6 12:57:44 MST 2018

Escape_character, quoted_identifer and chained are all listed in the docs as “Takes effect immediately”.

For example:

set option public.quoted_identifier = 'off';
select * from sysoption where "option" = 'quoted_identifier';
set option public.quoted_identifier = 'on';
select * from sysoption where "option" = 'quoted_identifier';

The first returns no results, because the string “option” does not equal the string “quoted_identifier”.

The second returns results because the column “option” does contain a value equal to “quoted_identifier”.

Demonstrating that that the option takes effect immediately

Can you provide an example of what you were doing to test setting of the three options, and what version of the server you’re using so I can test?

Kirby Gehman
Platinum Technical Support Engineer
Digital Business Services
SAP North America
T +1 519 883-4803, E kirby.gehman at sap.com

http://www.sap.com/ unsubscribe<https://global.sap.com/profile/unsubscribe.epx?PID=10386&PFID=12894>

From: iqug-bounces at iqug.org <iqug-bounces at iqug.org> On Behalf Of Louie, David
Sent: Thursday, December 6, 2018 1:12 PM
To: iqug at dssolutions.com
Subject: [IQUG] [iqug] Dynamic options IQ 16.0


All these years the assumption was all IQ options that we changed were dynamic and does not require a bounce.

In IQ 16.0 is this still true or has this never been true.

Reason I’m asking is that we changed three options (escape_characters, quoted_identifier, and chained) yesterday and it was not until we bounced the IQ 16.0 server did we
results we wanted.

I know from a recent case we were told we needed to bounce the IQ server after changing FP_NBIT_TOKEN_COUNT_CHECK.


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/about-us/contacts-locations.

© 2018 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20181206/d95ea9e2/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4700 bytes
Desc: image001.png
URL: <http://iqug.org/pipermail/iqug/attachments/20181206/d95ea9e2/attachment-0001.png>

More information about the IQUG mailing list