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 / 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 |
Post New Answer View All Answers
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is 'reconsideration error' and how can i respond to this error and how to debug this
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Explain datastage architecture?
How many types of stage?
Nls stands for what in datastage?
Which algorithm you used for your hashfile?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what is the difference between == and eq in UNIX shell scripting?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many types of hash files are there?
How do you import and export the datastage jobs?
how to write server Routine coding?
What are iconv and oconv?
How many types of sorting methods are available in datastage?