建联合主键报错DB2 Database Error: ERROR [42997] [IBM][DB2/AIX64] SQL0270N Function not supported (Reason c
来源:互联网 发布:聚宝盆直播软件安卓版 编辑:程序博客网 时间:2024/05/23 10:18
CREATE TABLE "mmm"."test" ( --建表语句
"A" DATE,
"B" VARCHAR(36),
"C" VARCHAR(50),
"D" VARCHAR(25) not null,
"E" VARCHAR(15) not null,
"A" DATE,
"B" VARCHAR(36),
"C" VARCHAR(50),
"D" VARCHAR(25) not null,
"E" VARCHAR(15) not null,
) IN "MA_DATA"
DISTRIBUTE BY hash ("C") ;
alter table "mmm"."test" add primary key(D,E); --创建联合主键语句 就是运行这个语句时报此错误;
错误原因是必须要把 DISTRIBUTE BY hash ("C") ; 改为联合主键的任意一个字段就ok了
如下
drop table "mmm"."test" ;
CREATE TABLE "mmm"."test" ( --建表语句
"A" DATE,
"B" VARCHAR(36),
"C" VARCHAR(50),
"D" VARCHAR(25) not null,
"E" VARCHAR(15) not null,
) IN "MA_DATA"
DISTRIBUTE BY hash ("D") ;
0 0
- 建联合主键报错DB2 Database Error: ERROR [42997] [IBM][DB2/AIX64] SQL0270N Function not supported (Reason c
- 建联合主键报错DB2 Database Error: ERROR [42997] [IBM][DB2/AIX64] SQL0270N Function not supported (Reason c
- DB2报错:SQL1043C Database Services could not initialize the system catalogs. Error "-968" was returned.
- DB2异常com.ibm.db2.jcc.c.DisconnectException: encoding not supported的一种解决方法
- 解决:DB2com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!
- 使用DB2报错:ERROR [42818] [IBM][DB2/NT] SQL0401N The data types of the operands for the operation "=" a
- db2 连接时com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!原因
- JDev Bug: Database platform class [IBM DB2] not found
- DB2报错 sql error -668, sqlstate 57016
- SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2;reason code 10
- mybatis + DB2数据库常见报错:jdbc type 0 not yet supported
- BuildForge使用默认的DB2 Express运行时出现ERROR [IBM][CLI Driver][DB2/6000] SQL0964C The transaction log for the database is full. SQLSTATE
- 安装DB2报错: Error: The required library file libstdc++.so.5 is not found on the system.
- CentOS 6.4 下DB2登录报错SQL30082N reason "26"
- db2 error code all
- db2 error code
- DB2 error 289
- Db2 client上load from cursor报错SQL1013N The database name .. could not be found
- DOM元素
- poj 1811 Prime Test(大素数判定和素因子分解)
- mvc 跳转到另一个controler
- VS 2010 快捷键大全
- hdoj1262 寻找素数对
- 建联合主键报错DB2 Database Error: ERROR [42997] [IBM][DB2/AIX64] SQL0270N Function not supported (Reason c
- Vuforia Unity Camera Image Access
- 从模板生成代码
- 定时器
- 第二课:Android的事件处理(基于回调)
- IO-FileReader、FileWriter类
- mysql优化之sql语句优化
- Qt QMap
- 关于http 缓存处理的步奏