MAXROWS


Use this option to limit the number of rows that BMC AMI Unload unloads from a table.

When BMC AMI Unload reaches the specified integer or reaches the end of the file (whichever occurs first), BMC AMI Unload terminates processing. If you specify a value for MAXROWS that is greater that the number of table rows, BMC AMI Unload unloads all table rows. To unload all rows without limit, specify MAXROWS 0 or omit this option.

The FILSZ value passed to SORT comes from the MAXROWS option value (if it is used). Otherwise, the FILSZ value uses a value of 100,000.

For an example of the use of the MAXROWS option, see Unloading-a-specific-number-of-rows


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*