0 / 0
Peek stage: Stage tab (DataStage)

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.


You can specify the following properties on the Stage tab:
Table 1. 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.


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.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more