Results 1 to 3 of 3

Thread: Sybase BCP in

  1. #1
    Join Date
    Dec 2001
    Location
    Pune, INDIA.
    Posts
    2

    Question Unanswered: bcp in with 'identity' column.

    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.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    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/onlinebook...p-as/asg1250e/;pt=3263
    Thanks,

    Matt

  3. #3
    Join Date
    Dec 2001
    Location
    Pune, INDIA.
    Posts
    2

    Smile

    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/onlinebook...p-as/asg1250e/;pt=3263
    Thank you MattR,
    My problem is solved after setting the appropriate flag in dboption.

    Parin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •