Sybase ASE
11.0 11.5 11.9 12.0 12.5 15.x
Last updated: 05 September 2004
sp_license: information about ASE license options
 
Since version 12.0, some new ASE features are available as licensable options, requiring license keys. Examples are the Java-in-ASE feature in 12.0+ (the ASE_JAVA license key), and the native XML engine in 12.5.1+ (the ASE_XML license key).
To enable a licensable feature, you need to install the corresponding license key in the license file. In most cases, you'll also need to enable a configuration setting: to use Java-in-ASE, the ASE_JAVA key must be installed and the configuration parameter 'enable java' must be set to 1.

If you're using licensable options (for example, when you're running the free ASE Developer's Edition), you may find the stored procedure sp_license useful. This procedure displays the status of all licensable options in your ASE server along with the setting of the corresponding configuration parameter.

Download & install
The stored procedure sp_license can be downloaded here.
Install it by downloading the file and executing it with isql (sa_role required).

Examples
These are some examples of sp_license:
1> sp_license
2> go
 Current ASE server: TEST1252 (12.5.2/EBF 11948 ESD#1/P/)

 License Option  Description                  Option Status     Cfg.Value(run)
 --------------- ---------------------------- ----------------- --------------
 ASE_SERVER      Enterprise Edition           Disabled
 ASE_SBE         ASE Small Business Edition   Disabled
 ASE_DEV         ASE Developer's Edition      Enabled
 ASE_HA          High Availability            Enabled           Disabled (0)
 ASE_JAVA        Java-in-ASE                  Enabled           Enabled (1)
 ASE_ASM         Advanced Security Mechanisms Enabled           Disabled (0)
 ASE_DTM         Distributed Transaction Mgt. Enabled           Disabled (0)
 ASE_EJB         Enterprise Java Beans        Enabled           Disabled (0)
 ASE_XFS         External File Systems        Enabled           Disabled (0)
 ASE_EFTS        Full text search             Disabled          Disabled (0)
 ASE_DIR         LDAP                         pre-12.5.0.2 only
 ASE_DIRS        LDAP                         Enabled           Enabled (1)
 ASE_XRAY        DBXRay                       Disabled
 ASE_XML         Native XML in ASE            Enabled           Disabled (0)
 ASE_WEBSERVICES Webservices in ASE           Enabled           Disabled (0)
 ASE_MESSAGING   Real-Time Database Services  Enabled           Enabled (1)

(return status = 0)



1> sp_license ASE_XML
2> go
 Current ASE server: TEST1252 (12.5.2/EBF 11948 ESD#1/P/)

 License Option  Description                  Option Status     Cfg.Value(run)
 --------------- ---------------------------- ----------------- --------------
 ASE_XML         Native XML in ASE            Enabled           Disabled (0)

 To enable the 'ASE_XML' option, the ASE configuration parameter
 'enable xml' must also be enabled. The current run value is 0 (=Disabled)

(return status = 0)

 
 This document is located at www.sypron.nl/license.html