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
2 answers

Handle isql Login failed in Bash script

I want to catch the login failed in my shell script Code looks like below retval=`isql -S$envServer -U$GCMS_USERNAME -h -b << ENDSQL | grep -vE "^Password: $" $GCMS_PASSWORD set nocount on GO USE "mydb" GO USE "SELECT tname from…
Aditya Sethi
  • 10,486
  • 11
  • 26
  • 31
0
votes
1 answer

Error oracledb DPI-047 on connection to oracle database

I have an error when I try to connect to an Oracle database in version 10. I use oracledb as a module. The error : oracledb.init_oracle_client(lib_dir="64Bit121") File "src\oracledb\impl/thick/utils.pyx", line 455, in…
Kyucraft
  • 1
  • 1
0
votes
0 answers

Issue with my odbc connector 8.0 that connects to mysql8 in centos7

I tried to connect using isql command (Both are AWS EC2) # isql -v WebDB [S1000][unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'ip:3306' (110) [ISQL]ERROR: Could not SQLConnect But I can able connect manually ~**]# mysql -h…
TestingTeam
  • 1
0
votes
1 answer

Isql upgrade : extra-spaces issue

When migrating from Solaris servers to Linux servers, isql seemed to return more trailing spaces (in data files / columns) on linux servers than in Solaris servers. old-isql version : Sybase CTISQL Utility/15.0/P-EBF16309 ESD…
Noureddine Ettalhi
  • 53
  • 1
  • 7
0
votes
0 answers

[unixODBC][Driver Manager]Can't open lib '/home/odbc/sample_connections/inception/odbc.so' : file not found

Trying to write a sample odbc driver , on running iusql -v "CLICKHOUSE" getting the error [unixODBC][Driver Manager]Can't open lib '/home/odbc/sample_connections/inception/odbc.so' : file not found [ISQL]ERROR: Could not SQLDriverConnect but the…
Ritik Raj
  • 1
0
votes
3 answers

Bring Sybase database offline

Is there a way to bring a database offline in Sybase ASE 16.0? I know a database gets set offline when loading a dump, but that can't be the only way to set a database offline. There is also an official article for that, but it's locked behind a…
noah
  • 312
  • 2
  • 13
0
votes
0 answers

Can we add 2 field delimiter in kfsql command

I want to fetch data from one sybase procedure. It has some special characters in the field due to which I don't want to pass single field delimiter to the query. If I pass 2 characters in -s parameter it is showing me an error. "kfsql: invalid…
Gondkar Santosh
  • 1
  • 1
0
votes
0 answers

Unable to connect to virtuoso db from go

Hi I am creating a little go binary for custom health information from a Virtuoso db (this all runs in K8s but doing testing locally with docker-compose). I am installing the isql binary on an Alpine container (and copying my go binary to it),…
user1314147
  • 174
  • 1
  • 5
  • 25
0
votes
0 answers

Below is the command i have to convert from ISQL to PSQL

Below is ISQL query, which has column width -w and column seperator -s option can someone help with psql query for the same? isql -U$username -P$PASSWORD -S$server -i/tmp/abc **-s~ -w500** > /tmp/xyz psql -U $username -h $server -p $PORT -w -f…
ZAFAR KHAN
  • 1
  • 1
0
votes
1 answer

Error when trying to load database into backup server

Im trying to load a database dump into my Sybase backup server. Running sybase ASE-16_0 on both my primary and backup machine. Import is done in isql cli via load database DB from ./dumps/data_dump Error message is the following: Backup Server…
noah
  • 312
  • 2
  • 13
0
votes
1 answer

How to do 'Generate DDL' in Sybase Central in isql on the command line?

In Sybase Central when I right click on a stored procedure and choose 'Generate DDL', then I see the definition of the stored procedure, but also the grants for example. How do you do that on the command line with isql?
ericj
  • 2,138
  • 27
  • 44
0
votes
0 answers

isql does not exit on errors

We are using an old version of isql to connect to Informix DB from Linux (RHEL 6.10) The format we are using to run a select SQL is: isql -v -k $INX_DRIVER -x0xEC -b < ${sql_file} > ${out_file} When there are errors while running the SQL, the…
300
  • 965
  • 1
  • 14
  • 53
0
votes
2 answers

Is it possible to only bring in values into a column if there is no data in another column?

I work for a transportation company. We have two types of drivers, our own company drivers and external Carriers. Carriers are a business to business transaction and what we pay them for each move is easily entered into our system as a "Payable."…
Bertocious
  • 13
  • 1
  • 4
0
votes
1 answer

How to print message in ISQL / IBExpert Sql tool?

I know that in SQL Server we can print message via operator PRINT, but PRINT doesn't work in IBExpert, and command OUTPUT too. Can someone help me? I have this error when I run previous code:
Nika
  • 379
  • 2
  • 16
0
votes
0 answers

Looking for something to replace INTERSECT in ISQL

I am trying to construct a query to handle multiple filters in ISQL. I have a query that provides the answers I need when I'm using MSSQL, but it uses the INTERSECT command, which appears not to be present in ISQL. I have the following…
TychaBrahe
  • 55
  • 6
1 2 3
…
13 14