Home > Articles > Operating Systems, Server

  • Print
  • + Share This
Like this article? We recommend

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:

  • ID—data type integer, auto-increment value, unique value constraint, allow nulls = NO

  • DATA—data 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.

  • + Share This
  • 🔖 Save To Your Account