IBM Support

Prompt macro works as Cognos SQL but not with Pass-through SQL

Troubleshooting


Problem

In Framework manager prompt macro works with following query for Cognos SQL but not with Pass-through SQL. Select * from [gosales].ORDER_DETAILS where ORDER_DATE = #prompt('TestDate', 'date')#

Symptom

n/a

Cause

The above syntax is Incorrect for pass-though SQL. For differences between Cognos and Pass-though SQL, refer to Technote 1341127 (link below)

Resolving The Problem

This is the correct syntax to use:

Select * from GOSL.dbo.ORDER_HEADER
Where ORDER_DATE = {ts # sq(prompt('TestDate', 'datetime') )# }

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Framework Manager","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;10.2.1;10.2.2","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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;10.2.1;10.2.2","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1027720

Document Information

Modified date:
15 June 2018

UID

swg21341148