Up Prev Next
From: "Bob Buehler" <bob dot buehler at cpa dot state dot tx dot us>
Subject: RE: error bcp-ing into a column which does not allow nulls
Date: Feb 18 1999 9:31PM
You can look at the table definition using sp_help tablex (where tablex is
the table name). This will show you the columns defined with "not null" (0
if nulls are NOT permitted, 1 if nulls are allowed). Apparently, it is
complaining about data for the first column of your table. sp_help will show
you the column name. Then, take a look at your bcp "in" data source to see
where you have a null value as the first field.
Hope this helps.
State of Texas
Comptroller of Public Accounts
> -----Original Message-----
> From: owner-SYBPERL-L@listproc.net
> [mailto:owner-SYBPERL-L@listproc.net]On Behalf Of Ghyara, Dinyar (Tokyo)
> Sent: Wednesday, February 17, 1999 7:21 PM
> To: SybPerl Discussion List
> Subject: error bcp-ing into a column which does not allow nulls
> hi all,
> i was going through the arcives of this sybperl list and i saw that one of
> the members
> had a problem while using th bcp module. they were getting the error :
> Sybase error: Attempt to bulk-copy a NULL value into Server
> column 1, which
> does not accept NULL values.
> any ideas on how this was resolved. We are getting the same error here.