ROWESTIMATE Function

Sets the estimated total number of rows to be reported by this step.

Category: Data Input
Returned data type: Integer
Note: The returned value is a Boolean value where 1= success and 0 = error.

Syntax

rowestimate(<integer>)

Optional Argument

<integer>

specifies an integer that contains an estimate for the total numbers of rows that will be output from the step

Details

The rowestimate function is used by data jobs to estimate the number of records that will be output from the step.

Example

// Declare a hidden integer for the number of output rows

hidden integer nrows

 

// Set the number of rows for the function

nrows=100

 

// This function estimates and sets the # of records that this step will report

rowestimate(nrows)