When creating a procedure, the comments between CREATE and BEGIN disappeared.
Only comment between Create and Begin disappeared:
CREATE PROCEDURE "ADMINISTRATOR"."BONUS_INCREASE3" (
IN "P_BONUSFACTOR" DECIMAL(3, 2),
IN "P_BONUSMAXSUMFORDEPT" DECIMAL(9, 2),
OUT "P_DEPTSWITHOUTNEWBONUSES" VARCHAR(255),
OUT "P_COUNTDEPTSVIEWED" INTEGER,
OUT "P_COUNTDEPTSBONUSCHANGED" INTEGER,
OUT "P_ERRORMSG" VARCHAR(255) )
SPECIFIC "BONUS_INCREASE3"
DYNAMIC RESULT SETS 1
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
OLD SAVEPOINT LEVEL
/****************************************************************************************************************
-- 模块名称:集团业务成员帐单月中间层
-- 模块标识:DWPMID.P_MIDTBL_GROUP_USER_BILL_MON
-- 功能描述:集团业务成员帐单月中间层
-- 输 入 表:dwpmid.tp_group_user_bill_mon
-- 输 出 表:
-- 输入参数:I_MONTH 统计日期
-- 创建日期:2012-05-03
-- 创 建 人:-xujc
****************************************************************************************************************/
BEGIN
-- -------------------------------------------------------------------------------------
-- Routine type: SQL stored procedure
-- Routine name: BONUS_INCREASE3
--
-- Purpose: This procedure takes in a multiplier value that is used to update
-- employee bonus values. The employee bonus updates are done department
-- by department. Updated employee bonus values are only committed if the
-- sum of the bonuses for a department does not exceed the threshold amount
-- specified by another input parameter. A result is returned listing, by
-- department, employee number
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center