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 :(
- 3 Answers
- 7236 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how can u connect the client system directly at any time?
With out using Funnel Stage, how to populate the data from different sources to single target
What is a merge in datastage?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Why fact table is in normal form?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
What is the difference between server job and parallel jobs?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
how many stages are there in Datastage... Please clarify mee??
Teradata 
