GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Database  >  Sybase
Go To First  |  Previous Question  |  Next Question 
 Sybase  |  Question 37 of 62    Print  
What are the mandatory options required for BCP command utility?

  
Total Answers and Comments: 3 Last Update: June 25, 2007     Asked by: keerthv 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 13, 2007 14:18:34   #1  
wasim.rahaman        

RE: What are the mandatory options required for BCP co...
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 ..

 
Is this answer useful? Yes | No
June 14, 2007 06:46:51   #2  
keerthv Member Since: April 2007   Contribution: 9    

RE: What are the mandatory options required for BCP co...
Hi,

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

Regards,
keerthv

 
Is this answer useful? Yes | No
June 25, 2007 02:05:26   #3  
srihari        

RE: What are the mandatory options required for BCP co...

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]


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape