DROP PROCEDURE CDI.PRC_CIM_IDENTITY_FIND@
CREATE PROCEDURE CDI.PRC_CIM_IDENTITY_FIND(
IN I_ID_NUM VARCHAR(21), --oracle I_ID_NUM in VARCHAR(21) DB2也有in out
IN I_CERT_TYPE VARCHAR(5),
IN I_NUM_TYPE INTEGER,
OUT O_RESPNOSE_TYPE VARCHAR(1),
OUT O_RESPNOSE_CODE VARCHAR(6)
)
DYNAMIC RESULT SETS 2
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
MODIFIES SQL DATA
INHERIT SPECIAL REGISTERS
BEGIN
DECLARE V_ID_NUM VARCHAR (21); --oracle:在is/as中对变量声明且没有DECLARE
--查询号码(传入数据预处理)
DECLARE V_CERT_TYPE VARCHAR (8); --查询证件类型(传入数据预处理)
DECLARE V_NUM_TYPE INTEGER; --查询类型(传入数据预处理)1:查询号码是卡号;2:查询号码是证件号码;--3:查询号码是客