<<

Contents

Search

>>

 

JDBC_MODE

 

 

Instruction

 

 

Syntax:

JDBC_MODE[(<Name of Index File>)] = <Isolation> , <Concurrency> , <Cursortype>

 

<Name of Index File>

= <INDEXFILE>

<Isolation>

= <NUM-EXPRESSION>

<Concurreny>

= <NUM- EXPRESSION >

<Cursortype>

= <NUM- EXPRESSION >

 

 

Meaning:

Specifies the isolation mode, the concurrency mode and the cursortype of the Index File in the SQL database if the File Type of the Index File is J (JDBC).

 

The specified parameters apply only when the Index File is opened. If the Index File is already open, the parameters only apply after the Index File has been closed and opened again.

 

If no Index File is specified, the driver applies to all Index Files of the program.

 

Parameter:

Name of Index File

Name of Index File

 

Isolation

Isolation mode:

1 = READ_UNCOMMITTED

2 = READ_COMMITTED

3 = REPEATABLE_READ

4 = SERIALIZABLE

otherwise = READ_COMMITTED

 

Concurrency

Concurrency:

0 = CONCUR_READ_ONLY

otherwise = CONCUR_UPDATABLE

                             

Cursortype

Cursortype:

1 = TYPE_FORWARD_ONLY

2 = TYPE_SCROLL_INSENSITIVE
3 = TYPE_SCROLL_SENSITIVE

otherwise = TYPE_FORWARD_ONLY

 

Sample:

JDBC_MODE(CUSTOMER) = 2,1,2

 

See also:

JDBC_DRIVER

JDBC_DATABASE

JDBC_TABLE

JDBC_USERID

JDBC_PASSWORD

GET_DATABASE_NAME$