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
0
votes
1 answer

SQL checking the last letter in string / AKA LIKE strange behaviour

I know it was already answered but it doesn't work for me. So quick introduce: I have table called swimmers. I'll insert new record to it which fulfils all columns: INSERT INTO swimmers(id, first_name, last_name, age,…
Filip Bartuzi
  • 5,027
  • 6
  • 42
  • 92
0
votes
2 answers

subqueries AVG of the SUM result

I'm having an issue with the subqueries. so i want to list employees whose total hours worked is greater than the average total hours worked with all employee. but with this code, it compares the hours worked for one employee with another…
Luke
  • 13
  • 5
0
votes
0 answers

How to access firebird database read-only (command-line)

I have to use firebird with one of application. I want to access this database outside, using linux command-line scripts such fbexport or isql-fb. And It works perectly unless the main application is running. Checking database charset...ERROR! ***…
Tomasz Brzezina
  • 1,083
  • 5
  • 15
  • 38
0
votes
1 answer

SQL ORA-02256: number of referencing columns must match referenced columns

these are my tables : CREATE TABLE EMPLOYEE( Emp_id number(4), Emp_name varchar2(30), Emp_gender varchar2(1), Status varchar2(30), Years_service number(4), Primary Key (emp_id) ); CREATE TABLE ACTIVITY( Act_id…
Luke
  • 13
  • 5
0
votes
3 answers

Simba Spark ODBC driver fail to connect, always timeout

I have a fully functioning Apache Spark Hive ThriftServer 1.2.1 which is tested with beeline and SQL Developer (both works). The configuration for this server is as follows: hive.server2.authentication …
tribbloid
  • 4,823
  • 10
  • 46
  • 81
0
votes
3 answers

How to output data from iSQL to csv file with column names

I am trying to query a Sybase using iSQL client and export the query results to a text file or CSV file with column name. However the column headings are not exported to the file. I tried below script it shows error message, below the working script…
Matt
  • 1
  • 1
  • 4
0
votes
2 answers

Can I run a Firebird stored procedure from a batch file, or is there an ISQL equivalent

I want to run a Firebird stored procedure from a batch file or similar on a desktop. The stored procedure contains insert statements and update statements with if possible parameters that I would like to pass. Any ideas or other suggestions would be…
Mark
  • 1
  • 1
0
votes
1 answer

ASE ISQL (SyBase): how to debug truncation error (which field causes it)

I have a long SyBase SQL query that causes a truncation error. If I run it in ISQL, I get the error with the line number, however, the line number is the beginning of the query so it doesn't tell me which field is causing the truncation error. How…
evg02gsa3
  • 533
  • 5
  • 16
0
votes
1 answer

How to extract the sybase sql query output in a shell script

I am trying to execute a SQL query on SYBASE database using shell script. A simple query to count the number of rows in a table. #!/bin/sh [ -f /etc/bash.bashrc.local ] && . /etc/bash.bashrc.local . /gi/base_environ . /usr/gi/bin/environ .…
deepak
  • 29
  • 1
  • 2
  • 7
0
votes
1 answer

Sybase loses data when using ASE ISQL utility?

I administer Sybase ASE(15.0.7) database thats run on Solaris(11). I am pretty new specifically to Sybase ASE , but I have pretty well overall knowledge with working on databases such as SQL Server. Lately, while I was doing tasks such as uploading…
Kirill Pashkov
  • 2,918
  • 1
  • 11
  • 18
0
votes
1 answer

isql exception unixODBC data source name not found

I am trying to connect my php application with SQL server in my Linux box. I installed unixODBC successfully and made required changes in odbc.ini and odbcinst.ini file. When I run command.
sqlcmd -S DSN -U USERNAME -P Password I am able…
Shrikant
  • 21
  • 4
0
votes
2 answers

want to convert string mm/dd/yy to date yyyy/mm/dd format in Sybase

I want to convert date which is string and like mm/dd/yy to date datatype in format yyyy/mm/dd.
RDP
  • 61
  • 2
  • 12
0
votes
1 answer

How can I insert newlines in the correct places in isql output in a bash script?

I am querying a database (SQL Server) using isql in a bash script. For example: RESULT="$(${ISQL} -Q -U ${DB_USER} -S ${DB_SERVER} -D ${DB_NAME} << __END SELECT order_id % 5 as mod5, count(*) as count FROM orders GROUP BY order_id % 5 ORDER BY…
Jer
  • 4,958
  • 6
  • 28
  • 39
0
votes
1 answer

External Environment could not be started - CLR on Sybase's Interactive SQL

I'm having an issue figuring out how to start an external environment within Sybase Central's Interactive SQL. The executable, dbextclr12.exe has not been manipulated since 2010, so I know I didn't accidentally alter that. Here is the call: START…
Object-Oriented Disoriented
  • 23
  • 5
0
votes
1 answer

using isql across multiple ksh scripts

I very new to ksh script but I have 2 ksh scripts each of them calling sybase stored procedure via isql. The issue I'm seeing is that when I execute the first script the stored procedure runs fine but when I execute the second it fails with error of…
user1015196
  • 503
  • 5
  • 18
1 2 3
…
11
12