columns in the index definition. Any column in the base table can be specified, except when partitioning a UNIQUE index, column_name must be chosen from among those used as the unique key. This restriction allows the Database Engine to verify uniqueness of key values within a single partition...
Indicates that the new column is an identity column. When a new row is added to the table, the Database Engine provides a unique, incremental value for the column. Identity columns are typically used with PRIMARY KEY constraints to serve as the unique row identifier for the table. The IDENT...
1, which means to suppress parallel plan generation. >1, which means to restrict the maximum number of processors used in a parallel index operation to the specified number, or fewer, based on the current system workload. For example, when MAXDOP = 4, the number of processors used is 4 ...
Note: Set the data type of each field (except array) as String. This means that you must use double quotation marks (" ") to enclose the field value. Examples: If the data type of a field is Integer and its value is 20, set it as "20". ...
A computed column can be used as a key column in an index or as part of any PRIMARY KEY or UNIQUE constraint, if the computed column value is defined by a deterministic expression and the data type of the result is allowed in index columns. For example, if the table has integer columns...
This is an expression that returns a Boolean value. The filter expression will be applied to a row and if it returns true, then that row will be considered for the rule. If the filter expression returns false for that row, then it means that row will be ignored for the purposes of ...
Cookies and sessions are invalid onthe notification page, which means these data cannot be captured. The configuration and testing of asynchronous notification must be on a server that is connected to internet. The main purpose of the asynchronous notification is to prevent loss of transaction orders...
Field names don't need to be the same in order to create a relationship, but they do need to be the same data type. The connectors in theDiagram Viewhave a "1" on one side, and an "*" on the other. This means that there is a one-to-many relationship between the tables, and ...
Provides a unique identifier, by defining a source key with attributes SourceSystemOwner and SourceSystemId. Identifies the parent job, using the parent surrogate ID attribute JobId(SourceSystemId) and supplying it with the SourceSystemId value supplied on the parent Job record. For example, SCN...
If this identifier consists of more than eight characters, only the first eight are used. The name of the index space must be unique among the names of the index spaces and table spaces of the database for the identified table. If the data sets are defined by Db2, Db2 derives a unique...