Error in ODSMaxRows=10000000

[#1]

Hi all,

I have a problem I encounter in connection QvSAPDSOConnector.dll is a condition that has the connection string that allows read-only 10 million

record, this is the function that coast in the connection string: ODSMaxRows = 10000000. And when I change or exclude this value it returns me error.

And put it in a condition Where in the script, to decrease the size of data read so I can draw for smaller pieces of 10 million records,

but when I put Where the function, it returns me error in reading too.

Below is the script I'm using:

CUSTOM CONNECT TO "Provider=QvSAPDSOConnector.dll;ASHOST=sp19in;SYSNR=12;CLIENT=302;ODSMaxRows=10000000;XUserId=DLdMGadNPDbSGbVMJLKB;XPassword=eXHEAadNNDdeWWFGSZMIF;";


[0SD_O06]:
Load *;
SQL Select (NoKey)
0BILL_CAT,
0BILL_DATE,
from 0SD_O06
WHERE (0BILL_CAT) = 'A';
STORE [0SD_O06] INTO $(vEXTRATOR)0SD_O06_PROD_01.QVD;
Drop table [IC_PNL_04/QIC_PNL_04];

Any idea? Thnaks,

[Gysbert_Wassenaar]

Have you read this discussion already?