SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Interactive SQL options

output_nulls option [Interactive SQL]

Controls the way NULL values are exported.

String

Empty string

This option controls the way NULL values are written by the OUTPUT statement. Every time a NULL value is found in the result set, the string from this option is returned instead. This option affects only ASCII, HTML, FIXED, EXCEL, and SQL output formats.

• SET OPTION statement [Interactive SQL]