The Adaptive Server plug-in includes Interactive SQL. Interactive SQL which is a common client utility for all the Sybase servers and can connect to Open Server-based applications such as Replication Server. As a Java-based client, Adaptive Server plug-in can run on Linux and other UNIX platforms and is a more advanced product than the Jisql utility included with earlier releases of Adaptive Server.
Interactive SQL allows you to execute SQL statements, build scripts, and display data to the server. You can use it to:
Browse the information in a database
View a graphical representation of your query
Edit your result sets, and have the changes update the database
Export to MicroSoft Excel and other formats
Test SQL statements that you plan to include in an application
Load data into a database and carry out administrative tasks
Interactive SQL can run command files or script files. For example, you can create repeatable scripts to run against a database and then use Interactive SQL to execute these scripts as batches.
The batch scripts for Adaptive Server 15.0 and ESD #1 contain an error in their call to the Interactive SQL class file. In some scripts, the -Dpath option is incorrect, although the %path% value for the option is present.
To correct this issue, move to %SYBASE%\dbisql\bin and edit the dbisql.bat file and make sure the execution line reads shown below:
The line breaks are for document formatting; this command
is actually one continuous line. Pay particular attention to the
dashes (“-”) —which are switch characters—when
copying and pasting this line into your script.
"%JRE_DIR%\bin\java" -Disql.helpFolder="%DBISQL_DIR%\help" -Dsybase.jsyblib.dll.location="%SYBROOT%\Shared\win32\\" -Djava.security.policy="%DBISQL_DIR%\lib\java.policy" -Dpath="%path%" -classpath "%DBISQL_DIR%\lib;%isql_jar%;%jlogon_jar%;%jodbc_jar%;%xml4j_jar%;%jconn_jar%;%dsparser_jar%;%helpmanager_jar%;%jcomponents_jar%;%jh_jar%;%jsyblib_jar%;%planviewer_jar%;%sceditor_jar%;%uafclient_jar%;%jinicore_jar%;%jiniext_jar%;%jmxremote_jar%;%jmxri_jar%;%commonslogging_jar%;%log4j_jar%" sybase.isql.ISQLLoader -ase %*
You can also trim the %path% environment variable to only what is necessary. For example:
set PATH="c:\sybase\ASE-15_0\bin;c:\sybase\OCS-15_0\bin;.;"
Sybase no longer maintains SQL Advantage™. It connects to Adaptive Server 15.0, but because it does not include some newer API features in Open Client 15.0, it has limited functionality.
If you have problems running SQL Advantage on a machine that includes Adaptive Server 15.0 PC-Client, SQLAdvantage may be finding Open Client 15.0 in the path ahead of Open Client 12.5. Because Open Client 15.0 renamed some of the dll libraries, SQLAdvantage fails when it uses these libraries. As a workaround, create a shell script that includes only the Open Client 12.5 library directories (and none of the Open Client 15.0 library directories) in the path environment variable. Launch SQLAdvantage from this shell script.
