Disable SELECT prefetching using i Access ODBC

Connection string

This IBM i Access ODBC driver connection string can be used for connections to AS/400.

Use this connection string to disable prefetching for SELECT statements.

Driver={IBM i Access ODBC Driver};System=mySystem;UID=myUser;PWD=myPassword;
PREFETCH=0;

Default behaviour is that prefetch is enabled (PREFETCH=1) which will increase performance for SELECT statements when accessing the initial rows.