bcp
Description
Copies a database table to or from an Operating system file in a user-specifIEd format. bcp is located in $Sybase/OCS-12_5/bin.
In Windows NT, the utility is bcp.exe, and is located in %Sybase%\OCS-12_5\bin.
bcp
Description
Copies a database table to or from an Operating system file in a user-specifIEd format. bcp is located in $Sybase/OCS-12_5/bin.
In Windows NT, the utility is bcp.exe, and is located in %Sybase%\OCS-12_5\bin.
Syntax
bcp [[database_name.]owner.]table_name [:slice_number] {in | out} datafile
[-m maxerrors]
[-f formatfile]
[-e errfile]
[-F firstrow]
[-L lastrow]
[-b batchsize]
[-n]
[-c]
[-t fIEld_terminator]
[-r row_terminator]
-U username
[-P passWord]
[-I interfaces_file]
[-S server]
[-a display_charset]
[-q datafile_charset]
[-z language]
[-A packet_size]
[-J clIEnt_charset]
[-T text_or_image_size]
[-E]
[-g id_start_value]
[-N]
[-X]
[-M LabelName LabelValue]
[-labeled]
[-K keytab_file]
[-R remote_server_principal]
[-V [security_options]]
[-Z security_mechanism]
[-Q]
Or
bcp -v
Parameters
database_name
is optional if the table being copIEd is in your default database or in master. Otherwise, you must specify a database name.
owner
is optional if you or the Database Owner owns the table being copIEd. If you do not specify an owner, bcp looks first for a table of that name that you own, and then looks for one owned by the Database Owner. If another user owns the table, you must specify the owner name or the command fails.
vIEw_name
is the name of the vIEw you are copying out.
table_name
is the name of the database table to copy. The table name cannot be a Transact-SQL reserved Word.
Partition number partition_number does not exist in table table_name.
slice_number
is the number of the slice of the database table to copy.
partition_id
is the identifIEr of the partition into which to copy.
