PROCESSING STAGE

Change Apply Stage

The stage editor has three pages:

· Stage page. This is always present and is used to specify general information about the stage.

· Inputs page. This is where you specify the details about the single input set from which you are selecting records.

· Outputs page. This is where you specify details about the processed data being output from the stage.

PROPERTIES:

Change Keys Category

Key.Specifies the name of a difference key input column. This property can be repeated to specify multiple difference key input columns. You can use the Column Selection dialog box to select several columns at once if required. Key has the following dependent properties:

· Case Sensitive. Use this to property to specify whether each key is case sensitive or not. It is set to True by default; for example, the values “CASE” and “case” would not be judged equivalent.

· Sort Order. Specify ascending or descending sort order.

· Nulls Position. Specify whether null values should be placed first or last.

Change Value category

Value. Specifies the name of a value input column. Value has the following dependent properties:

· Case Sensitive. Use this to property to specify whether each value is case sensitive or not. It is set to True by default; for example, the values “CASE” and “case” would not be judged equivalent.

Options Category

Change Mode. This mode determines how keys and values are specified. Choose Explicit Keys & Values to specify the keys and values yourself. Choose All keys, Explicit values to specify that value columns must be defined, but all other columns are key columns unless excluded. Choose Explicit Keys, All Values to specify that key columns must be defined but all other columns are value columns unless they are excluded.

Log Statistics. This property configures the stage to display result information containing the number of input records and the number of copy, delete, edit, and insert records.

Check Value Columns on Delete. Specifies that DataStage should not check value columns on deletes. Normally, Change Apply compares the value columns of delete change records to those in the before record to ensure that it is deleting the correct record.

Code Column Name. Allows you to specify that a different name has been used for the change data set column carrying the change code generated for each record by the stage. By default the column is called change_code.

Copy Code. Allows you to specify an alternative value for the code that indicates a record copy. By default this code is 0.

Delete Code. Allows you to specify an alternative value for the code that indicates a record delete. By default this code is 2.

Edit Code. Allows you to specify an alternative value for the code that indicates a record edit. By default this code is 3.

Insert Code. Allows you to specify an alternative value for the code that indicates a record insert. By default this code is 1.