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 are 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)