Determines how to handle the pagination query.

Syntax

Connect-SAPERP -PaginationScheme string

Possible Values

Data Type

cstr

Default Value

"Default"

Remarks

Here are the schemes : Default, Key, MaxRows.

• Default : Perform LIMIT and OFFSET to retrieve each page via the RFC function.
• Key : Paginate the query by the primary key and LIMIT(page size). If the table doesn’t support a valid primary key, the driver will throw an exception.
• MaxRows : Retrieve the all data once. It is useful and effective to guarantee ACID for the "small" tables.