Error Messages (F)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

For Update

OpenLink's scrollable cursors do not implement "FOR UPDATE." However, OpenLink allows you to set your ISOLATION level. To proceed, take the following action:

1. Create a new file.

2. Insert the command that your database uses to set its isolation level. For example:

set isolation to dirty read

3. Save and exit your file.

4. Use vi or Notepad to open your server's Rules Book (oplrqb.ini). The Rules Book appears in the /bin sub-directory of your OpenLink server components installation.

3. Locate the [generic_xxxx] section, which corresponds to your OpenLink Database Agent. For example:

[generic_inf7]
Program = inf7_mv.exe
;CommandLine =
Environment = INFORMIX7
OpsysLogin = Yes
ReUse = always

4. Remove the semicolon (;) from CommandLine.

5. Pass "+initsql isolation_command_filename" to the CommandLine parameter. For example:

CommandLine = inf73sv.sql

6. Save your changes and exit the file.

7. Reinitialize or restart the Broker.

8. Test your connection.

Evidence

Code Sample
ODBC Client Trace
Database Agent Version String
DBMS Version