Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    Unanswered: DB2 Monthname function problem

    I tried to test 'MONTHNAME' function using

    db2 "SELECT MONTHNAME( '2006-01-02' ) FROM SYSIBM.SYSDUMMY1"

    then the error message showed:

    SQL0443N Routine "SYSFUN.MONTHNAME" (specific name "MONTHNAME3") has returned an error SQLSTATE with diagnostic text "SYSFUN:03". SQLSTATE=38552

    Does anyone know what's wrong with my command?
    thx in advance
    PoHN
    Last edited by pohnpohnpohn; 08-02-06 at 02:58.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    the error is because of : Arithmetic overflow or underflow
    why you are using long_varchar??

    either use simply varchar or
    db2 values(monthname('2006-08-08'))

    Rahul Singh

  3. #3
    Join Date
    Aug 2006
    Posts
    3
    oh.. sorry i posted the worng command i used monthname('2006-01-02')

    i've just tried db2 "values(monthname('2006-08-08'))" but it still didn't work.
    it still shows the same error..

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    sysfun

    whenever I have problems with sysfun functions I try
    db2updv8 -d xxxx
    db2 bind /sqllib/bnd/db2schema.bnd grant public blocking all
    in 99,99% of these case, the problem is resolved.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Aug 2006
    Posts
    3
    it still doesn't work...
    is it because of my environment problem?

Posting Permissions

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