Hi,
One can also create (or add to the file it already exists) a text file
called SQSystemDefaults.conf in the directory $MY_SQROOT/etc and add
attribute name and the value it should be set to in the file.
I think each attribute should in a separate line and the attribute value
should NOT be surrounded by single quotes as we would do from sqlci/trafci.
This file is also created by install_local_hadoop. if this script was used,
you may see an empty file with a few comments in your instance.
Thanks
Suresh
On Tue, Feb 2, 2016 at 12:34 PM, Eric Owhadi <eric.owh...@esgyn.com> wrote:
> Thanks Anoop,
>
> So I will use the following insert statement:
>
> insert into "_MD_".defaults values ('MY_CQD', 'value of CQD', 'comment why
> it is inserted');
>
>
>
> Eric
>
>
>
>
>
>
>
> *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com]
> *Sent:* Tuesday, February 2, 2016 12:29 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: How to change default CQD?
>
>
>
> You can change it in code by modifying the defaults array in
> sqlcomp/nadefaults.cpp
>
> or you can insert the default value in system defaults table
> trafodion.“_MD_”.defaults.
>
> If you do the insert, you will need to restart dcs servers to pick up the
> new value.
>
>
>
> anoop
>
>
>
> *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com]
> *Sent:* Tuesday, February 2, 2016 10:26 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* How to change default CQD?
>
>
>
> Hello Trafodioneers,
>
> I have seen in the code that there is a way to globally change the default
> Control Query Default values. But I can’t find it in the docs.
>
> Can someone help me on this?
>
> Regards,
> Eric
>
>
>
