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 for Me (Login required).

Search for additional results

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