Hi All,
Our Datastage jobs are got aborted couple of days becuase of this below problem.
IncLotsHashToTable..Dstage: ORA-01400: cannot insert NULL into coulmns
but As this is a not null column and since null values are trying to get inserted we are facing this problem.
in that column we did constraint level not(isnull(...like that)
even jobs are getting aborted.
How to solve this problem
Regards
srini
IncLotsHashToTable..Dstage: ORA-01400: cannot insert NULL in
Moderators: chulett, rschirm, roy
Notnull coulmn trying to insert null
Hi
we are using Constriant like
Linkname.coulmnname =0 OR Linkname.coulmnname =0 Or Linkname.coulmnname =0
is this way is possible to handle nullvalues into notnull column.
Regards
srini
we are using Constriant like
Linkname.coulmnname =0 OR Linkname.coulmnname =0 Or Linkname.coulmnname =0
is this way is possible to handle nullvalues into notnull column.
Regards
srini
Mike wrote:Oracle will interpret an empty string ('') as NULL. In DataStage an empty string is just an empty string.
Mike
Re: Notnull coulmn trying to insert null
That will not handle nulls. If you want to filter out the null values you need something likeysrini9 wrote:Hi
Linkname.coulmnname =0 OR Linkname.coulmnname =0 Or Linkname.coulmnname =0
Code: Select all
ISNULL(Linkname.coulmnname1) = 0 OR LEN(trim(Linkname.coulmnname1)) <> 0 AND ISNULL(Linkname.coulmnname2) = 0 OR LEN(trim(Linkname.coulmnname2)) <> 0 AND .....<so on>
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.