Batches and partitioned tables  Specifying a network packet size

Chapter 4: Using bcp to Transfer Data to and from Adaptive Server

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

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





Copyright © 2005. Sybase Inc. All rights reserved. Specifying a network packet size

View this book as PDF