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
What are the features of datastage flow designer?
Where the datastage stored his repository?
How to find value from a column in a dataset?
Where do you see different stages in the designer?
How a source file is populated?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is active and passive stage?
How can one find bugs in job sequence?
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
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why do you need stage variables?
How many types of sorting methods are available in datastage?
What is ds designer?