Hi!
After migration from 8.4 we have a trouble with running reports. These reports have query select from database directly.
For example:
SELECT to_char(#prompt('SelectedDate')#, 'dd.mm.yyyy' ) FROM TABLE(function)
But query generating error: SQL0153N The statement does not include a required column list.
When I wrote alias for calculation, then error was gone. Unfortunately, I can't change query in all reports.
Then I changed SQL syntax from SQL Cognos to Pass-Through. It was helped! Unfortunately, I can't change query options in all reports again.
Ok, I think that it may be possible tune in datasource - make SQL syntax Pass-Through by default.
How you think? It is possible these "global" change?
Thank you!