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.

Regarding How do I retrieve a column's data (BLOB) and... (Oct 8,2010)

2 posts in General Discussion Last posting was on 2010-11-08 23:35:55.0Z
Jeff Posted on 2010-11-08 21:13:29.0Z
Sender: 6e10.4cd8365c.846930886@sybase.com
From: Jeff
Newsgroups: sybase.public.ase.general
Subject: Regarding How do I retrieve a column's data (BLOB) and... (Oct 8,2010)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cd867f9.7942.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Nov 2010 13:13:29 -0800
X-Trace: forums-1-dub 1289250809 10.22.241.41 (8 Nov 2010 13:13:29 -0800)
X-Original-Trace: 8 Nov 2010 13:13:29 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29686
Article PK: 78916

Rob,
Thank you for the response. I used the script from your book
successfully did file transfers of all types in and out of
Sybase ASE, it replicated great, and even in to an Oracle
BLOB column while maintaining file integrity.

I have a problem... The machine that will be actually
inserting these files cannot have MKS toolkit or similar
installed (for security reasons), and thus cannot use .sh
files. I have been unsuccessfully disecting your script for
about 2 weeks now to try to manually use every command.

Can you recommend a manual technique to do it? Just a bare
machine, with ASE and REP.

Thanks again for your help,
Jeff


Rob V [ Sybase ] Posted on 2010-11-08 23:35:55.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Regarding How do I retrieve a column's data (BLOB) and... (Oct 8,2010)
References: <4cd867f9.7942.1681692777@sybase.com>
In-Reply-To: <4cd867f9.7942.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cd8895b@forums-1-dub>
Date: 8 Nov 2010 15:35:55 -0800
X-Trace: forums-1-dub 1289259355 10.22.241.152 (8 Nov 2010 15:35:55 -0800)
X-Original-Trace: 8 Nov 2010 15:35:55 -0800, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29687
Article PK: 78915


On 08-Nov-2010 22:13, Jeff wrote:
> Rob,
> Thank you for the response. I used the script from your book
> successfully did file transfers of all types in and out of
> Sybase ASE, it replicated great, and even in to an Oracle
> BLOB column while maintaining file integrity.
>
> I have a problem... The machine that will be actually
> inserting these files cannot have MKS toolkit or similar
> installed (for security reasons), and thus cannot use .sh
> files. I have been unsuccessfully disecting your script for
> about 2 weeks now to try to manually use every command.
>
> Can you recommend a manual technique to do it? Just a bare
> machine, with ASE and REP.
>
> Thanks again for your help,
> Jeff

Not being able to use a shell is pretty much crippling any type of box
IMO....
Since you mention MKS I take it this is a Windows box? You can of course
use .bat files, though they're more difficult to program than good-old
shells... But since the logic is not too complex, I guess it should be
possible. I've just never tried something like that in a .bat file --
I'm more a shell type of guy ;-) Doing it fully manually sounds like a
non-starter... too many steps to take...

Glad the script worked BTW.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------