Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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 :(

Question Posted / ddayy

Answers were Sorted based on User's Feedback



hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

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

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

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

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

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

Post New Answer

More Data Stage Interview Questions

What are the steps needed to create a simple basic datastage job?

0 Answers  

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

Define oconv () and iconv () functions in datastage?

0 Answers  

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

Describe link sort?

0 Answers  

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

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

0 Answers  

What are the prerequisites for join stage

2 Answers  

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

What is use Array size in datastage

0 Answers  

For more Data Stage Interview Questions Click Here
Categories