Database Information - ODBC (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
|
|
|
|
|
|
CHECK_KEY=Y
|
Checks the data table for the existence of a unique index value as the end user attempts to input a data into a record. If a duplicate value is input by the end user into the variables constructing an index defined as Unique in Magic xpa’s Data repository, Magic xpa will issue a Duplicate Index error message and prevent further end-user processing until the input is changed. For some DBMSs, this check takes a toll in performance and it is not recommended. In such a case, the developer may decide not to use this keyword, and then the results of duplicate index value entry will depend on the DBMS behavior.
|
?
| | | |
|
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. Since version: 3.2
|
?
| | | |
|
MAGICKEY=N
|
For a data source with no unique index, adds a column that will be the unique index. Magic xpa will insert values automatically to this column. The column that is the MAGICKEY should be selected.
|
|
|
?
|
|
|
SQL_EXTENDED_FETCH=Y
|
Specifies whether to skip Extended Fetch. By default, the gateway fetches a set of records (extended fetch) from the databases, depending upon the array size. If SQL_EXTENDED_FETCH=N, then it notifies the gateway to fetch only a single record at a time from the database.
|
?
|
|
|
|
|
SQL_STARTPOS=N
|
Specifies whether to close a cursor that fetches records from a table each time the end user skips from one page to another. Closing the cursor forces Magic xpa to open another cursor that will reposition on a certain record accordingly.
The default is N, meaning that Magic xpa will not reposition itself for every screen, but will use the original cursor.
|
?
|
|
|
|
