Solved

isql?

Posted on 1998-07-07
10
800 Views
Last Modified: 2008-02-07
Im using isql to access the sybase server.
Im using this syntax,
isql -w 130 -i in.txt -o out.txt
However, isql says it cant open in.txt. I assume this is because it cant find it. What path should this file be put at so that the isql can locate it?
0
Comment
Question by:Coates
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 20 total points
ID: 1098160
It should be in the directory you runnning isql from , but I would still suggest to put full path, just to make sure you are using the file you intended to use. You can also use '<' filename instead of -i filename
0
 

Author Comment

by:Coates
ID: 1098161
Ive tried using the full path. Ive also triied the following code.
isql -w 132 -i c:\in.txt -o c\:out.txt
This gives me an error
Cant find input file c:in.txt
Ive also tried -i /in.txt
-i c:/in.txt
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098162
Have you tried using '<' redirector ?
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 

Author Comment

by:Coates
ID: 1098163
I get another error using this syuntax:
ksh: c:\in.txt:cannot open
Am i using the correct path format?
Do i use a '\' or a '/'??
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098164
What operatin system do you use?
May be obvious, but happens: is the file realy exists? Do you have permission to read it?
0
 

Author Comment

by:Coates
ID: 1098165
Im using windows 95
The file is a standard .txt file located on my c:\ directory
I am using telnet to access the Unix sybase server
isql < c:\in.txt >c:|out.txt
this is what ive just tried and got the same error!
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098166
If I correctly understood, you are trying to type this in telnet window. When you use a telnet, your computer emulates terminal, telnet doesn't know anything about your c: drive. and if you are using just in.txt this in.txt should be present not in your PC, but in the  UNIX server directory you are executing isql from.
0
 

Author Comment

by:Coates
ID: 1098167
Is there any way to use a local input file??
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098168
No , unless there  is a Windows version  of isql, that you can install and run from you PC, not from telnet session.
0
 

Author Comment

by:Coates
ID: 1098169
OK thanks!
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This article outlines the struggles that Macs encounter in Windows-dominated workplace environments – and what Mac users can do to improve their network connectivity and remain productive.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question