Database Information - PostgreSQL
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
|
|
|
|
|
|
LimitLinkToSingleFetch=Y
|
During a Link Query operation, this keyword limits the link to fetching a single record, even if the cursor returns more than one record. This improves the operation's performance. To maintain the previous behavior of not limiting the fetch to one record, set this keyword to N.
|
?
|
|
|
|
|
SQL_PHYSICAL_LOCKING=Y
|
PostgreSQL supports physical locking at the row level as a default, when using physical transactions.
To use logical locking, add the flag: SQL_PHYSICAL_LOCKING=N
When this flag is set to Y or the flag is not set at all, Magic xpa sends the UPDLOCK table hint in the FROM clause as described below:
SELECT a,b
FROM tab1 FOR UPDATE NOWAIT
ORDER BY a
|
?
| | | |
Since version: 4.6
