IBM i Access for Windows ODBC performance

See any of the following IBM® i Access ODBC performance topics.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.

Performance-tuning IBM i Access for Windows ODBC
A key consideration for DB2® for i Access ODBC application developers is achieving maximum performance from client/server applications.
Performance considerations of common end-user tools
Several tools can help tune your IBM i Access ODBC driver environment.
SQL performance
Good application design includes the efficient use of machine resources. In the IBM i Access ODBC environment, to run in a manner that is acceptable to the end user, an application program must be efficient in operation, and must run with adequate response time.
ODBC support for multiple row statements
DB2 for IBM i and ODBC supports multiple row operations on INSERT, UPDATE, DELETE, and MERGE statements using the technique described below. This example shows how to use the multiple row INSERT statement in ODBC to insert multiple rows into a DB2 for i table.
Catalog functions
Catalog functions return information about the DB2 for i database objects with which you are working.
Exit programs
There are requirements when calling an IBM i Access ODBC exit program.
SQL and External procedures
SQL and external procedures are supported on IBM i for database access.

Parent topic: IBM i Access ODBC