Hi
I am trying to run a bcp command to import data into a sybase database from a perl script. I have a text file which I create as tab delimited and I use the following command to perform the import bsb in perl :
print `bcp dbname..table in filename -c -eERR -Sserver -Uuser -Ppwd`;
The bcp fails after 11197 rows (there are 12464 in the file) each time which the error :
Unexpected EOF encountered in BCP data-file.
When I execute the same command on the same file fom command line in UNIX the bcp runs error-free and imports into the table.
Any ideas on why it is causing problems when trying to run it through perl???
THANKS!!
I am trying to run a bcp command to import data into a sybase database from a perl script. I have a text file which I create as tab delimited and I use the following command to perform the import bsb in perl :
print `bcp dbname..table in filename -c -eERR -Sserver -Uuser -Ppwd`;
The bcp fails after 11197 rows (there are 12464 in the file) each time which the error :
Unexpected EOF encountered in BCP data-file.
When I execute the same command on the same file fom command line in UNIX the bcp runs error-free and imports into the table.
Any ideas on why it is causing problems when trying to run it through perl???
THANKS!!