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

Technote (troubleshooting)


Problem(Abstract)

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

Cognos Upgrade Central
Dynamic Report Updater

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.2, 10.2.1

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1632822

Modified date:

2013-03-29

Translate my page

Machine Translation

Content navigation