<<

Contents

Search

>>

 

JDBC_SET_ISOLATION

 

 

Function

 

 

Syntax:

JDBC_SET_ISOLATION(<File Number>,<Mode>) or

JDBC_SET_ISOLATION(<Name of Index File>,<Mode>)

 

<File Number>

= <NUM-EXPRESSION>

<Name of Index File>

= <INDEX FILE NAME>

<Mode>

= <NUM-EXPRESSION>

 

 

Meaning:

Defines the isolation mode. The isolation mode applies to all tables of the database which contains the Index File or which has been opened with <File Number>.

 

JDBC_SET_ISOLATION returns the result 0 if no error occurred, otherwise –1. 

 

If an error occurs, the variable OK contains the error number and the function JDBC_GET_LAST_ERROR$ returns the error text.

 

Parameter:

File Number

Number of JDBC database

 

Name of Index File

Name of Index File

 

Mode

Isolation mode:

1: READ_UNCOMMITTED (no Isolation mode)

2: READ_COMMITTED (no "Dirty Reads" possible)

3: REPEATABLE_READ (no "Dirty Reads",  no "Nonrepeatable Reads")

4: SERIALIZABLE (Maximum Isolation mode)

otherwise: Default mode of database (mostly READ_COMMITTED)

 

Sample:

H% = JDBC_SET_ISOLATION(SALES,2)

IF H% = -1

THEN ERRORMES = JDBC_GET_LAST_ERROR$

ENDIF

 

See also:

JDBC_SET_CONCURRENCY

JDBC_DRIVER

JDBC_DATABASE

JDBC_TABLE

JDBC_USERID

JDBC_PASSWORD

JDBC_GET_DATABASE_NAME$