CODEWITHSUNDEEP
sybasebcp
Ankit Soni
Ankit Soni

Reputation: 23

BCP out binary/BLOB/TEXT data on separate file in Sybase

I want BCP out binary/BLOB/TEXT data on separate file in Sybase. How can i do this?

Thanks!

Upvotes: 0

Views: 596

Answers (2)

RobV
RobV

Reputation: 2378

It is definitely possible to BCP in/out a single BLOB value to an individual file. This requires an extra step to move the BLOB value though a temp table. In my book "Tips, Tricks & Recipes for Sybase ASE" (sypron.nl/ttr), this is described in detail, with ready-to-use scripts.

Upvotes: 1

Mike Gardner
Mike Gardner

Reputation: 6651

You can only BCP at the Table/View level, so if you wish to separate the two, you'll need to create view(s) that contain the data you wish to see, and BCP out of the Views.

Upvotes: 1

Related Questions