Peek stage: Stage tab (DataStage)
You can specify aspects of the Peek stage from the Peek stage: Stage page.
The General tab allows you to specify an optional description of the stage. The Properties tab lets you specify what the stage does. The Advanced tab allows you to specify how the stage executes.
Properties
Category/Property | Values | Default | Mandatory? | Repeats? | Dependent of |
---|---|---|---|---|---|
Rows/All records (after skip) | True/False | False | N | N | N/A |
Rows/Number of records (per partition) | number | 10 | Y | N | N/A |
Rows/Period (per partition) | Number | N/A | N | N | N/A |
Rows/Skip (per partition) | Number | N/A | N | N | N/A |
Columns/Peek all input columns | True/False | True | Y | N | N/A |
Columns/Input column to peek | Input Column | N/A | Y (if Peek All Input Columns = False) | Y | N/A |
Partitions/All partitions | True/False | True | Y | N | N/A |
Partitions/Partition number | number | N/A | Y (if All Partitions = False) | Y | N/A |
Options/Peek records output mode | Job Log/Output | Job Log | N | N | N/A |
Options/Show column names | True/False | True | N | N | N/A |
Options/Delimiter string | space/nl/tab | space | N | N | N/A |
All records (after skip)
True to print all records from each partition. Set to False by default.
Number of records (per partition)
Specifies the number of records to print from each partition. The default is 10.
Period (per partition)
Print every Pth record in a partition, where P is the period. You can start the copy operation after records have been skipped by using the Skip property. P must equal or be greater than 1.
Skip (per partition)
Ignore the first number of rows of each partition of the input data set, where number is the number of rows to skip. The default skip count is 0.
Peek all input columns
True by default and prints all the input columns. Set to False to specify that only selected columns will be printed and specify these columns using the Input Column to Peek property.
Input column to peek
If you have set Peek All Input Columns to False, use this property to specify a column to be printed. Repeat the property to specify multiple columns.
All partitions
Set to True by default. Set to False to specify that only certain partitions should have columns printed, and specify which partitions using the Partition Number property.
Partition number
If you have set All Partitions to False, use this property to specify which partition you want to print columns from. Repeat the property to specify multiple columns.
Peek records output mode
Specifies whether the output should go to an output column (the Peek Records column) or to the job log.
Show column names
If True, causes the stage to print the column name, followed by a colon, followed by the column value. If False, the stage prints only the column value, followed by a space. It is True by default.
Delimiter string
The string to use as a delimiter on columns. Can be space, tab or newline. The default is space.
Advanced
This section allows you to specify the following:
- Execution Mode. The stage can execute in parallel mode or sequential mode. In parallel mode the input data is processed by the available nodes as specified in the Configuration file, and by any node constraints specified on the Advanced section. In Sequential mode the entire data set is processed by the conductor node.
- Combinability mode. This is Auto by default, which allows IBM® DataStage® to combine the operators that underlie parallel stages so that they run in the same process if it is sensible for this type of stage.
- Preserve partitioning. This is Set by default. You can explicitly select Set or Clear. Select Set to request the next stage should attempt to maintain the partitioning.