Use the SPREAD statement to specify whether or not the output is in spreadsheet format when the file type is SQL.
- Server
- This setting applies when format is output from the server.
- Client
- This setting applies when format is output from the client.
Syntax
.-SPREAD FALSE------. >>-+-------------------+--------------------------------------->< '-SPREAD--+-TRUE--+-' '-FALSE-'
Parameters
- TRUE
- Specifies the output is in spreadsheet format.
- FALSE
- Specifies the output is not in spreadsheet format. This is the default.
Examples
Format the output to spreadsheet
format:
SPREAD TRUE