bcp command help

Shell Programming and Scripting
1

Hi,

   When i execute a script in unix, the result i got is ::
        ./purgeErrors.ksh[24]: bcp:  not found

      What is the meaning of that output ?

--- Aditya

2

check cp command where you used inside the script ..
That might be wrongly bcp

3

Hi,

BCP is bulk copy utility , which is used insert the large volume of data into microsoft SQL server.

4

probably bcp is not available for you or it is not in the PATH variable.
check out where it is located and export the PATH including that.
or use the absolute path.

5

Thank you ....

---------- Post updated 04-29-10 at 12:03 PM ---------- Previous update was 04-28-10 at 03:02 PM ----------

Is bcp command-line utility applicable to transfer data from all databases to a file or is it some databases only ??

6

all the database has its own flavour of bcp utility.

in your script use the absolute path of the bcp command

7

how can i find the absolute path of the bcp command ??

8

trpe

whereis bcp
9

you can simply use find command.

find / -name "bcp" -type f 2>/dev/null

if you fail to find, ask you system admin/seniors to make sure whether it is available on your system.

10

which bcp