当create table,应用到FOR MIXED DATA 时,出现Error:
-622 FOR MIXED DATA IS INVALID BECAUSE THE MIXED DATA INSTALL OPTION IS NO
具体描述:
https://www.ibm.com/support/knowledgecenter/ca/SSEPEK_11.0.0/codes/src/tpc/n622.html
其中:
Programmer response:
Either change the installation option or the FOR clause. If the installation option is correctly set to NO, the allowable FOR clause options are BIT and SBCS.
没找到安装时设置的地方,最后找到错误原因是因为字符集报错。
通过创建两个db测试:
db2 create database testdb1 using codeset iso8859-1 territory US;
db2 create database testdb2 using codeset UTF-8 territory US;
testdb1报错, testdb2就不报错了。