Update SQL With Prompt Input

[MikeLanglois]

Hey all,

I have some SQL input on a query that has:

WHERE
SD.YEAR_NUM = 2016

and I was wondering if its possible to have this be updated with values from a prompt? The prompt will be a selection of years.

Also the script has:

SD.MONTH_NUM_OF_YEAR in (4,5,6)

would it be possible to have the 4,5,6 be updated based on the multiple choices on a prompt?

Is it the usual ?prompt? syntax used in Cognos filters, or is it something else?

Many thanks

[RubenvdLinden]

You can add prompt macros to your SQL statement, e.g.

SD_YEARNUM = #prompt('year';'integer')#

Use promptmany for multiple values.