Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7656 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 we create rank using datastage?what is the meaning of rank?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
how to sort two columns in single job in datastage.
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
How do u view log file for a particular job?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What is ibm datastage?
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?
How do you import and export data into datastage?
on how many columns we can perform aggregation in the aggregator stage?
what r the stages mostly used in realtime scenarios
Teradata 
