Sybase BCP in [Archive]

View Full Version : Sybase BCP in

Parin Vora

12-25-01, 06:57

Hello,
I am facing a problem with bcp in. It would be a great help if you can provide some tips to solve it.

I am having a table created as :
create table TAB1 (id numeric(6,5) identity, data text);go;
when I execute bcp in to enter a file's contents in the text field, it gave an error saying "you are using a non-logged version of bcp".
BUT
if I created the table as :
create table TAB1 (id numeric(6,5) Primary Key, data text);go;
then the bcp executed fine and gave no error.

Please tell me how to do it with the former table.

thanks,
Parin Vora.

MattR

12-25-01, 12:40

You may need to SET IDENTITY_INSERT tab1 ON
before performing the BCP.

I've been looking through the Sybase manuals and I can't find that error message. Take a look here:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/;pt=3263

Parin Vora

12-27-01, 04:10

Originally posted by MattR
You may need to SET IDENTITY_INSERT tab1 ON
before performing the BCP.

I've been looking through the Sybase manuals and I can't find that error message. Take a look here:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/;pt=3263

Thank you MattR,
My problem is solved after setting the appropriate flag in dboption.

Parin.