Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Select INTO temporary table(Can see result of a query with temp table in preview but not when run as PDF)
Select INTO temporary table [message #1782310] Wed, 21 February 2018 15:53 Go to next message
Martin Fafard is currently offline Martin FafardFriend
Messages: 3
Registered: June 2012
Junior Member


Hi

This is a simplified presentation of a query that I need for a report. I can preview data but nothing when run as PDF. My question: BIRT can "manage" this temporary table ?

With tableA as
(Select field1,field2, field3 from tableB)

select
tableA.field1, tableA.field2, tableA.field3
INTO TEMPORARY tabletemp

from tableX
left join tableA ON fieldX = field1
;

UPDATE tabletemp SET field3 =
(SELECT ...
FROM ...
WHERE ...)
;

--final compute
select min (field1), max ...
from tabletemp;

drop table tabletemp
Re: Select INTO temporary table [message #1782404 is a reply to message #1782310] Thu, 22 February 2018 17:40 Go to previous message
Martin Fafard is currently offline Martin FafardFriend
Messages: 3
Registered: June 2012
Junior Member
Ok... I needed Data Cube... Thanks
Previous Topic:Suppress error if a data source isn't available
Next Topic:Performance issues with db query being executed several times
Goto Forum:
  


Current Time: Thu Jun 21 18:30:07 GMT 2018

Powered by FUDForum. Page generated in 0.02164 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top