Re: newbie isql help
- From: jbrock@xxxxxxxxx (John Brock)
- Date: Fri, 21 Jul 2006 20:52:49 +0000 (UTC)
In article <1153250725.879415.311190@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
Sashi <smalladi@xxxxxxxxx> wrote:
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?
Do you have line breaks in your input command? If not that could
be the problem. I routinely cut and paste groups of SQL commands
which collectively are much bigger than 5030 characters into isql,
and it's never been a problem. I don't think any of my individual
commands are ever that big though, so maybe the limit really is on
command size, not input line size.
(BTW, I didn't know about the isql/vi thing either. Cool!)
--
John Brock
jbrock@xxxxxxxxx
.
- References:
- newbie isql help
- From: Sashi
- newbie isql help
- Prev by Date: Re: newbie isql help
- Next by Date: Re: newbie isql help
- Previous by thread: Re: newbie isql help
- Next by thread: Unused space
- Index(es):
Relevant Pages
|
