Results 1 to 2 of 2

Thread: DB2 error

  1. #1
    Join Date
    Sep 2007
    Posts
    56

    Unanswered: DB2 error

    DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: FORMAT_NAME;FUNCTION

    I am getting this db2 error while running a sql query via java what i came to know is that format_name function is not present in db2 but when running this select query
    select format_name('name1','name2','name3')marked_by from SYSIBM.SYSDUMMY1
    i got a correct result.
    not sure why this is showing up need some help in understanding this

    thanks
    Donraja_ht

  2. #2
    Join Date
    Nov 2010
    Posts
    21
    the error means that:

    No routine was found with the specified name and compatible arguments.

    Please check whether you are providing the names of routines are correct along with arguments.

    --Harsh

Posting Permissions

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