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
Have you have ever worked in unix environment and why it is useful in datastage?
What is the precedence of stage variables,derivations, and constraints?
What are the features of datastage flow designer?
What are the types of containers and how to create them?
What are the important features of datastage?
whom do you report?
How to RD using transformer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How do you start developing a datastage project?
Explain connectivity between datastage with datasources?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain how a source file is populated?
Define data aggregation?
How many areas for files does datastage have?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys