2704813 - DB2 LUW SQL0440N CREATE VIEW with FUNCTION SUM DMO Migration

• DB2 LUW error
     SQL0440N No authorized routine named "<view_name>" of type "FUNCTION" having compatible arguments was found.
  
  
• SUM error
     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     Phase: EU_CLONE_CRE_SHDVIEW
     SR3LOAD IMPORT ERRORS
     Find the detailed log in SHDVIEWS_00003_IMP.LOG
     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     A1 ETSK 007 Starting create for object "DEMOCDSUPPER" of type "CDS view" YYYYMMDD24MMS
     SA1 EDB6 000 DROP statement returned DS_DBOBJECTUNKNOWN
     A1 EDB6 017 DROP VIEW "DEMOCDSUPPER"
     A1 EDB6 017
     A1 EDB6 009 DEMOCDSUPPER dropped YYYYMMDD24MMS
     A1EEIMP 008 Task failed with error: (DB6) DDL statement failed with SQL error!
     A1EEIMP 008 (CREATE VIEW "DEMOCDSUPPER" AS
     A1EEIMP 008 SELECT "T100"."SPRSL", "T100"."ARBGB", "T100"."MSGNR", "T100"."TEXT",
     A1EEIMP 008 SAPTOOLS.UPPER( "T100"."TEXT" ) AS "UPPER_TEXT" FROM "T100" "T100"
     A1EEIMP 008 )
     A1EEIMP 008 (SQL error -440)
     A1EEIMP 008 Error message returned by DbSl:
     A1EEIMP 008 SQL0440 [TRUNCATED]
  
  
• DB2 command line error from just the select portion of the CREATE VIEW . . .
     db2 "SELECT ""T100"".""SPRSL"", ""T100"".""ARBGB"", ""T100"".""MSGNR"", ""T100"".""TEXT"", SAPTOOLS.UPPER( ""T100"".""TEXT"" ) AS ""UPPER_TEXT"" FROM ""SAPDED"".""T100"" ""T100"""
        SQL0440N  No authorized routine named "UPPER" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884
     db2 "SELECT SAPTOOLS.LOWER( 'CHAR1') FROM SYSIBM.SYSDUMMY1"
        SQL0440N  No authorized routine named "LOWER" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884

SUM
SUM DMO Migration
DB2 LUW

DB6 SUM MDO SQL0440 SQL0440N , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem