DB2 Monthname function problem

pohnpohnpohn · #1 (**permalink**) 08-01-06, 22:04

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

rahul_s80 · #2 (**permalink**) 08-02-06, 01:04

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

pohnpohnpohn · #3 (**permalink**) 08-02-06, 02:00

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..

guyprzytula · #4 (**permalink**) 08-02-06, 02:21

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.

pohnpohnpohn · #5 (**permalink**) 08-02-06, 02:55

it still doesn't work...
is it because of my environment problem?

Internet Services

Web Development

Digital Marketing

Consumer Tech