How can I get scrollable cursor support enabled from DB2 for Linux, UNIX, and Windows to the IBM i platform?

On the DB2® for Linux, UNIX, and Windows V8 client, you must be using FixPak 4, or later. You can also use a client that runs a later version of DB2 for LUW that provides scrollable cursor support to the IBM® i platform.

If you are using FixPak 4 on a client that runs DB2 for Linux, UNIX, and Windows V8, you must perform one of the following actions.

Note: If you are using a later version of the DB2 for LUW client that provides the scrollable cursor support to the IBM i platform, you do not need to perform these actions.
  • Issue this command:
    UPDATE CLI CFG FOR SECTION dbname USING CURSORTYPES 1
    Where dbname is the name of your IBM i database.
  • Edit the db2cli.ini file using this syntax:
    CURSORTYPES = 1