Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Setting Scratchpad options

When the Scratchpad perspective is open, click Options configuration-24.png (In the New console, click NW_gear.png) to set the Scratchpad options.

The following options are available:

 

Option

Description

Default value

Drop Recovery

This option lets you restore dropped objects from the Catalog Manager product via the Drop Recovery command.

Note

This option is available only if you have a valid license for the 

BMC AMI Database Administration for Db2

 solution.

No

Decimal Point

(SPE2010)

Select the check box if you want to use a period (.) for decimal points. Clear this check box if you want to use a comma.

Selected (period)

Select Options

For SELECT statements, this option lets you set maximum values for the following items (with defaults shown in parentheses) as well choose the decimal point character:

  • Maximum numeric length (10)
  • Maximum CHAR length (64)
  • Maximum VARCHAR length (64)
  • Maximum select rows (300), where valid values are 1 through 5000.

Note

The total amount of returned data in the result set cannot exceed 20 MB; the Select Options settings do not affect that limit. If the limit is reached, the product alerts you with a message.

N/A

Related topic

Working-with-commands


 

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