|
|
|
|
|
|
| Author |
Message |
Sashi *nix forums addict
Joined: 14 Jun 2005
Posts: 95
|
Posted: Tue Jul 18, 2006 7:25 pm Post subject:
newbie isql help
|
|
|
Hi, I'm trying to run a simple SQL command thus:
$ isql -i input_file -o output_file user@host:port.
I'm using Solaris 8 as the OS and ASE 12.5.3 as the SQL server.
When I run the above command, the output file is generated but is 0
bytes. I don't see any error messages on screen.
I tried to run the command directly by logging in but my SQL command is
5030 characters long. There seems to be a limit on the size of the
command line text that can be entered.
How do I diagnose why my command file is not being accepted in the
first case?
At the isql prompt, how do I seek help for the isql commands available
to the user?
At the isql prompt, how do I specify an input file for the command when
the file is located in a local directory?
TIA,
Sashi |
|
| Back to top |
|
 |
Sashi *nix forums addict
Joined: 14 Jun 2005
Posts: 95
|
Posted: Tue Jul 18, 2006 7:40 pm Post subject:
Re: newbie isql help
|
|
|
Sashi wrote:
| Quote: | Hi, I'm trying to run a simple SQL command thus:
$ isql -i input_file -o output_file user@host:port.
I'm using Solaris 8 as the OS and ASE 12.5.3 as the SQL server.
When I run the above command, the output file is generated but is 0
bytes. I don't see any error messages on screen.
I tried to run the command directly by logging in but my SQL command is
5030 characters long. There seems to be a limit on the size of the
command line text that can be entered.
How do I diagnose why my command file is not being accepted in the
first case?
At the isql prompt, how do I seek help for the isql commands available
to the user?
At the isql prompt, how do I specify an input file for the command when
the file is located in a local directory?
TIA,
Sashi
|
Duh! I was missing a "go" at the end of my input file.
However, answers to the other questions are still welcome!
Sashi |
|
| Back to top |
|
 |
D_Peglow *nix forums beginner
Joined: 27 Feb 2005
Posts: 16
|
Posted: Thu Jul 20, 2006 7:09 pm Post subject:
Re: newbie isql help
|
|
|
Sashi schrieb:
| Quote: | At the isql prompt, how do I specify an input file for the command when
the file is located in a local directory?
|
On a Unix OS, it is always good to know some commands for the "vi" editor.
isql -U user -P bla
1> vi
In the Editor, you can do a
:r myfile.sql
!wq
2> go
So my advice is (if you not already familar with it) to learn some basic
"vi" editor commands.
Didi |
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Mon Dec 01, 2008 7:14 pm | All times are GMT
|
|
Fighting Videos | Loans | Equity Release | Secured Loans | Payday Loan
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|