SQL3550W 带GENERATED ALWAYS字段的表的import
果表里有字段定义为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