I have a query that works perfectly in oracle sql developer. But in qlikview i can only have one call per select statement to from_tz where I want to have multiple calls.
ie the follwoing works:
load *;
sql select *,
from_tz(cast(END_TIME_GMT as TIMESTAMP), 'GMT') at time zone TIME_ZONE_REGION_1 as END_TIME_LOCAL
from FACT_TABLE;
and
load *;
sql select *,
from_tz(cast(START_TIME_GMT as TIMESTAMP), 'GMT') at time zone TIME_ZONE_REGION_1 as START_TIME_LOCAL
from FACT_TABLE;
but the following does not. It gives the error "execution of script failed":
load *;
sql select *,
from_tz(cast(END_TIME_GMT as TIMESTAMP), 'GMT') at time zone TIME_ZONE_REGION_1 as END_TIME_LOCAL ,
from_tz(cast(START_TIME_GMT as TIMESTAMP), 'GMT') at time zone TIME_ZONE_REGION_1 as START_TIME_LOCAL
from FACT_TABLE;
has anyone had any similar issues connecting to oracle dbs? We are using qv10 sr3 with oledb connection.
