set headsep
–identifies a single character to split a title onto two or more linesttitle
–Top Titlebtitle
–Bottom Titlecolumn
–Heading and format of a columnbreak on
–Spaces between the sectioncompute sum
–Calculate subtotalsset linesize
–Set the maximum number of characters per lineset pagesize
–Set the number of lines per pageset newpage
–Set the number of lines between pagesspool
–Move screen I/O to file I/Oset pause
–Makes screen display stop between pagessave
–Save an sql query to filehost
–Sends commands to the host operating systemstart
–Execute sql from a fileedit
–Edit sql stored in a filedefine_editor
–name the editor
Example:
column {field name} heading 'Enter Column Description'
format ann | 9990.99 truncate | word_wrapped
Other Commands
list
–Outputs the contents of the SQL Bufferclear buffer
–Removes the contents of the SQL Bufferappend
–Add contents the end of the SQL Bufferc{search pattern}{replace pattern}
–Changes a search pattern with a replace pattern for the SQL Buffer.
Running SQL Statements
connect user/password@host
;
or / ->
to run SQL
@filename ->
run the SQL in a file