Forum
3. Mai 2013 um 19:52 Uhr
#4303
Anonym
Inaktiv
Hi Klaus,
quite strange, because usually DB2 responds as follows:
SELECT NAME, DEGREE
FROM SYSIBM.SYSPLAN
WHERE DEGREE <> 1
DSNT408I SQLCODE = -420, ERROR:Â THE VALUE OF A STRING ARGUMENT WAS NOTÂ Â
      ACCEPTABLE TO THE DECFLOAT FUNCTION                  Â
DSNT418I SQLSTATEÂ Â = 22018 SQLSTATE RETURN CODEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
DSNT415I SQLERRPÂ Â = DSNXRNUM SQL PROCEDURE DETECTING ERRORÂ Â Â Â Â Â Â Â
DSNT416I SQLERRDÂ Â = -245Â 0Â 0Â -1Â 0Â 0 SQL DIAGNOSTIC INFORMATIONÂ Â Â
DSNT416I SQLERRDÂ Â = X'FFFFFF0B'Â X'00000000'Â X'00000000'Â X'FFFFFFFF'
      X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Reason:
When DB2 implicitly casts a character string or graphic string value to a numeric value, the target type is DECFLOAT(34) which is compatible with other numeric data types.
Would you please provide your DB2’s system variables as described in blog article https://ruban.de/1575/misc/sql-to-retrieve-db2-subsystem-information-update-for-db2-10-zos/.
regards
Gernot