IBM Support

UDA-SQL-0219 The function "cast_date" is being used for local processing

Technote (troubleshooting)


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.


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 was used in earlier versions. More recent versions include the standard cast() function. The old function cast_date() is no longer supported.


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([dataitem] as date)

Related information

Cognos Upgrade Central
Dynamic Report Updater

Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 10.2, 10.2.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1632822

Modified date: 29 March 2013

Translate this page: