java调用DB2存储过程杂谈

uncommitted read--为落实的读（UR）
cursor stability--游标稳定性（CS）
read stability--读稳定性（RS）
repeatable read--可重复读（RR）

select count(*) from tab1 with UR
--快速清理数据
alter table activate not logged initially with empty table 

fetch first n rows only

sql procedural language--SQL PL 存储过程基础

set total = 100; 等价于 values(100) into total

create procedure set()
dynamic result sets 1
language sql
begin
declare cur cursor with return to client
	for select name,dept,job
		from staff
		where salary > 20000;
open cur;
end

try{
	//connect to sample database
	String url = "jdbc:db2:sample";
	con = DriverManager.getConnection(url);
	CallableStatement cs = con.prepareCall("call trunc_demo(?,?)");
	//register the output  parameters
	callstmt.registerOutParameter(1,Types.VARCHAR);
	callstmt.registerOutParameter(1,Types.VARCHAR);
}catch(Exception e){
	/*exception handling logic goes here*/
}