topic Re: How I can simulate one cursor inside other cursor in qlikview in QlikView

How I can simulate one cursor inside other cursor in qlikview

Mon, 24 Feb 2014 19:22:45 GMT

I'd like to run one sql and with the result use like parameters to execute another sql inside qlikview.

I could to do it by pl/sql but i'd like to do inside qlikview.

Eg.

cursor iniciar is select name from table A;

cursor acionar(nameB varchar2) is select salary tableB where name =nameB;

begin

for i in iniciar loop

for j in acionar(i.nameB ) loop

insert into c (salary) values (j.sal)

end loop;

end;

Re: How I can simulate one cursor inside other cursor in qlikview

maxgro — Mon, 24 Feb 2014 19:51:27 GMT

this is just an idea as now I haven't an Oracle db to check it; adapt to your question

tableA:

// replace inline load with select from Oracle

LOAD * INLINE [

nameB

];

// loop on rows of qlikview table (same as loop on Oracle outer table, first cursor)

for i = 1 to noofrows('tableA')

let vVar = fieldvalue('nameB',$(i));

trace $(vVar);

// read from Oracle inner table (cursor 2) filtering with row/colum of tableA

tableB:

load *;

SQL

select salary from tableBOracle where name = '$(vVar)';

next i

to insert in Oracle I think you have to set open database in read/write (script editor, tab settings), ask your oracle dba to grant, make a package or function or proc, ......, etc, etc........

Re: How to use PL/SQL package call in qlikivew script

but I personally would not do it

Re: How I can simulate one cursor inside other cursor in qlikview

Wed, 26 Feb 2014 17:01:37 GMT

Thank U so much.