SQLWays转换 Microsoft SQL Server的独立 SELECT语句到DECLARE WITH RETURN光标和OPEN语句在IBM DB2。
表格 74。 从Microsoft SQL Server到IBM DB2结果集转换的例如
Microsoft SQL Server
IBM DB2
create procedure SalesOrder_Test
as
begin
select * from Customers
end
create procedure SalesOrder_Test ( )
LANGUAGE SQL
DYNAMIC RESULT SETS 1
begin
DECLARE cur1 CURSOR WITH RETURN
FOR select * from Customer s;
open cur1;
end