SQLAnywhere – How to Get List of Enabled/Disabled Features

sybase-sql-anywhere

I'm looking to get a list of features, which are installed or enabled/disabled on a given SQLAnywhere instance. dblic is only showing the 'possible' feature based on lice, but not the actually available features of database server … or is it?

Best Answer

You don't say which version of SQL Anywhere you are using but for v12.0.1 you can execute SELECT PROPERTY ( 'ServerEdition' ); The result is explained in the docs thus:

ServerEdition

Returns a space-separated list of words describing the database server type. Values include:
Evaluation
Developer 
Web 
Educational 
Standard 
Advanced 
Workgroup 
OEM 
Authenticated
If you have a separate license for any of the following features, then the appropriate string(s) are added to the license string that is returned:
HighAvailability   See SQL Anywhere high availability option. 
InMemory           See SQL Anywhere in-memory mode option. 
ECC                See SQL Anywhere security option. 
FIPS               See SQL Anywhere security option. 

You can get more help at the dedicated SQL Anywhere forum http://sqlanywhere-forum.sap.com/

Related Solutions

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

Checked official documentation for this error and could see it as below:

Source the SAP IQ setup scripts using the same user that starts the SAP IQ server.

This will set the LD_LIBRARY_PATH and other important environment variables.

The error could be happening due to not setting/wrongful setting of appropriate environment variables on the host on which SAP IQ is running.

You need to set the environment variables on Linux Box.

You may do below for setting these variables:

Change to the SAP IQ parent installation directory and execute one of the following: For the tcsh or C (csh) shell, enter:

source ./IQ.csh

For the Korn (ksh), Bash, or Bourne (sh) shells, enter:

source ./IQ.sh

Hope this helps.

SQLAnywhere Message Length – Configuring Output Length in isql

I found a solution at least for my basic issue, which is almost too simple:

    -- ... some code
DECLARE @generatedProcedureCall LONG VARCHAR
SET @generatedProcedureCall = ... contents
SELECT @generatedProcedureCall

This is allowing me to print out >4k characters for e.g. debugging.

When writing to file e.g.

SELECT @generatedProcedureCall INTO #logfoo
UNLOAD #logfoo to 'some/file'

could do the trick.

Maybe not the cleanest one, but as mentioned it solved at least my issue.

The reasons seems to be, that print as well as message cannot handle string >4k of text. print was just failing with an error whereas message catted my string to 255 characters.

Best Answer

ServerEdition

Related Solutions

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

SQLAnywhere Message Length – Configuring Output Length in isql

Related Question