Database Information - MySQL (Magic xpa 4.x)
The Database Information parameter in the Database Properties, Data Source Properties, Column Properties and Index Properties dialog boxes lets you supply database-dependent information that Magic xpa can pass to the underlying DBMS. The use of this parameter is optional.
Multiple keywords should be delimited by one or more spaces.
Some of the keywords may not require values to be specified. All of the keywords and their values must be specified in uppercase.
|
Keyword
|
Description
|
|
|
|
|
|
SQL_PHYSICAL_LOCKING=N
|
MySQL supports physical locking at the row level from version 8.0 while using physical transactions.
To use physical locking, add the flag: SQL_PHYSICAL_LOCKING=Y
When this flag is set to Y Magic xpa will use physical locking in physical transactions.
SELECT a, b
FROM tab1 FOR UPDATE NOWAIT
|
?
| | | |
