|
license_enabled()
The
system function
license_enabled()
has a return value of "1", if a license for an
ASE feature is active,
"0", if the respective license is inactice and
"NULL", if an invalid license name was specified in the function parameter.
The function license_enabled() is a
T-SQL
extension.
It can be executed by any
user.
Syntax of the System Function license_enabled()
The parameter of the System Function license_enabled()
"option"
The parameter "option" is the name of the
feature, for which the license must be checked.
The parameter "option" must be set in quotes.
Possible values for the parameter "option" are:
-
ase_server - The license for Adaptive Server.
-
ase_ha - The license for the high availability feature (High Availability - HA).
-
ase_dtm - The license for the feature "Distributed Transaction Management" (DTM).
-
ase_java - The license for Java in ASE
-
ase_asm - The license for Advanced Security Management (ASM).
Example for the System Function license_enabled()
select license_enabled("ase_dtm")
--------------
1
The return value (1) shows that a license for the feature "ase_dtm" was enabled on this ASE.
See also:
ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
