ASE Database forum - Bulk insert with identity column

Author

Bulk insert with identity column

Gerald Naveen A

2006-03-24, 3:28 am

I am trying to bulk insert into a table with identity column
using ctlibrary 12.5 (on Linux against ASE 12.5.3 on Linux).
Based on my learning from the net, I have made sure that

1. BLK_IDENTITY property is set to CS_FALSE 2. I dont bind
for the identity column (yes I want the ASE to insert the
value for this column) 3. The identity column is the first
column in the table (I dont know if this really a
requirement still).

But blk_rowxfer fails. I have no idea as to why it fails.
However, when I set BLK_IDENTITY to CS_TRUE, and bind a
value to the column, I am able to insert the row into the
table, but this is not what I want.

I want to insert values for the other columns and would
expect ASE to insert the value itself for the identity
column.

Is there anything I am missing here. Any help will be
greatly appreciated.

Thanks

Michael Peppler

2006-03-25, 7:45 am

On Fri, 24 Mar 2006 00:13:35 -0800, wrote:

> I am trying to bulk insert into a table with identity column using
> ctlibrary 12.5 (on Linux against ASE 12.5.3 on Linux). Based on my
> learning from the net, I have made sure that
>
> 1. BLK_IDENTITY property is set to CS_FALSE 2. I dont bind for the
> identity column (yes I want the ASE to insert the value for this column)
> 3. The identity column is the first column in the table (I dont know if
> this really a requirement still).

If I remember correctly you need to bind a NULL value to the IDENTITY
column.

Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

Sponsored Links