how can i prevent my bcp command from hanging when i have an empty
input file?

bcp %mgDATABASE%..tblMG_IntCR_Edit in dat\fmg775c.dat
-fbcpintediti.fmt -ebcpINTCi.err -U%mgDBUserBCP% -P%mgDBPwdBCP%
-S%mgDBServer% -r\n

where dat\fmg775c.dat is 0 bytes.

thanks, mark

What release of bcp and sybase are you using.

Does the bcp work with when there is data in the file?

I had no problems with 3 different releases of bcp and 3 different versions
of sybase. they all gave a similar response.
(sybase)$ bcp pubs2..authors in x -Usa -Pxxxxx -f x.fmt -r\n -SSERVERA

Starting copy...

0 rows copied.

Clock Time (ms.): total = 9


bcp/10.0.3/P/rs6000/AIX 3.2.5/4.1/1/Wed Nov 22 12:42:52 PST 1995

Sybase CTBCP Utility/11.1.1/P-EBF10537/DRV.11.1.1.1/rs6000/AIX
4.1.4/BUILD1111-026/OPT/Wed Aug 28 13:35:13 2002

Sybase CTBCP Utility/12.5/P-EBF10883 ESD#9/DRV.12.5.0.6/RS6000/AIX
4.3.3/BUILD125-026/OPT/Sun Jan 12 10:12:13 2003

"mark" <spiesmk (AT) verizon (DOT) net> wrote

Hello,

I think this may be a bug in older versions of bcp that
has been fixed. If you do a "bcp -v", what version does it report?

Newer versions of bcp are available at:
http://downloads.sybase.com

Download the latest EBF from the "Software Developer's Kit".

I just tried it and it worked fine for me. Of course, it came back
with "0 rows copied."

What version are you running?