Change the Defaults in Interactive bcp

If you do not specify native (-n) or character (-c) format, bcp prompts you interactively

The default values for these prompts produce the same results as using the native format, and provide a simple means for copying data out of a database for reloading into the SAP ASE server later.

If you are copying data to or from the SAP ASE server for use with other programs, base your answers to the prompts on the format required by the other software.

These four prompts provide an extremely flexible system that allows you either to read a file from other software or to create a file that requires little or no editing to conform to many other data formats.

• Respond to bcp Prompts
  Unless you supplied bcp with the -P parameter, it prompts you for your password when you copy data in or out using the -n (native format) or -c (character format) parameters.
• File Storage Type
  The file storage type prompt offers you choices about how to store the data in the file.
• Prefix Length
  By default, bcp precedes each field that has a variable storage length with a string of one or more bytes indicating the length of the field, which enables the most compact file storage.
• Field length
  In almost all cases, use the bcp default value for the storage length while copying data out.
• Field and Row Terminators
  Use a terminator to mark the end of a column or row, separating one from the next. The default is no terminator.