PRSQL9103025: Cannot Use a Blank for Field Terminator with BCP

ID Number: Q70845

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103025

SYMPTOMS

The following error message is received when using the BCP

utility:

dblib error: column number out of range

CAUSE

This error message occurs when using a blank for a field

terminator within the format file.

RESOLUTION

Instead of a format file, use the -t option on the command line.

For example:

bcp dbase..table out file.out -SServer -Usa -P -r\r\n -c -t" "