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