Warning Truncate Table

Type

Selection

Range

The settings listed below

Default

Common_warning_default

This option determines the behavior of AIMMS when a truncate table command is used on a data source that does not support truncating tables. Possible values are:

  • Off

Do not issue a warning.

  • Warning_collect

Issue a warning and post it to the global error and warning collector.

  • Common_warning_default

Take action depending on the option ‘Common warning default’.

  • Warning_handle

Issue a warning and post it to the nearest error handler.

  • Strict_warning_default

Take action depending on the option ‘Strict warning default’.

  • Error

Issue an error.

  • Error_in_develop_else_warning

In a developer system same as Error, in a deployment system same as Warning_handle

  • Error_in_develop_else_off

In a developer system same as Error, in a deployment system same as Off

  • Warning_in_develop_else_off

In a developer system same as Warning_handle, in a deployment system same as Off

Note

  • With the option Maximal Number of Warnings Reported you can set the maximal number of warnings that are shown in errors/warnings and message window.

  • You can use the empty command on database that do not support truncating tables. The empty is slower, but the effect is the same. When this option is set to Off or Warning, AIMMS will use the empty statement automatically when the database does not support truncating tables.

Learn more about