Handling NULL values in the data

Database
Enthusiast

Handling NULL values in the data

Hi -

Can you please help how to handle below situation in teradata...

There are some records from the source whoch has NULL in the data itself ....for example

John is from teraNULLdata corpNULLoration

when i am trying to load these through mload its failing.I am able to find these NULL when i open the file in notepad ++

Thank you

John

4 REPLIES
Enthusiast

Re: Handling NULL values in the data

If the file is in unix, I could have done sed:

example: sed -e 's/NULL//g'? Can you try this before really impementing, if it is good for you.

Enthusiast

Re: Handling NULL values in the data

Thanks raja ....I did try doing sed on the file and it worked but just want to know is there any way that we can handle in teradat code.

--John

Enthusiast

Re: Handling NULL values in the data

John,

Have u tried loading data by specfying fixed width of the columns

Enthusiast

Re: Handling NULL values in the data

I think i am good we did sed for one time but the source team is fixing the file...Thank all