Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sql ansi problem in script

Dear all

i need your help!

i have a simple  sql query  that return about 250.000 records if i run via  sqldeveloper. (oracle db )

The same query return 16.000 record if i run via qlikview.

I don't find the problem.

The only peculiarity is the sql ansi sintax for join .. .

See attached file for query detail .

Best Regards and thank's for your help

Riccardo

1 Reply
mov
Esteemed Contributor III

Re: Sql ansi problem in script

Riccardo,

If I had a chance to test it, I would do it by disabling lines in the WHERE clause, hence narrowing down the problem.  And, the lines I'd test first are these:

   and trunc(pll.last_update_date) between to_date('11/10/2011','dd/mm/yyyy') and sysdate+1 

   and tr.po_line_Location_id ( + ) = pll.line_location_id

   AND tr.transaction_type ( + ) = 'DELIVER'

Because not sure how the bold items above work there.

Regards,

Michael

Community Browser