dol_downgrade_check

Returns the number of data-only-locked (DOL) tables in the specified database that contain variable-length columns wider than 8191 bytes. Returns 0 when there are no wide, variable-length columns and you can safely perform the downgrade.

Syntax

dol_downgrade_check('database_name', target_version) 

Parameters

Examples

Usage

  • Returns zero (success) if the target version is SAP ASE version 15.7 or later, indicating that no work is necessary.

  • If you specify a qualified table, but do not indicate the database to which it belongs, dol_downgrade_check checks the current database.

Permissions

The permission checks for dol_downgrade_check differ based on your granular permissions settings.

Granular PermissionsDescription
Enabled

With granular permissions enabled, you must be the database owner or have manage database permission to execute dol_downgrade_check.

Disabled

With granular permissions disabled, you must be the database owner or be a user with sa_role to execute dol_downgrade_check.