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 :(
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 |
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
What is container and then types?
How and where you used hash file?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
how to identifie,is it innerjoin,leftouter join in lookup?
What is the use of Row generator stage?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
Explain datastage architecture?
What is APT_DUMP_SCORE?
How the ipc stage work?
How can we do null handling in sequential files