Suppose i have a table that contains 5 columns like col1,col2...colm5.I want t

Suppose i have a table that contains 5 columns like
col1,col2...colm5.I want to import only two column through
BCP utility.How to do same through BCP in sybase.

Question Posted / pankaj kumar

1 Answers
2506 Views
HCL, I also Faced
E-Mail Answers

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two co..

Answer / Rajnish Kumar Shriwastawa

To import only two columns using BCP (Bulk Copy Program) in Sybase, you can use the FORMATFILE option and specify the desired columns in the format file. Here's an example format file for importing only col1 and col2:

1. col1 VARCHAR(50)
2. col2 VARCHAR(50)
3. col3 BINARY(8) NULL
4. col4 BINARY(8) NULL
5. col5 BINARY(8) NULL

After creating the format file, execute the following command to import data:

bcp mydatabase.myschema.mytable in formatfile = myformatfile -c -t"," -S servername -U username -P password

Is This Answer Correct ?

0 Yes

0 No

Post New Answer