how to handle low values?

Database
SN
Enthusiast

how to handle low values?

hi,

is there a way to check for a low(non-ascii) values in the file and replace them with a default value while loading into a table?

thanks
2 REPLIES

Re: how to handle low values?

hi,

It is possibile to avoid low value thro MLOAD utility. In INMOD program u can have a check for low value and move the default value in case of low value.

If Column-Name = LOW VALUE
Move zeros to Target-Column
Esle
Move Column-Name to Target-Column
End-If.
SN
Enthusiast

Re: how to handle low values?

hi prasanna, thx for your reply.
any suggestions how I can acieve the same using sql?

thx