Cognos date time prompt value format in Native SQL

Technote (troubleshooting)


Problem(Abstract)

How to define the SQL syntax for the Cognos date time prompt function of the IBM Tivoli Netcool Performance Manager for Wireless?

Cause

The wrong syntax is as following and this causes the above error screen to be shown.

SQL syntax to_date(#prompt('pt_start')#,'MON DD, YYYY HH:MI AM') and "HSIA_CELL_TAB_VIEW"."TSTAMP"<=to_date(#prompt('pt_end')#,'MON DD, YYYY HH:MI AM')

Resolving the problem

The correct syntax is as shown below:-

SQL syntax to_date#sq(prompt('pt_start'),'MON DD, YYYY HH:MI AM')# and "HSIA_CELL_TAB_VIEW"."TSTAMP"<=to_date#sq(prompt('pt_end'),'MON DD, YYYY HH:MI AM')#


Please refer to the following link for tips/correct syntax for the SQL prompt value:-
https://www.ibm.com/developerworks/mydeveloperworks/blogs/cdd16df5-7bb8-4ef1-bcb9-cefb1dd40581/entry/tnpm_wireless_component_tips_for_building_tcr_reports?lang=en

Product Alias/Synonym

TNPMW

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Netcool Performance Manager for Wireless
Tech Packs

Software version:

1.2.1, 1.3

Operating system(s):

AIX, Linux, Solaris

Software edition:

All Editions

Reference #:

1592126

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation