DB2 FOR LUW / DB2FORLUW / B10 - DB2

Can not create stored procedures with the same name, even if
their signatures are different when using SQL_COMPAT ='NPS'.

The following script reproduces the error:

--#SET TERMINATOR !
SET SQL_COMPAT='NPS'!
CALL SET_ROUTINE_OPTS('REOPT ONCE DYNAMICRULES RUN VALIDATE
RUN')!

CREATE PROCEDURE tst_2Sig(DATE)
RETURNS INTEGER
LANGUAGE NZPLSQL
AS BEGIN_PROC
DECLARE
pCOB ALIAS FOR $1;

vRC INTEGER;
BEGIN

vRC := 0;
return vRC;
end;
END_PROC
!

CREATE PROCEDURE tst_2Sig(DATE, INTEGER)
RETURNS INTEGER
LANGUAGE NZPLSQL
AS BEGIN_PROC
DECLARE
pCOB ALIAS FOR $1;
pID_FS ALIAS FOR $2;

vRC INTEGER;
BEGIN

vRC := 0;
return vRC;
end;
END_PROC
!

This will result in a SQL0456N error

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5 fixpack 1 or later                       *
****************************************************************

keiner bekannt / siehe Local-Fix

See Error Description

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

12.03.2019
04.07.2019
04.11.2019