.com Solutions Inc. - Logo  
support header buttons
.
FmPro Script Diffbullet 7f FmPro Migrator bullet 7f CGIScripter
.
.
.
. .

 

 


.

. .

 

...
.

support troubleshooting title image

hline f image

Perl CGI Scripts - DB2 SQL0670N Error Troubleshooting

SQL0670N - The row length of the table exceeded a limit of "4005" bytes (Tablespace "USERSPACE1".) SQLSTATE = 54010
The following list shows the maximum row sizes for each page size:
Max Row Size Page Size
4005 4K
8101 8K
16293 16K
32677 32K

Solution1: Reduce the number of VARCHAR fields to be created within the DB2 table.

Solution2: Each VARCHAR column can be created with a width of up to 32672 characters in size. By default, CGIScripter creates DB2 tables using VARCHAR(255) columns for variable sized character data. A limited number of columns of this size may be created in each table. Adjust the table creation SQL commands to insure that the total number of characters for all columns do not exceed 4005 bytes or create the table in a tablespace with a higher page size.

Solution3: Large text columns can be stored as CLOB columns within DB2. CLOB columns are not counted toward the maximum row size limit. Consider converting some VARCHAR columns to CLOB columns to work around maximum row size limitations.



hline f image

hline

. .

.

. .

 

 

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact