Unable to read from Global Temporary table

swati_rastogi27 — Wed, 13 Jul 2016 07:09:25 GMT

Hi ,

I have a data view with complex joins, so instead of reading from view , I want to dump data into a global temporary table and read from it.

I used below statement to create the same:

CREATE GLOBAL TEMPORARY TABLE SCHEMA.V_COMPLEX_VIEW_GTT

ON COMMIT PRESERVE ROWS AS (

SELECT * FROM SCHEMA.V_COMPLEX_VIEW where 1=2

);

When I try to read from this table , I get an error stating , 'Driver not capable'

Please help

Re: Unable to read from Global Temporary table

swati_rastogi27 — Thu, 14 Jul 2016 11:23:59 GMT

Any clue anyone?