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

output_length option [Interactive SQL]

Controls the length of column values when Interactive SQL exports information to an external file.

Non-negative integer

0 (no truncation)

This option controls the maximum length of column values when Interactive SQL exports data to an external file (using output redirection with the OUTPUT statement). This option affects only ASCII, HTML, and SQL output formats.

• SET OPTION statement [Interactive SQL]