hi,
i have write query and having column name Dealer number as primary key and non null .
while executing the query in oracle sql developer i am not getting any null for this particular column but while using the same query in oracle connector stage running job getting aborted with below error.
Attempt to SETis null for non null able values.
i have set the nullability of this column to "NO" because this is primary key column.
i am using oracle connector stage and putting the records into sequential file
i am not using NVL function in query because i am not getting any null value and query also runs fine but job is getting aborted.
i investigate but no luck.
please help me on this.
getting null value
Moderators: chulett, rschirm, roy
Re: getting null value
In table / Datastage / BOTH?hargun wrote:i have set the nullability of this column to "NO" because this is primary key column.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Re: getting null value
in datastageSURA wrote:In table / Datastage / BOTH?hargun wrote:i have set the nullability of this column to "NO" because this is primary key column.