Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    22

    Question Unanswered: Instance owner got SQL0440N error

    database level is: DB2 v9.1.300.257
    operating system is windows 2003(32bit)

    Account er1adm is instance owner, but when issued the following command, got SQL0440N error. Please advise.

    C:\Documents and Settings\er1adm>db2 values( RTRIM( CURRENT SERVER ) )
    SQL0440N No authorized routine named "RTRIM" of type "FUNCTION" having
    compatible arguments was found. SQLSTATE=42884
    **************************************
    Make progress everyday
    Mail: hoo.jimmy@gmail.com
    **************************************

  2. #2
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by huyuhui
    database level is: DB2 v9.1.300.257
    operating system is windows 2003(32bit)

    Account er1adm is instance owner, but when issued the following command, got SQL0440N error. Please advise.

    C:\Documents and Settings\er1adm>db2 values( RTRIM( CURRENT SERVER ) )
    SQL0440N No authorized routine named "RTRIM" of type "FUNCTION" having
    compatible arguments was found. SQLSTATE=42884
    just as the message said, there is no such function RTRIM() that takes a datatype same as CURRENT SERVER .

    you need check sql ref to see whether there is a RTRIM built-in function(I assume you are looking for the BIF one), and what's the argument type it expects

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by nidm
    just as the message said, there is no such function RTRIM() that takes a datatype same as CURRENT SERVER .

    you need check sql ref to see whether there is a RTRIM built-in function(I assume you are looking for the BIF one), and what's the argument type it expects
    His statement runs fine on my DB2 for Windows system with 8.1 FP15.
    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
    Jul 2002
    Location
    ATL
    Posts
    170
    put that statement in double quotes and remove all the spaces in side the braces

Posting Permissions

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