返回影响行数

#SYNC 10;

SET SCHEMA TYCOON_SP;

SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","TYCOON_DB2_1";

CREATE PROCEDURE DB2INST1.SP_UPP_INDEX123
 (

 IN "IN_ID" INTEGER
  IN "IN_SCHOOL_ID" INTEGER,
  IN "IN_CREATE_DATE" DATE,
  OUT "ROWCOUNT" INTEGER
 )
  LANGUAGE SQL
  NOT DETERMINISTIC
  CALLED ON NULL INPUT
  EXTERNAL ACTION
  OLD SAVEPOINT LEVEL
  MODIFIES SQL DATA
  INHERIT SPECIAL REGISTERS
  p1 : begin
           
    /* 对P01_Tod_Index更新一条结账记录*/    
    Update UP_TABLE_1

     set SCHOOL_ID =IN_SCHOOL_ID,CREATE_DATE = IN_CREATE_DATE
    where ID = IN_ID ;
    
    /*返回影响行数*/
    GET DIAGNOSTICS RowCount = ROW_COUNT;

end p1;

#SYNC 20;

转载于:https://www.cnblogs.com/northeastTycoon/archive/2012/11/29/2794672.html