TERADATA syntax version of SET ANSI_NULL ON;

Database
Highlighted
Junior Supporter

TERADATA syntax version of SET ANSI_NULL ON;

Is there a TERADATA version of the syntx 'SET ANSI_NULL ON' Thanks.

Accepted Solutions
Ambassador

Re: TERADATA syntax version of SET ANSI_NULL ON;

No, there's no need to switch it to ON because it's the default in Teradata/Standard SQL.

If you ask for 'SET ANSI_NULL OFF', there's no way to get this :-)

1 ACCEPTED SOLUTION
2 REPLIES 2
Ambassador

Re: TERADATA syntax version of SET ANSI_NULL ON;

No, there's no need to switch it to ON because it's the default in Teradata/Standard SQL.

If you ask for 'SET ANSI_NULL OFF', there's no way to get this :-)

Teradata Employee

Re: TERADATA syntax version of SET ANSI_NULL ON;

No, Teradata always follows ANSI / ISO standard for comparisons with NULL.

There is no syntax to enable (or disable) this behavior.