Display NULL values as empty in Teradata Studio

Teradata Studio
Enthusiast

Display NULL values as empty in Teradata Studio

How do i display NULL values as null (empty)? 

 

Under:  Preferences | Data Management | SQL Development | SQL Results View Options   i've set Display null value as:  (empty)

 

But this has no effect, nulls are being displayed as 'null'.  Using v15.12

 

Thanks

2 REPLIES
Teradata Employee

Re: Display NULL values as empty in Teradata Studio

See if there is another option located under Teradata Datatools Preferences. Some option settings are generic for the Eclipse environment, but there are more specific overrides for certain connection types.

Teradata Employee

Re: Display NULL values as empty in Teradata Studio

The Result Set Viewer preference, 'Display Null Value as' is the correct option. You will need to give it some value so blanks should work.