Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Copy in and batch files [Table of Contents] Specifying a network packet size

Utility Guide

[-] Chapter 3 Using bcp to Transfer Data to and from Adaptive Server
[-] Copy out and text and image data

Copy out and text and image data

When you copy out text or image data, Adaptive Server, by default, copies only the first 32K of data in a text or image field. The -T text_or_image_size parameter allows you to specify a different value. For example, if the text field to copy out contains up to 40K of data, you can use the following command to copy out all 40K:

bcp pubs2..publishers out -T40960

If a text or image field is larger than the given value or the default, bcp does not copy out the remaining data.

Copy in and batch files [Table of Contents] Specifying a network packet size