IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5

Using a Row Generator Stage in Default Mode

In this example you are going to allow the Row Generator stage to generate a data set using default settings for the data types. The only change you make is to ask for 100 rows to be generated, rather than the default ten. You do this by setting the Number of records property to 100 in the Properties tab.

You need to tell the stage how many columns in the generated data set and what type each column has. You do this in the Output page Columns tab by specifying the following column definitions:

Table 1. Column definitions
Column name	SQL type
string	Char
date	Date
time	Time
timestamp	Char
integer	integer
decimal	Decimal

When you run the job, InfoSphere® DataStage® generates a data set containing the following rows (sample shown):

Figure 1. Sample data set

Shows the dummy data set generated by the Row Generator stage in the example job

You can see from this the type of that is generated by default. For example, for date fields, the first row has January 1st 1960, and this is incremented by one day for each subsequent row.

You can specify more details about each data type if required to shape the data being generated.

This topic is also in the IBM InfoSphere DataStage and QualityStage Parallel Job Developer's Guide.

Update timestamp

Last updated: 2012-10-8