软件开发
The row length of the table exceeded a limit of "32677" bytes.
变态建表语句如下.
E:daodev>db2 "create table lg32 (col1 varchar(10000), col2 varchar(10000),col3 varchar(10000), col4 varchar(10000)) in tbs_as_32k_1g"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0670N The row length of the table exceeded a limit of "32677" bytes.
(Table space "".) SQLSTATE=54010
E:daodev>
请问如何才能将此表成功建立. ?
排除建多张表然后view来join :-)
E:daodev>db2 "create table lg32 (col1 varchar(10000), col2 varchar(10000),col3 varchar(10000), col4 varchar(10000)) in tbs_as_32k_1g"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0670N The row length of the table exceeded a limit of "32677" bytes.
(Table space "".) SQLSTATE=54010
E:daodev>
请问如何才能将此表成功建立. ?
排除建多张表然后view来join :-)
4同行回答
tks a lot.收起
浏览1984
已经超过32k表空间限制大小了，可以varchar改成lob字段，lob字段在表空间存放为指针形式。收起
浏览1555
单行记录的大小是受表空间pagesize大小限制的，如下：
The row length of a table in the database manager cannot exceed:
* 4005 bytes in a table space with a 4K page size
* 8101 bytes in a table space with an 8K page size
* 16293 bytes in a table space with an 16K page size
* 32677 bytes in a table space with an 32K page size
你的建表语句，超出限制了，建议更改类型，如clob
db2 "create table lg32 (col1 CLOB(10000), col2 CLOB(10000),col3 CLOB(10000), col4 CLOB(10000))
in tbs_as_32k_1g "收起
The row length of a table in the database manager cannot exceed:
* 4005 bytes in a table space with a 4K page size
* 8101 bytes in a table space with an 8K page size
* 16293 bytes in a table space with an 16K page size
* 32677 bytes in a table space with an 32K page size
你的建表语句，超出限制了，建议更改类型，如clob
db2 "create table lg32 (col1 CLOB(10000), col2 CLOB(10000),col3 CLOB(10000), col4 CLOB(10000))
in tbs_as_32k_1g "收起
浏览1520