Statements
This chapter covers the issuing, saving and recalling of sql statements, and sql command files (scripts). It also provides information on how to assemble sql statements from the output of another sql statement. Specific instructions for running database store procedures and statement blocks are included.
Editing
The edit pane of the Sql Admin window allows for the entering and editing of sql command scripts. A command script can consist of one or more sql statements. A statement is deemed to be everything up to a terminating semi-colon. All statements in the script are executed sequentially when the 'execute/run' button is pushed. The normal Windows select, cut, paste, find and replace operations may be performed in this pane. Each line in the edit pane is terminated by a carriage return/line feed combination.