Forum

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