Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I am running below script in Qlikview it is giving correct count ie 1049873:
SQL SELECT count(1)
FROM DataSchema.Data_v
WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND business_date <= TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')
Where as if I run all the columns selections then it is giving only just 2500 records
SQL SELECT *
FROM DataSchema.Data_v
WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND business_date <= TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')
Is there any specific settings i need to provide to achieve this?.
I am using licenced version of qlikview and ODBC connector.
Thanks
Dasu.G
How do you count rows in resulting tables?
With the first query you just count the rows, the second query may "hide" rows if values are equal. Is this possible in your tables?
Ticket number and business date columns are different always. complete record set never matches at all..
Hi Guys,
I found below logs from ODBC Driver?. Is there any thing to do with ODBC (We are using Composite 6.2 ODBC driver).
0002DED44EB9471 2dd74-2dd78 | EXIT SQLSetStmtAttrW with return code -1 (SQL_ERROR) | |
SQLHSTMT 0x00000000003EE260 | ||
SQLINTEGER 4 <SQL_ATTR_ASYNC_ENABLE> | ||
SQLPOINTER 1 <SQL_ASYNC_ENABLE_ON> | ||
SQLINTEGER -6 |
It sounds like your driver (or DB) is set to return a max of 2500 rows. Is that SalesForce you are hitting in the background?
-Rob
Hi Rob,
I ran other queries and found that those are retrieving more than 2500 rows that means neither db nor database has this record limit configured. Do you have any thoughts how to proceed on these kind of situations?.
Thanks
Dasu.G
We found some issues in the composite ODBC driver . There is no issue in QV.