jdbc:db2://localhost:50000/SAMPLE:currentSchema=mySchema;
jdbc Url结尾是带分号的。IBM大傻叉。
DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016
SQLSTATE=55019 暂时挂起状态
• SQLCODE=-668, SQLSTATE=57016 装入暂挂状态
需要执行：
call sysproc.admin_cmd(‘reorg table my_table_name’);
分页查询
select * from
( select ROW_NUMBER() over (ORDER BY atimestamp) as rownum,ainteger FROM TEST_FIELD_T tft WHERE ainteger >=1
)
where rownum>=1 and rownum<2
MERGE INTO
MERGE INTO “xxx”.“TEST_FIELD_TO” T_EDMI USING (VALUES ( ‘b’ , 2,2)) S_EDMI (ACHAR,ABIGINT,AINTEGER) ON (T_EDMI.AINTEGER = S_EDMI.AINTEGER)
WHEN MATCHED THEN UPDATE SET ACHAR = S_EDMI.ACHAR,ABIGINT = S_EDMI.ABIGINT
WHEN NOT MATCHED THEN INSERT (ACHAR,ABIGINT,AINTEGER) VALUES (S_EDMI.ACHAR,S_EDMI.ABIGINT,S_EDMI.AINTEGER);