Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Posts
    16

    Unanswered: SQL Function Error

    Hi All,

    I am getting the beow error when i try to execute this query

    db2 "select UPPER(REL_ALIAS) from sample.emp"

    SQL0440N No authorized routine named "UPPER" of type "FUNCTION" having
    compatible arguments was found. SQLSTATE=42884

    As the same query was runnig fine till yesterday.
    Your help will be appreciated.

    Thanks in Advance,
    Pravas

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It is UCASE not UPPER.

    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    According to the SQL Reference, either UCASE or UPPER should work.

    They both work on my 8.2 for Windows 32 bit FP11 .
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You are right, UPPER is valid. What data type is REL_ALIAS?

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •