Hi.
I am trying to load data from MS-SQL to UDB. I have
created the similar table present on MS-SQL in UDB
and I did a BCP from MS-SQL .
While loading I am getting errors as its not taking
space for some of the columns. The error is
SQL3116W The field value in row "F0-1" and column "4"
is missing, but the target column is not nullable.
The columns have been declared as XXX CHARACTER(5)
NOT NULL in both MS-SQL and UDB and is having spaces
now in MS-SQL table. I checked the BCP file and
confirmed that spaces are there for the 4th column and
it is not null.
The load statement I am using is
load from xxx.out of del modified by coldel{
timstampformat="yyyy/mm/dd hh:mm:ss:uuuuuu" messages
xxx.msg replace into instance-name.xxx
Can some time tell me if there is a way to load data
from MS-SQL to UDB having some columns in the input
file for load with spaces??
Thanks.
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
