SQL3550W 带GENERATED ALWAYS字段的表的import

November 6, 2009 by 阿桂  
Filed under db2, 数据库技术

果表里有字段定义为GENERATED ALWAYS,那么import的时候会报错:

SQL3550W The field value in row “1″ and column “1″ is not NULL, but the
target column has been defined as GENERATED ALWAYS.

参照《包含生成列的 DB2 表上的数据移入和移出 — 入门》,用以下语句来导入数据:

db2 “import from of del|ixf modified by identityignore insert into #tablename# “

Comments

No Comments

(Required)
(Required, will not be published)

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word