你好,我想通过一个脚本将数据插入到一个具有自增列的DB2表中。我了解到可以使用以下语法:
INSERT INTO SOME_TABLE OVERRIDING SYSTEM VALUE ...
看起来应该可行,但实际上却不行。以下是具体的查询语句:
INSERT INTO SCHEMA.MYTABLE OVERRIDING SYSTEM VALUE (
IDENTITY_COLUMN
,SOMEVALUE
,CREATEDTIME
,UPDATEDTIME
) VALUES (
2
,'656566'
,'2012-07-12 16:25:34'
,NULL
);
I get the following error:
SQL0104N An unexpected token "VALUE" was found following "DE OVERRIDING
SYSTEM". Expected tokens may include: "<space>". SQLSTATE=42601
谢谢!
OVERRIDING SYSTEM VALUE
子句似乎只在DB2 for i中有效。 - mustaccioISO/IEC 9075-2:2016(E) 14.11 <insert statement>
。由于Db2相当符合标准,我认为这与版本和平台无关。 - Lukas Eder