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 :(

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe routines in datastage? Enlist various types of routines.

581


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

540


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1921


table actions available in oracle connector?

1096


how to sort two columns in single job in datastage.

2534






How to convert RGB Value to Hexadecimal values in datastage?

3458


What is the project in datastage?

669


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

548


What could be a data source system?

579


What are the main features of datastage?

662


how many rows sorted in sort stage by default in server jobs

3559


Where do the datastage jobs get stored?

735


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2082


What is the difference between Datastage 7.5 and 7.0?

675


Where the datastage stored his repository?

618