RE: Writing SQL statements directly in IMPROMPTU

Generally, no. After writing a basic Impromptu query/report, you can view the SQL generated by Impromptu and even change it. However, once you change the SQL, you can no longer go back to the GUI development environment.

There are no good (maybe none at all) third party literature/books on Cognos. Only what Cognos supplies.

-------------------------The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

RE: Writing SQL statements directly in IMPROMPTU

Impromptu provides a SQL window here you can directly enter SQL into the window. You can click the verify button to verify your SQL code before excution. If it checks out Impromptu will return your query results based on the SQL statements entered.

RE: Writing SQL statements directly in IMPROMPTU

thanks for the first answers on my question. Now it is a bit more tricky because a colleage wants to transfer an IMPROMPTU query in plain SQL. But there seem to be certain IMPROMPTU specific features that don't find their equivalent in SQL (e.g. xsum).

RE: Writing SQL statements directly in IMPROMPTU

ShadowThe IQD can be opened in Notepad or any text editor. It is merely the SQL that will be sent to the DB with a short header that contains connection information. AFAIK, it is the same SQL as that seen in the Magic SQL window of impromptu.

One cannot open the IQD in Impromptu so as to generate the IMR file (or other Cognos file type); for Impromptu-sourced IQDs, the TITLE line in the header will reveal the report source of the file and the DATASOURCETYPE should be the full path to the original source.

soi la, soi carré

RE: Writing SQL statements directly in IMPROMPTU

Thanks! I found the IMR file. The only problem remaining is when I am in the profile tab (Report/Querey/ Profile tab), I hit the [CTRL] + [ALT] + [SHIFT] and see no edit key to click. I am trying to see what the equivilant SQL statement is for Impromtu's XSUM.

RE: Writing SQL statements directly in IMPROMPTU

Hmm. Your suggestion sounds likely - I recall that this is a user permission set by the catalogue administrator. Either check with the administrator or create a new catalogue and try from scratch.I recall a Cognos KnowledgeBase article that suggested closing Impromptu, renaming the Impromptu.ini file before re-opening (a new .ini file is created)