How can I use the BCP Command in Linux?

Question

I want to use the bcp command in Linux as the following:

bcp "EasyCash.dbo.user" out "[EasyCash].[dbo].[user].dat" -q -c -t "<EOFD>"
         -r "<EORD>" -Usa -P123456 -S192.168.1.5

The message in Linux shows like that:

-base bcp: command not found

Can anyone solve my problem?

Answer 1

Assuming that you have whatever package on your machine that contains the bcp executable, try typing

locate bcp | grep bin

and look at the output to see if this executable exists on your computer but is not in your path. If this does not return anything, then you are missing the executable. If this turns up something, then you can try to run it using the whole path.

Answer 2

That example sure looks like MSSQL's BCP command )(-Usa... the 'sa' user). MSSQL is a Windows only product.

Answer 3

See the Sybase ASE documentation for full details of how to install, deploy and use the bcp command. Or ask your DBA.