wasim.rahaman

• Jun 13th, 2007

 

ServerName, UserName, Password, InputFile, FormatFile

bcp -S ServerName - U UserName -P Password -f FormatFile < InputFile

FormatFile is also optional. It is created when bcp is run for the 1st time.


TBC ..

keerthv

 Profile Answers by keerthv Questions by keerthv

• Jun 14th, 2007

 

Hi,

Thanks, Where can i see this format file?
What are 2 typesof bcp? When can i use them?

Regards,
keerthv

srihari

• Jun 25th, 2007

 

usage: dataserver
valid options are:
-a caps_file - path to CAPs directive file
-b [size_spec] - master device size specifier
-c config_file - config file for server
-D [size_spec] - default database size specifier
-d master_dev - master device name
-e [error_file] - error log file name, default: 'errorlog'
-f f[orcebuild] - force initialization of a device or database
-G logserv_name - event log server name
-g - turn off event logging
-H - start HA server
-h - print this help message, then exit
-i interface_dir - interface file directory
-K keytab_file - keytab file name
-k s_principal - server principal name
-L [config_file] - connectivity configuration file; default: 'config'
-M shmem_dir - shared-memory-repository directory
-m - 'master recover' mode, restricted to a single user
-p sa_name - login name of SA user
-q - recover quiesced user databases as for 'load database'
-r mirror_file - master device's mirror device name
-s server_name - server name
-T trace_flag - set command-line trace flag
-u sa/sso_name - login name of SA/SSO user
-v - print version message, then exit
-w database_name - database name to rewrite
-y keypassword - password to decrypt server's private key
-Z [size_spec] - initial master database size specifier
-z page_size - server page size specifier
-X - start this server as sybmon

+++++++++++++++++++++++

usage: 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] [-v]
[-A packet size] [-J client character set]
[-T text or image size] [-E] [-g id_start_value] [-N] [-X]
[-M LabelName LabelValue] [-labeled]
[-K keytab_file] [-R remote_server_principal] [-C]
[-V [security_options]] [-Z security_mechanism] [-Q] [-Y]
[-x trusted.txt_file]