Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

isql?

Posted on 1998-07-07
10
Medium Priority
?
805 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 40 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
The online market is growing at an unprecedented rate and retail eCommerce sales are expected to reach $4 trillion by 2020. Yet, the profit is not just there for the taking because you have to set yourself apart from the competition.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

705 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