SAP Knowledge Base Article - Preview

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

Symptom

  • 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

Read more...

Environment

SUM
SUM DMO Migration
DB2 LUW

Product

SAP ERP 6.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.