DB2 - Problem description
| Problem IC96705 | Status: Closed |
IMPLEMENTATION FIELD IN SYSCAT.ROUTINES FOR A SOURCED FUNCTION MISSING MODULE NAME | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
The following examples display the behavior. Please note that
this APAR was incorrectly raised and included in DB2 10.1
Fixpack 4 and is being cancelled through IT03012
CREATE OR REPLACE FUNCTION R1.F1()
SPECIFIC F1
RETURNS INT
RETURN 1
DB20000I The SQL command completed successfully.
CREATE OR REPLACE FUNCTION R1.F2 ( )
RETURNS INTEGER
SOURCE R1.F1()
DB20000I The SQL command completed successfully.
CREATE OR REPLACE MODULE R1.M1
DB20000I The SQL command completed successfully.
ALTER MODULE R1.M1
PUBLISH FUNCTION F1()
SPECIFIC F1
RETURNS INT
RETURN 1
DB20000I The SQL command completed successfully.
CREATE OR REPLACE FUNCTION R1.F2M ( )
RETURNS INTEGER
SOURCE R1.M1.F1()
DB20000I The SQL command completed successfully.
SELECT SUBSTR(ROUTINESCHEMA,1,5), SUBSTR(ROUTINENAME,1,5),
SUBSTR(IMPLEMENTATION,1,10) FROM SYSCAT.ROUTINES WHERE
ROUTINESCHEMA = 'R1' AND ROUTINENAME IN ('F2', 'F2M')
1 2 3
----- ----- ----------
R1 F2 R1.F1 ()
R1 F2M R1.F1 ()
2 record(s) selected.
The second row should read R1.M1.F1() for the IMPLEMENTATION. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First changed in DB2 10.1 Fixpack 4 but this change is being * * rolled back to previous behavior via APAR IT03012 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
| Solution | |
First changed in DB2 10.1 Fixpack 4 but this change is being rolled back to previous behavior via APAR IT03012 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.10.2013 08.07.2014 09.07.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.4 |
|