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

199 questions
0
votes
1 answer

Python Sybase module vs subprocess isql , which one is better to use?

I found isql(using subprocess) is taking less time compare to Sybase module in python. Could someone please suggest me, should I use subprocess or Sybase. Below is the small test script which I have used for my understanding. Query = 'select…
Reetesh Nigam
  • 133
  • 2
  • 2
  • 15
0
votes
0 answers

Isql import with big file

When I try to import big SQL file with isql, I have strange error "c:\Program Files\Firebird\Firebird_2_5\bin\isql.exe" -b -e -i d:\ImportSQL.sql localhost:D:\ImportDB.gdb -user SYSDBA-password masterkey Statement ailed, SQLSTATE = 42000 Dynamic…
Hugues Van Landeghem
  • 6,755
  • 3
  • 34
  • 59
0
votes
1 answer

Getting mapped entities from an ISQLQuery without AddEntity

consider these POCOs: class Foo { int Id {get;set;} string Name {get;set;} } class Bar { int Id {get;set;} string PropA {get;set;} Foo PropB {get;set;} } Now what i want to achieve is using an ISQLQuery with a root entity of Bar to also…
Jaguar
  • 5,929
  • 34
  • 48
0
votes
0 answers

ISQL Six Digits Limitation

I wanna get rid of isql six digits limitation. How can i overcome this ? " isql displays only six digits of float or real data after the decimal point, rounding off the remainder." If WE get it from sql advantage we can see all digits after comma.…
Advard Nortan
  • 1
  • 2
0
votes
1 answer

Print sql output messages to a file in shell script

I need to run SQL scripts and wanted to capture that output to a log file. I am trying to access Sybase using ISQL and below is the sample file, though only echo messages are getting printed in the log file. Command that I am running on windows box…
ANewDeveloper
  • 45
  • 8
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,711
  • 7
  • 54
  • 102
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,452
  • 5
  • 21
  • 44
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,026
  • 14
  • 64
  • 103
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
  • 571
  • 5
  • 17
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
  • 49
  • 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
  • 3,118
  • 1
  • 15
  • 20
1 2 3
…
13 14