Download User`s Guide

Transcript
SQL Data Manager Tasks
Note that you must use the pound sign as the statement
delimiter in Query Pane if you create stored procedures.
Stored procedures use the semicolon as a statement
delimiter within the procedure itself.
b. Click File New SQL Query or click .
If Query Pane contains statements that have not been saved,
you are prompted to save them. Click Yes to save the
existing statements, specify a file name and location, then
click Save. Click No to discard the existing statements.
Any SQL statements in Query Pane are cleared and the
statement indicator is positioned at the top left of the pane.
The indicator is the yellow arrow
.
c. Use Query Builder to build a statement. See “Query Builder
Tasks” on page 6-41.
If execution stops because of an error, the statement indicator
positions to the statement that was being run when the
interruption occurred. Also, the Text Results tab lists the
statement that was last run. Knowing the last statement run can
help you troubleshoot the problem. See “To continue running
SQL statements that were stopped” on page 6-57.
³ To close a database
1
Click File Close Database.
2
Click Yes to confirm that you want to close the database.
Note that the title bar no longer shows the name of an open
database or the name of a machine on which the database
resides. In addition, the commands and icons for running a
query become inactive (grayed out). You can run a query only if
a database is open.
³ To change data with Grid Results grid
The Grid Results grid must be active before you can change values in
cells. See “To set Grid Results to allow changes to database data” on
page 6-58.
6-45