Editing the SQL

If you want to edit the SQL of a model query subject, you must copy the SQL for the model query subject from the Query Information tab and paste it into a new data source query subject. You can also convert the model query subject into a data source query subject Do not edit the SQL if you want the model query subject to reference multiple data sources. For more information, see Converting model query subjects into data source query subjects.

Changing the alias of a column regenerates the query item that represents that column. Any modifications that you made to the query item are not retained because IBM Cognos Framework Manager considers it a new query item.

You can add comments to the SQL by using /* before the comment and */ at the end.

Here is an example:

select country /* this is a multiline comment
another line 
another line */