When set to disabledatavalidation, the Data Provider for SAP does not validate the values present in the DATS, TIMS, and NUMC columns but instead exposes them as string.
Failure in specifying an optimum value for batch size may result in out of memory exceptions. Note that you should specify an optimum value for the batch size based on the physical memory of the computer and the number of rows in the SAP system. If batchsize is not specified, the default value of 10,000 is assumed for the batch size. For example, if you specify 'batchsize 100', the SELECT query retrieves 100 records only in each call to the SAP system. When set to batchsize, the execution of the SELECT statement causes multiple calls to be made to the SAP system, and in each call, only number of records are retrieved.
When the no_conversion option is not used, and if a field has a conversion exit defined then those fields in the table are exposed as. NET equivalent of the SAP data types, see Basic SAP Data Types. If the no_conversion option is not used, and if a field does not have a conversion exit defined then those fields in the table are exposed using the equivalent. If the no_conversion option is used then the fields in the table are exposed using the equivalent. You can specify the options as OPTION '', where = 'no_conversion' | 'batchsize ' | 'disabledatavalidation' = [ const | column_name [= | ! = | > | > = | ! > | = integer | real | string | ? | NULL | xml_element. = BETWEEN const AND const | expr LIKE const ] The supported conditions and expressions are: = predicate predicate | NOT predicate | ‘(‘ predicate ‘)’ | condition ] Notice that in several cases, the syntax is somewhat different from the base Transact-SQL syntax. NET Framework Data Provider for mySAP Business Suite. The following sections describe grammar specifications for implementing SELECT queries against the.