Prepping the Database
After downloading and installing Sybase SQL Anywhere Studio 8.0, I opened the Sybase Central tool and selected Create Database from the Adaptive Server Anywhere 8 Utilities. After selecting a location to store the file (I named it statcalc.db) and a few other database options, my StatCalc database was empty, but ready to go! I then created a connection to it within Sybase Central (using the default username dba and the default password sql) and our StatCalc database was up and running. For this example, I then created a single table named STATDATA with two columns:
IDdata type integer, auto-increment value, unique value constraint, allow nulls = NO
DATAdata type double, allow nulls = NO
I should note here that I relied heavily on the Sybase Central GUI tool and its wizards to do the heavy lifting. SQL Anywhere Studio also includes a number of command-line utilities for accomplishing the same tasks. All DML tasks can also be accomplished using the dbisql Interactive SQL tool.