IBM Support

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

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)

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21632822