license_enabled

Description

Returns 1 if a feature’s license is enabled, 0 if the license is not enabled, or NULL if you specify an invalid license name.

Syntax

license_enabled("ase_server" | "ase_ha" | "ase_dtm" | "ase_java" | 
	"ase_asm")

Parameters

ase_server

specifies the license for Adaptive Server.

ase_ha

specifies the license for the Adaptive Server high availability feature.

ase_dtm

specifies the license for Adaptive Server distributed transaction management features.

ase_java

specifies the license for the Java in Adaptive Server feature.

ase_asm

specifies the license for Adaptive Server advanced security mechanism.

Examples

Example 1

Indicates that the license for the Adaptive Server distributed transaction management feature is enabled:

select license_enabled("ase_dtm")
--------------
             1

Usage

For information about installing license keys for Adaptive Server features, see your installation guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute license_enabled.

See also

Documents Installation guide for your platform

System procedure sp_configure