hi everbody, i have a problem in my project.. Native Error Code: -407 "Ass

hi everbody,
i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"

hi everbody,

i have a problem in my project..
Native Error Code: -407 "Assignment of a null value to a not null column"

i have no idea, what should i do..please help :(

Question Posted / ddayy

3 Answers
6571 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / sagnik mukherjee

Hi,
You can try one thing.In the file stage where you are reading the file, there in columns metadata tab, set Null as 'Yes' for that particular column and do the same for the other stages too in that job.
Sometimes if you are getting null value from source but your column is set as 'No' for Null then this error can come.

Is This Answer Correct ?

1 Yes

0 No

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / datastage4you

Seq file can not hold the NULL value. Convert all Null values to '' in stage

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / nish

your schema contains the target column as Nullable-No.
you need to change that. Enable Yes/ Don't Know for that

Is This Answer Correct ?

0 Yes

0 No

Post New Answer