(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 22018
Microsoft OLE DB Provider for SQL Server: [22018] Invalid character value for cast specification

I get this error when using MODIFY FILE on a MS SQL Server DB. I am matching on a unique Identifier column, "ENTITYID".

The code is something like this:

MODIFY FILE CRMLISTMEMBER
FIXFORM FROM HOLDC1

MATCH LISTNAME ENTITYID
ON MATCH UPDATE LISTNAMESORT BUSINESSUNITNAME USERID
ON NOMATCH INCLUDE

DATA ON HOLDC1
END

Even though the error is triggered, I think the MODIFY works.

Anyone have any ideas why I get the error?

Thanks,

Francis.

Solved!

For some rows in the hold file, the unique identifier column, ENTITYID was null and this triggered the error.