Stack Overflow
Stack Overflow

Questions tagged [isql]

The isql utility is a command-line Interactive SQL utility that uses the Adaptive Server Enterprise Open Client API.

isql is a utility that is being provided by Sybase to connect to the Sybase server. The isql utility can be invoked from the Windows command prompt or in Unix machine. The basic command to connect to a Sybase server via the isql utility is as follows -

isql -SSERVER_NAME -DDATABASE_NAME -ULOGIN_NAME -PPASSWORD

Once you enter this in the command prompt you will be visited with a blank command screen with a prompt -

>

You can now enter sql commands and create scripts with isql and execute them.

The isql utility is located at -

$SYBASE/$SYBASE_OCS/bin on UNIX machines and at C:\SYBASE\OCS-12_0\bin\ folder on Windows system.

Some basic problems that database users find with isql utility is that it provides console mode for working in with Sybase databases which is usually not very handy for many database users especially having experience working in Windows. With many handy GUI IDE's available for working with Sybase servers like ASEISQL(free tool), Embarcadero Rapid SQL, Quest TOAD etc the isql utility is lesser used in normal day work. However the utility has some basic characteristics of its own like a script not terminated by the go token can be easily identified while working with isql than any other IDE as isql does not execute a statement until it finds the delimiter token go at the end of the script.

To understand the isql utility more you can visit the Sybase knowledge center site @ -

Sybase Knowledge Center Link to Sybase ASE 15.0 isql utility

179 questions
4
votes
4 answers

Failure to connect to SQl Server from Linux

I am trying to connect to SQL Server 2008 on CentOS 5.8. I am using unixODBC 2.3.0 and SQL Server ODBC Driver (www.microsoft.com/en-us/download/details.aspx?id=28160). When I try to test the connection by running: isql -v mydsn username password it…
kirylm
  • 101
  • 1
  • 1
  • 6
4
votes
3 answers

Run multiple insert queries against firebird database using isql

I have requirement of inserting enormous data in table of firebird database around 40K entries. I got my scripts ready but while executing it using flameRobin, the UI just got hang forever while inserting such enormous data in one go. I know it…
Rohit Vats
  • 74,365
  • 12
  • 144
  • 173
3
votes
1 answer

Replace isql with sqsh in emacs (Ubuntu)

Using emacs on Ubuntu 11.10. I want to connect to a SQL Server database using sqsh instead of isql. I added the following to my initi.el (set 'sql-sybase-program "sqsh") (set 'sql-ms-program "sqsh") It recompiles and loads successfully. However,…
Choens
  • 1,282
  • 2
  • 13
  • 23
3
votes
1 answer

SQL - Generate column based on output

Here is my problem. I have a database with 2 strong entities (event and employee). Every event can have multiple employees as assistants and has one employee as leader. So I have a foreign key leaderID in event, and created a weak entity assistant…
Ladestes
  • 33
  • 3
3
votes
2 answers

Escaping Problem in bash using isql

I am currently working on a little backup script from some firebird databases and I've come up with a weird escaping problem that I don't seem to be able to solve. Here's the thing in my script I create a variable called sqllog in which I would like…
flazzarini
  • 6,403
  • 4
  • 29
  • 30
3
votes
1 answer

Create Teradata volatile table and select from table using isql

I am trying to submit a two-statement SQL file as a batch job to the isql utility on a Linux machine. The first statement defines a VOLATILE TABLE and the second statement is a SELECT statement against this table. The Teradata server is hosted on a…
Jubbles
  • 3,722
  • 8
  • 29
  • 46
3
votes
2 answers

How to connect to Sybase Server/Database without port number using DSN or RapidSQL? Or how to find port number?

I have Some Sybase Server/Databases. I know 1. Server Name 2. Database Name 3. Username 4. Password. Using this I can connect using ISQL but while using RapidSQL it asks for port. I have existing application which uses DSN, while creating DSN also…
Pritesh
  • 1,810
  • 7
  • 29
  • 43
3
votes
1 answer

Adding data sources for unixODBC/isql on Mac OSX Lion

I have installed unixODBC from source and mysql-odbc connector from .dmg installer on Mac OSX Lion. This was done a while ago, and at that time I successfully installed a data source (let's call it foo). Now I am trying to add another data source…
Neil
  • 6,236
  • 8
  • 37
  • 70
2
votes
2 answers

isql (sql anywhere) updating NULL value

How can i change (NULL) value of a table? I have searched everywhere but didn't find the right answer. Works, but updates 0 rows: UPDATE Club SET Place = 24 WHERE Place = NULL; Not working: UPDATE Club SET Place = 24 WHERE Place IS NULL;
Slavak
  • 223
  • 3
  • 11
2
votes
1 answer

Informix iSQL date function help

I'm trying to extract just the year out of either of the built-in date functions of Informix TODAY or CURRENT Is there a way to do this without SUBSTR()?
CheeseConQueso
  • 5,493
  • 25
  • 84
  • 126
2
votes
4 answers

SQL - Informix error leads to another error - hallway of mirrors P.I.T.A

I'm using Informix version 11.50.FC6 via iSql I'm giving the result of a CASE block a virtual name, att_hrs SELECT c.id, CASE WHEN ( c.prog = 'UNDG' AND (c.grd IN (SELECT DISTINCT grd FROM…
CheeseConQueso
  • 5,493
  • 25
  • 84
  • 126
2
votes
1 answer

Create user fails in Firebird 3 with isql-fb

I am trying to create a user in a firebird 3 database (on Fedora 27). When I connect to my database with isql-fb with the role RDB$ADMIN, I cannot create new users. [user@host]$ isql-fb -z ISQL Version: LI-V3.0.3.32900 Firebird 3.0 Use CONNECT or…
mor22
  • 1,302
  • 1
  • 14
  • 28
2
votes
1 answer

Sum values of each element by hour from date to date in SQL

I was searching a lot, but I could not find the answer. Maybe someone can give me some hints: I have a table that contains following columns and data (just an example): +-------+------------------+----+--------+--------+ | Type | InsertDate |…
KonradR
  • 43
  • 7
2
votes
1 answer

Unable to establish connection with data source with Teradata. Missing settings: {[DBCName]}

I'am installed Teradata driver on CentOS as described in official README. After installation drivers is located in /opt/teradata/client /ODBC_32/ /ODBC_64/ Each folder has subfolders and files include lib locale odbc.ini odbcinst.ini Using…
Evgeniy
  • 2,539
  • 4
  • 18
  • 35
2
votes
1 answer

How to ignore or replace "carriage return" in informix 4GL

Say I have the following query: insert into myTable values ("TEST 1 TEST 2") Then I'm selecting the description to output to an excel sheet: select description from myTable Result: description TEST 1TEST 2 This will result the output for the…
Moses Davidowitz
  • 958
  • 11
  • 24
1
2
3
…
11 12