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.