Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQSH Question

3 posts in Unix Last posting was on 2001-05-04 20:29:48.0Z
Carey Posted on 2001-05-01 21:26:33.0Z
From: Carey
Date: Tue, 1 May 2001 17:26:33 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: SQSH Question
Message-ID: <DBB554A7F1CB1A400075C97A85256A3F.0075C98D85256A3F@webforums>
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.unix:519
Article PK: 1092609

I have a SQSH question. I am using this tool to copy a 30 gb database from
Solaris to NT. The bcp option is this tool works well...almost.

Problem is that it works well called when 1 or 2 statements are passed in
the input file (select from \bcp pairs). However when I copy all my select
from \bcp pairs (about 1100 of them) it fails. I am not doing this in a
loop (just could not understand what the manual was talking about with the
\loop command). Anyway the command fails with a "sqsh 136 handle
exceptions: EXCEPTION: STATUS_ACCESS_VIOLATION" error. I am running this
from an nt platform. My Solaris guy wont let me install SQSH on the unix
box yet.

Any light can be shed on this?


Anthony Mandic <amandic Posted on 2001-05-03 01:01:30.0Z
Date: Thu, 03 May 2001 11:01:30 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: SQSH Question
References: <DBB554A7F1CB1A400075C97A85256A3F.0075C98D85256A3F@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <41$Xz920AHA.262@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
Lines: 13
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:511
Article PK: 1092600


Carey wrote:

> I am running this from an nt platform.
> My Solaris guy wont let me install SQSH on the unix box yet.

Why not? You can run it from your own login account and
install sqsh in your own home directory.

> Any light can be shed on this?

There more than one alternative. You could also try -
http://www.mbay.net/~mpeppler/bcptool/ Check Michael's
home page for the newer version. You could also use CIS
and copy the data over via selects.

-am © 2001


David Owen Posted on 2001-05-04 20:29:48.0Z
Sender: dowen@n-utsire.midsomer.org
Subject: Re: SQSH Question
References: <DBB554A7F1CB1A400075C97A85256A3F.0075C98D85256A3F@webforums> <41$Xz920AHA.262@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 04 May 2001 14:29:48 -0600
Message-ID: <m3ae4suabn.fsf@n-utsire.midsomer.org>
Lines: 20
User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: h24-65-229-16.cg.shawcable.net 24.65.229.16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:492
Article PK: 1092581

>>>>> "Anthony" == Anthony Mandic <amandic@*t.com.au> writes:

Anthony> Carey wrote:

>> I am running this from an nt platform. My Solaris guy wont let me
>> install SQSH on the unix box yet.


I have just started using the latest copy of Cygwin on NT (my current
client won't let me get rid of the darned NT box I have) and it is very
nice. SQSH runs under this fine and provides a lot of the functionality
that is avaialable under Unix (the history and piping seem a little flakey
and "go -x" is not supported in the binary release). If you have an
Xserver (I could not get XWin to work, but I did not try that hard since I
had a commercial one available) on your machine, you can even run everyting
within a decent windowing environment. It is very cool!

dowen
--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ