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.

Break TEXT datatype into multiple VARCHAR(255) in a single row

2 posts in Windows NT Last posting was on 2001-03-22 15:30:04.0Z
Crystal Posted on 2001-03-16 21:11:35.0Z
From: Crystal
Date: Fri, 16 Mar 2001 16:11:35 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Break TEXT datatype into multiple VARCHAR(255) in a single row
Message-ID: <FA218C4DFB9FC0BB00746AF585256A11.00746B0485256A11@webforums>
Lines: 10
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.nt:1074
Article PK: 1087676

Hi,

I am trying to convert data from Sybase into Oracle. How can I break the
TEXT datatype data across multiple VARCHAR(255) columns within a single
row? So I can use the unload utility from DBArtisan to unload the data from
Sybase into a operating system file.

Thanks for you help!

Crystal


Bret Halford Posted on 2001-03-22 15:30:04.0Z
Message-ID: <3ABA1A7B.49E9695E@sybase.com>
Date: Thu, 22 Mar 2001 08:30:04 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Crystal@sybase.com
Subject: Re: Break TEXT datatype into multiple VARCHAR(255) in a single row
References: <FA218C4DFB9FC0BB00746AF585256A11.00746B0485256A11@webforums>
Content-Type: multipart/mixed; boundary="------------40532611D8985A56F772C3BD"
Newsgroups: sybase.public.sqlserver.nt
Lines: 278
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1046
Article PK: 1087653

It happens I have a hack that does just that for ASE 11.5.x and higher.
See attached file.

Cheers,

-bret

Crystal wrote:

> Hi,
>
> I am trying to convert data from Sybase into Oracle. How can I break the
> TEXT datatype data across multiple VARCHAR(255) columns within a single
> row? So I can use the unload utility from DBArtisan to unload the data from
> Sybase into a operating system file.
>
> Thanks for you help!
>
> Crystal