topic Command in script to set schema oracle in QlikView

Command in script to set schema oracle

fkeuroglian — Wed, 25 Nov 2020 16:16:04 GMT

Hi expert!

I have a case that i have if i want to access and do a query to a ORACLE DATABASE I have to asociate the schema to every sql select

for example:

I have to put before the table the schema or user as i show here:

SQL Select * from SCHEMA.TABLE

is there any way to do this alter in qlikview script and avoid put the schema or user before each table in the sql select?

ALTER SESSION SET CURRENT_SCHEMA = BTWEB;

thanks a lot

Fernando K.

elyM — Wed, 08 Jun 2016 22:52:48 GMT

Hi Fernando,

you can try to pass your Oracle instruction using reserved word SQL.

SQL ALTER SESSION SET CURRENT_SCHEMA = BTWEB;

Usually I can send all DML instruction using SQL prefix.

SQL UPDATE TABLE....;
SQL DELETE FROM TABLE...;

I have tested SQL ALTERSESSION on our Oracle instances and it work correctly.

Regards,

Ely