I am working on a project that uses the Linux DB2 UDB engine to talk to an AS/400. We are using the CLI in C code to handle the DB interfaces. However, when we set up a cursor of SQL_CURSOR_KEYSET_DRIVEN, we get a CLI0005W/SQLSTATE 01S02 - Option value changed message. It then reverts to FORWARD_ONLY which prevents us from using anything but SQL_FETCH_NEXT while going through the database.

Does anyone have any clues or help on this?

Thanks, Jason