Sqsh
Encyclopedia
Sqsh short for SQSHell , is an open source
substitute for isql, the interactive SQL
client
supplied with Sybase
's Adaptive Server Enterprise (ASE)
relational database management system
. Besides supporting or emulating most of the features that isql provides, sqsh provides a reasonably rich set of features that users have been asking of isql for the last couple of years.
isql and sqsh are, essentially, rudimentary command-line tools for issuing Transact-SQL
commands to an ASE Server and receiving and displaying results.
Sqsh supports, among others, command history, aliases and piping output to or from external programs and sources. It runs on various flavours of Unix
, including Linux
as well as Windows
through the Cygwin
libraries.
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
substitute for isql, the interactive SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
client
Client (computing)
A client is an application or system that accesses a service made available by a server. The server is often on another computer system, in which case the client accesses the service by way of a network....
supplied with Sybase
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
's Adaptive Server Enterprise (ASE)
Adaptive Server Enterprise
Adaptive Server Enterprise is Sybase Corporation's flagship enterprise-class relational model database server product. ASE is predominantly used on the Unix platform but is also available for Windows.-History:...
relational database management system
Relational database management system
A relational database management system is a database management system that is based on the relational model as introduced by E. F. Codd. Most popular databases currently in use are based on the relational database model....
. Besides supporting or emulating most of the features that isql provides, sqsh provides a reasonably rich set of features that users have been asking of isql for the last couple of years.
isql and sqsh are, essentially, rudimentary command-line tools for issuing Transact-SQL
Transact-SQL
Transact-SQL is Microsoft's and Sybase's proprietary extension to SQL. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements...
commands to an ASE Server and receiving and displaying results.
Sqsh supports, among others, command history, aliases and piping output to or from external programs and sources. It runs on various flavours of Unix
Unix
Unix is a multitasking, multi-user computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs, including Ken Thompson, Dennis Ritchie, Brian Kernighan, Douglas McIlroy, and Joe Ossanna...
, including Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
as well as Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
through the Cygwin
Cygwin
Cygwin is a Unix-like environment and command-line interface for Microsoft Windows. Cygwin provides native integration of Windows-based applications, data, and other system resources with applications, software tools, and data of the Unix-like environment...
libraries.