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 / datastage4you

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Quality stage?

895


options available in sequence job to run,validate?

1058


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

1856


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

804


Explain entity, attribute and relationship in datastage?

843


What are the steps required to kill the job in Datastage?

927


What is a ds designer?

846


what is flow of project?

1744


What could be a data source system?

757


If you want to use the same piece of code in different jobs, how will you achieve it?

883


What a datastage macro?

834


What is the precedence of stage variables,derivations, and constraints?

795


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2008


Define orabulk and bcp stages?

892


Differentiate between hash file and sequential file?

779