You can translate the question and the replies:

Denodo & SQL Question - Temporary Tables & Updates

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reason for this approach is to accomodate the sub-totals I need to calculate. When I run thee script I am receiving an error. Can you please advise if creating temp tables and using update statements is allowed when creating a base view? If so can you please advise how to do so? If it is not allowed can you please advise how I go ahead and generate sub-totals within my report? Thank you
user
22-06-2018 14:18:38 -0400

1 Answer

Hi, Unfortunately, you cannot use UPDATE statements on temporary tables, so I believe that is the reason you are recieving an error. An explanation and overview of Temporary Tables can be found [here](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/temporary_tables/temporary_tables) if you wish to take a quick look. Regarding sub-totals, what I would do is create a base view with the subtotals and other fields first. Then I would make a Selection view on top of that first base view, with the 'totals' as an additional calculated field. For reporting, I would use that '2nd' base view with the 'totals' calculated. Hope this helps!
Denodo Team
25-06-2018 11:58:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here