to find out the current value of a cqd (initial default value, or value inserted into system defaults table, or value set in a session by user), do:
cqd showcontrol_show_all 'ON'; showcontrol default traf_default_col_charset; >>cqd showcontrol_show_all 'ON'; --- SQL operation complete. >>showcontrol default traf_default_col_charset; No CONTROL QUERY DEFAULT TRAF_DEFAULT_COL_CHARSET settings are in effect. Current DEFAULTS TRAF_DEFAULT_COL_CHARSET ISO88591 --- SQL operation complete. >> The cqd showcontrol_show_all is needed to show all cqds whether they are externalized or not. An internal setting in file sqlcomp/nadefaults.cpp determines which cqds are externalized and which are for support but this has not always been correctly set. So set this cqd if 'showcontrol default' doesn't return a value. anoop From: Liu, Yuan (Yuan) <[email protected]> Sent: Wednesday, May 9, 2018 5:15 AM To: [email protected] Subject: How to get current character set of Trafodion Hi Trafodioneers, I know that the default character set of Trafodion is iso88591. If we set cqd traf_default_col_charset 'utf8' or put it into "_MD_".defaults table, then the character set will be UTF8. My question is that do we have an approach to know what is the current character set, such as select current_charaset()? Best regards, Yuan
