BCP out a table with an identity column

[tusker]

I have a table with an identity column, how can I unload this table with the bcp command.

I get the following error message:

DB-LIBRARY error:
Unknown variable-length datatype encountered.

Regards
Malkit

 

[grega]

The identity column shouldn't be a problem. What is the "unknown datatype"? Can you post a schema of your table?

Greg.

 

[tusker]

Name Owner
Type
------------------------------ ------------------------------
----------------------
malkit dbo
user table

Data_located_on_segment When_created
------------------------------ --------------------------
default Mar 5 2002 1:39PM

Column_name Type Length Prec Scale Nulls Default_name
Rule_name Identity
--------------- --------------- ------ ---- ----- ----- ---------------
--------------- --------
cust_ac_no char 8 NULL NULL 0 NULL
NULL 0
sms_account_no numeric 4 7 0 0 NULL
NULL 1
Object does not have any indexes.
No defined keys for this object.
Object is not partitioned.

(return status = 0)
1>

 

[tusker]

The problem was that the $SYBASE variable is pointing to /sybase/syb492 (A REALLY old version). The bcp binary for this version cannot handle certain datatypes (they didn't exist in 4.9.2!!),

/sybase/syb113/bin/bcp