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:
Where dbname is the name of your IBM i database.UPDATE CLI CFG FOR SECTION dbname USING CURSORTYPES 1
- Edit the db2cli.ini file using this syntax:
CURSORTYPES = 1