bcp provides two command-line options that create files with frequently used default formats. These options provide the easiest way to copy data in and out from Adaptive Server.
The -n option uses “native” (operating system) formats.
The -c option uses “character” (char datatype) for all columns. This datatype supplies tabs between fields on a row and a newline terminator, such as a carriage return, at the end of each row.
When you use the native or character options, bcp operates noninteractively and only asks you for your Adaptive Server password.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
