Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I try to execute this query in QlikView but I get an 'Échec de lecture OLEDB' error :
PS : this query works on TOAD
select tt.*, d.aliasname
from (
SELECT
REPORT_TYPE,
REPORT_DATE,
TRANSAC_ID,
DEBITED_ACTOR_ID,
CREDIT_ACTOR_ID,
credit,
tab.ALIASNAME
FROM POS_REPORT_FINAL_1904 trans , DUMP_RETAILER_FINAL tab
WHERE
trans.debited_ACTOR_ID =tab.ACTORE_ID(+)
and report_type = 'TSR001'
AND function_id = 243
and debited_actor_id IN ('1018796','1080716')
AND OPER_STATE = 61
AND IERRORX = 0) tt, DUMP_RETAILER_FINAL d
where
credit_ACTOR_ID =d.ACTORE_ID(+);
Hello
Your query generaes two columns with the same name (ALIASNAME from the inside query and from table DUMP_RETAILER_FINAL. Toad renames the second column automatically, but Qlikview don't. You need to change the name of one of them.
Hello
Your query generaes two columns with the same name (ALIASNAME from the inside query and from table DUMP_RETAILER_FINAL. Toad renames the second column automatically, but Qlikview don't. You need to change the name of one of them.
try
FROM databasename.schemaname.POS_REPORT_FINAL_1904 trans , databasename.schemaname.DUMP_RETAILER_FINAL tab
Thanks Marcio. You are right.