[Info-ingres] report writer question - query fails in RW but OK in sql

[Karl Schendel]

> On Feb 18, 2016, at 9:24 AM, abc at google.com wrote:
> 
> It's been many years since I used Report Writer, but I don't believe you're allowed to create tables within it.   You need to write a select statement to get the data.  You can do the create stuff using a script outside report writer to create a temp table.  Then query the temp table in the Report Writer script.
> 


I would have thought that create table was allowed in a .SETUP section.
It's been a long time for me as well, though, and I'm not in a position right
now to experiment.

Maybe try declare global temporary table instead of create table?

Karl