Skip to content

/AWS1/CL_DBRJOBSAMPLE

A sample configuration for profile jobs only, which determines the number of rows on which the profile job is run. If a JobSample value isn't provided, the default is used. The default value is CUSTOM_ROWS for the mode parameter and 20,000 for the size parameter.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_mode TYPE /AWS1/DBRSAMPLEMODE /AWS1/DBRSAMPLEMODE

A value that determines whether the profile job is run on the entire dataset or a specified number of rows. This value must be one of the following:

  • FULL_DATASET - The profile job is run on the entire dataset.

  • CUSTOM_ROWS - The profile job is run on the number of rows specified in the Size parameter.

iv_size TYPE /AWS1/DBRJOBSIZE /AWS1/DBRJOBSIZE

The Size parameter is only required when the mode is CUSTOM_ROWS. The profile job is run on the specified number of rows. The maximum value for size is Long.MAX_VALUE.

Long.MAX_VALUE = 9223372036854775807

Queryable Attributes

Mode

A value that determines whether the profile job is run on the entire dataset or a specified number of rows. This value must be one of the following:

  • FULL_DATASET - The profile job is run on the entire dataset.

  • CUSTOM_ROWS - The profile job is run on the number of rows specified in the Size parameter.

Accessible with the following methods

Method Description
GET_MODE() Getter for MODE, with configurable default
ASK_MODE() Getter for MODE w/ exceptions if field has no value
HAS_MODE() Determine if MODE has a value

Size

The Size parameter is only required when the mode is CUSTOM_ROWS. The profile job is run on the specified number of rows. The maximum value for size is Long.MAX_VALUE.

Long.MAX_VALUE = 9223372036854775807

Accessible with the following methods

Method Description
GET_SIZE() Getter for SIZE, with configurable default
ASK_SIZE() Getter for SIZE w/ exceptions if field has no value
HAS_SIZE() Determine if SIZE has a value