Would it be possible to get additional code formatter options added to handle Cognos Passthrough SQL?
When using passthrough SQL in Cognos you can specify prompt values with the use of #prompt or #promptmany.
However Toad doesn’t like this and when you try to format code that has this type of logic in there it sees it as bad syntax and wil not then format the code.
A couple of examples are below:
#promptmany (‘CostCenter_Param’,‘string’, ’ ', ‘and ACCOUNT_BALANCE_SUMMARIES.BUSINESS_UNIT IN (’ , ‘’ , ‘)’ )#
These prompts can be placed anywhere in the SQL code to provide user generated values.
I appreciate any feedback provided.