SQLCODE -420 adding user defined child relationship in CA RI Manager.

Document ID : KB000030059
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Using CA RI Manager adding a user defined RI child to a parent table fails with:


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

SQL error in PLAN PRI1xxxx in DBRM RIA$CMDC

 

Solution:

Check to make certain Alternate Catalog Mapping is disabled.  If ACM  ==> ON, this problem is corrected by turning ACM to OFF from the Main Menu.