SAP Sybase IQ16.0 (Sybase Central client), which provides a command line Client

Source: Internet
Author: User
Tags sybase

Recently, Sybase Central client (java client) was removed from IQ16.0. The new client may only use SCC ?!

For old users, it is undoubtedly a pain point.

It seems that only one client can be extracted from IQ15.4 or 15.3.


In this case, I wrote a command line client in the SDK library for indexing,

This is a very small and exquisite IQ command line client. It is interesting that it can also be used in ASA12 and later versions of the ASA database. This is the charm.
Put it under the Bin32 sub-directory of IQ or ASA, and enter this directory: sasql <connection string>

The usage is as follows:

The usage is as follows:

C: \ ScjviewIQ16 \ IQ-16_0 \ Bin32> sasql.exe "uid = dba; pwd = SQL; links = tcpip (host = mega-vm
014: 2638; verifyservername = no )"
The conn string is: uid = dba; pwd = SQL; links = tcpip (host = mega-vm014: 2638; verifyserve
Rname = no)
Successfully connected. Welcome using sasql for SQLAnywhere Database. sasql vers
Ion 1.0.1 command line utility for SA database
Copyright 2011 iihero & SpringTech, Inc.
Enter ". help;" for instructions
Enter SQL statements terminated with ";"
Sasql>. help;
. Exit; Exit this program
. Quit; Exit this program
. Help; Print the help menu
. Read <SQL file>; Read and execute a SQL file
<SQL statement>; Execute a SQL statement

Sasql>

Each Command ends.

Sasql> call sp_tables ();
Estimated number of rows:-346.
Table_qualifier, table_owner, table_name, table_type, remarks
---------------------------------------------------------
'Iqdemo', 'sys ', 'isytab', 'System table', (NULL)
'Iqdemo', 'sys ', 'isbabac', 'System table', (NULL)
'Iqdemo', 'sys ', 'isysobject', 'System table', (NULL)
'Iqdemo', 'sys ', 'isysidx', 'System table', (NULL)
'Iqdemo', 'sys ', 'isysphysidx', 'System table', (NULL)

..............

---------------------------------------------------------
346 rows returned


Warning: [105] 'Procedure has completed'
Total elapsed time = 281 ms


You can also execute an SQL file. Other functions will be expanded later, so much will be written first.

:

Http://download.csdn.net/detail/iihero/7072717





Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.