Creating Database Projects with SQL Anywhere Studio, Part 1 - Interactive SQL
(Page 6 of 6 )
In this section, another important tool, the Interactive SQL will be explored. SQL Queries, stored procedures, etc. can be interactively run using this tool. Examples of creating and running queries and stored procedures will be shown. Clicking the shortcut, Interactive SQL brings up the earlier shown "Connect" dialogue, wherein you enter the authentication information.

Once the authentication is verified, the SQL designer window opens up with its own menu bar, a tool bar, a SQL pane, and a Results pane. The SQL, Data,Tools, and Help menu are used for various database connected activties. These can be seen in this next picture.

The important menu items are shown in the next picture. Some of them may be available from the tool bar as well. From the tools menu it is possible to look at the tables, stored procedures, indices, etc. In the SQL Statements pane, the queries/procedures will be coded and they can be executed by hitting the "run" button. The results of executing the queries are shown in the Results pane.

The Lookup Table functions very much like an object browser, and the column names can be obtained before coding the queries. The Lookup Table dialogue shows all the tables. This can be drilled down further for the columns and other items.

Here is an example that illustrates running a simple query. The query is typed into the SQL Statements pane and, after executing the query, the results are shown in the results pane.

Further filtering of the query yields Customers from "California" as shown here.

Query errors are shown with the error information and line at which error occured.

Error is removed and the query is executed again.

Stored procedures are are also coded and executed similarly. The next screen shows a stored procedure 'test' being coded and executed.

This creates a stored procedure object with the same name in the Sybase Central administrative pane as shown here and in the following the result of executing this stored procedure.


Concluding Remarks
Adaptive Server Anywhere download and installation is easy and fast. Database management is easily accomplished in the Sybase Central management console. This server appears to be superior to MSDE --which has approximately the same database size capacity, does not have a visual interface for database management, and is limited to Windows only platform.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |