Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Posts
    42

    Unanswered: No authorized routine of type "FUNCTION"

    DB2 ESE
    what does this mean? what should i do?
    No authorized routine named "||" of type "FUNCTION" having
    compatible arguments was found.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    message

    can you indicate the command executed and the complete message ?
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Feb 2007
    Posts
    42
    YEAR(B.BDAY)-YEAR(A.BDAY)||'OLDER THAN' //the error appears here
    don't mind that my other statements maybe wrong

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't think you can concatenate numeric values. You must first cast them as char or varchar.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Feb 2007
    Posts
    42
    oic.. i think i forgot that rule! tnx a lot!

Posting Permissions

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