User`s guide

7 Functions — Alphabetical List
7-218
Database Connection Objects
The allowable values for property and value for a database connection object appear in
the following table.
Property Value Description
'on' Database data is written and
automatically committed when you run
fastinsert, insert, or exec. You
cannot use rollback to reverse this
process.
'AutoCommit'
'off' Database data is not committed
automatically when you run
fastinsert, insert, or update.
Use rollback to reverse this process.
When you are sure that your data is
correct, use the commit function to
commit it to the database.
0 Not read only; that is, writable'ReadOnly'
1 Read only
'TransactionIsolation' positive
integer
Current transaction isolation level
Note: For some databases, if you insert data and then close the database connection
without committing the data to the database, the data gets committed automatically.
Your database administrator can tell you whether your database behaves this way.
Cursor Objects
The allowable property and value for a cursor object appear in the following table.
Property Value Description
'RowLimit' positive integer Sets the RowLimit for fetch. Specify this
property instead of passing RowLimit as
an argument to the fetch function. When
you define RowLimit for fetch by using