Flyspeed SQL Query: How to configure your SOSDATA connection

Flyspeed is a general purpose query tool that is compatible with SOS’s Sybase SQL Anywhere database, as well as most other popular databases, such as Microsoft SQL Server. It provides structure that will be welcome to those who are new to SQL, as well as to those who are SQL experts.  Flyspeed is free, but if you would like to print or export the results of your queries you will have to purchase a $29 license. See http://www.activedbsoft.com/overview-querytool.html for more details.

Once you have your copy of Flyspeed, just follow these steps to get started:

  1. Make sure that you have followed the instructions in http://www.sosoft.com/queries/how2010/ or http://www.sosoft.com/queries/how2009/ (depending on the version of SOS you are using). Do a simple query using the SOS-provided DBISQL utility to be sure everything is working: SELECT * FROM PATIENTS for example.
  2. Now start up Flyspeed.
  3. Select Connection > New Connection from the menu at the top of the screen to launch the New Connection Wizard.

    SNAGHTML12d8e21

  4. On the Database Server window, select "Generic ODBC Connection" as the Connection Type. For SQL Syntax, select "Sybase". A third field, Server version, will appear. Make sure it says "Sybase ASA" (NOT "Sybase ASE"), then click Next.

    SNAGHTML15be018

  5. On the Connection properties window, select the first option, System/User DSN, and type or select SOSDATA. If you are on a secure workstation, you can add your SOS login ID and, optionally, password so that you can connect without having to enter your credentials each time. Be sure to type your password in all UPPERCASE. If, and only if, your workstation is secure and not located in a public area, you may check the Save password option. Click Next.

    SNAGHTML137cc2a

  6. Finally, give the connection a name, such as "SOS", and click Finish. You will see your connection listed in the pane on the left. Click the little plus to the left of the connection name to expand it. You will see a folder in which you can save your queries and other folders containing all the base tables and views in the SOSDATA database. If at some point you want to query other databases you may have on your network, they can be added in a similar fashion. In the screenshot below you will see several of the other databases running here at SOS in the list.

    SNAGHTML1453baf

  7. To start working on your first query, click the New Query button in the toolbar at the top.

    SNAGHTML148d2a0

  8. Next, click the Add Object button in the toolbar to select the tables, views, or both for your query. Ignore the system objects and scroll right until you see items that you recognize, starting with "AdjustX" (adjustment explanations) in the tables, and "AGINGBYSORTCODE" in the views. As soon as you select the first one, you will see your query start to take shape in the worksheet. If you add more than one object (table or view), drag from a field in one object to the appropriate field in a second object to create a JOIN to link the two. You can change the type of JOIN by right-clicking on the line that will appear between the two objects.

    SNAGHTML14e03ed

    SNAGHTML154d889

  9. Click the checkboxes next to the columns/fields you want to output in your query, and configure your filter conditions in the middle pane of the worksheet.

That should be enough to get you started. There is no way for you to damage the database, so feel free to experiment.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.