Database Information - DB2 (Magic xpa 2.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.
| v | | | |
|
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.
|
|
|
v
|
|
|
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.
|
v
|
|
|
|
