Troubleshooting
Problem
Earlier versions of Cognos recognized a date conversion function used against DB2 and SQL Server. That function is deprecated and has been replaced with the standard cast() function.
Symptom
UDA-SQL-0219 The function "cast_date" is being used for local processing but is not available as a built-in function.
Cause
The cast_date function was used in earlier versions. More recent versions include the standard cast() function. The old function cast_date() is no longer supported.
Environment
DB2 and SQL Server data sources.
Resolving The Problem
Modify the calculation or filter definition in the FM model or Report Studio report to change:
cast_date([dataitem])
to
cast([dataitem] as date)
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21632822