|
Rule name |
Using DB2 Sequence to Generate Surrogate Key |
|---|---|
|
Parallel Job |
Yes |
|
Server Job |
Yes |
|
Job Sequence |
- |
|
Description |
Identifies where a Db2 Sequence is used to provide a surrogate key value. |
Description
This rule identifies where a Db2 Sequence is used to provide a surrogate key value. This is relevant as DataStage SaaS does not support using Db2 Sequence to generate a surrogate key,
Actions
Redesign your job to use a different mechanism for supplying surrgate keys (e.g., a surrogate key file.)