Please help - My JMP script gives me less data rows than I directly run the query in PL/SQL
Oct 16, 2017 8:54 PM(1323 views)
I am new on JMP and today I encountered a issue:
I am working with a Oracle database, and I am using PL/SQL client to run my queries. Within PL/SQL, my query can return 1435 rows, while the exact query in a JMP script can only give me 1000 rows. I am guessing that this is related to the JMP block sampling size, but I am not sure, and I don't know where to change this size.
@zhipeng_wang1 : If you are executing the exact same query in JMP , I can't think of a reason why JMP would return less rows than your SQL environment. Can you do this - please provide a screenshot of your query that you are running in both environments and the script that you are using in JMP ?
Thanks for reply! Sorry I cannot post screenshots here due to our IT policy constraints.
I tried several times today and the results are similar: PL/SQL client always give me more rows of data. However, I noticed that JMP script always gives rows in increment of 1000, such as 1000, 3000, 6000, etc., while the PL/SQL client always give rows a little bit more, such as 1435, 3428, 6274, in the previous trials.
I don't know why is this but seems JMP is always fetching data in a block of 500 or 1000 rows. Could this be the reason for my issue?