Earlier versions of Cognos recognized a date conversion function used in older versions of DB2/400, but that function is deprecated, and has been replaced with a more standard cast function.
UDA-SQL-0219 The function "cast_date" is being used for local processing but is not available as a built-in function
The cast_date function appears to have been a function used by in earlier versions of DB2/400. More recent versions (V5R4) include a more standard cast() function, so the older function is no longer supported.
DB2/400 V5R4 or higher
Resolving the problem
Modify the report to change:
cast([dataitem] as date)