Questions tagged [isql]
6 questions
5
votes
1 answer
Is there a -w equivalent for isql when already connected?
The default output (text) width in sybase isql is 80. It can be changed with the -w flag when isql is started on a command line:
isql -w 200 -S... -U... -P...
Now, I am wondering if there is a possibility to change the text width when I am already…
René Nyffenegger
- 3,763
- 7
- 32
- 39
4
votes
1 answer
How to make iSQL/FreeTDS behave like a normal client?
I have a third-party Sybase database, which my users would like to connect to and query from a Linux box, using iSQL. I have installed UnixODBC and FreeTDS. As it is third-party database however, I am not able to perform any GRANTs. The query fails…
Gaius
- 11,238
- 3
- 32
- 64
2
votes
3 answers
How can I pass parameters to an "SQL Script" from isql
I am wondering if it is possible to pass parameters to an SQL script from within sybase's isql utility.
For example, I'd like to store a select statement in the file the_script.sql that would look something like
select
col_1,
col_2,
…
René Nyffenegger
- 3,763
- 7
- 32
- 39
1
vote
2 answers
How to check sybase command line history?
How can I check the previous command line history in sybase command line?
Özzesh
- 115
- 1
- 3
- 6
0
votes
1 answer
Problem with many connections from RHEL 8.10 to SQL Server
I have simple script:
for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
done
We upgraded OS from RHEL 7.9 to 8.10.
ODBC drivers installed:…
Juraj
- 11
- 2
0
votes
1 answer
Firebird isql exclusive mode?
I have a vague recollection that Firebird's isql utility will in some situations make an exclusive connection to the database, meaning that any other connection attempts will be refused.
I fail to find information about this.
Can anyone explain in…
Kjell Rilbe
- 123
- 5