niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
newbie isql help
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Sashi
*nix forums addict


Joined: 14 Jun 2005
Posts: 95

PostPosted: Tue Jul 18, 2006 7:25 pm    Post subject: newbie isql help Reply with 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
Back to top
Sashi
*nix forums addict


Joined: 14 Jun 2005
Posts: 95

PostPosted: Tue Jul 18, 2006 7:40 pm    Post subject: Re: newbie isql help Reply with quote

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

PostPosted: Thu Jul 20, 2006 7:09 pm    Post subject: Re: newbie isql help Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Mon Dec 01, 2008 7:14 pm | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Newbie question: How to forward a domain to a mailbox? leei Postfix 0 Fri Aug 24, 2007 4:55 pm
No new posts newbie question Miles Fidelman Debian 6 Thu Jul 20, 2006 9:20 pm
No new posts Another newbie question Mark Rae Suse 7 Thu Jul 20, 2006 3:25 pm
No new posts again a newbie... :( compiler problems Thorsten Kaben C++ 18 Thu Jul 20, 2006 2:52 am
No new posts Newbie question: Patches on CD and burning WIn CDs BertieBigBollox@gmail.com Solaris 1 Wed Jul 19, 2006 2:15 pm

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
[ Time: 0.1352s ][ Queries: 16 (0.0605s) ][ GZIP on - Debug on ]