Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

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.

Bob Buehler
State of Texas
Comptroller of Public Accounts

> -----Original Message-----
> From:
> []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.
> thanks
> dinyar