Product Home Page | Developer Site | Version | |
Use the following procedure to execute SQL statements.
To execute SQL statements
Open DBMS using the URL provided by your Sun ONE ASP administrator.
Do one of the following:
To execute an existing SQL statement, click the words SQL Statements in the left pane, and then click Execute in the right pane in line with the SQL statement you want to execute.
You can also click a specific SQL statement in the left pane, and then click Execute in the right pane.
- or -
To add and execute a new SQL statement at the same time, perform the procedure described in Adding SQL Statements.
After clicking Execute to run the query, results are returned to the Query result box in the right pane as either a recordset or a message.
If the query returns a recordset, the result is listed by pages. Otherwise, a message of some type displays. If the query is unsuccessful, an error message displays.
Note | The #shown box displayed with query results specifies how many records should be displayed. This number is set to 20 by default. To see a different number of records, change the number in the box and then click Refresh. If the total number of records exceeds the number shown, use the navigation buttons (< > symbols) in the lower right corner to navigate through the records. Clicking << or >> takes you to the first or last set of records. Records are displayed in increments of the number in the #shown box. |
See also:
Copyright © 2003 Sun Microsystems, Inc. All rights reserved.