Initializing the tutorial database

Complete the previous procedures in this section. WorkSpace must be running, the SybStore tutorial files must be installed, the SybStore database must be running, and you must be connected to the database in WorkSpace using the SybStore connection profile.
Select Window|Open Perspective|Other, choose Service Development (default) from the Select Perspective dialog box, and click OK.
Execute the InitDB.sql script:
1. In the WorkSpace Navigator, expand the folder MySybStore_Tutorials/Setup/Database/SQL, right-click the InitDB.sql file, and select Execute SQL File from the context menu.
2. When the Select Profile for the Editor dialog box opens, enter these values in the dialog box:
  - Database Type – select Adaptive Server Anywhere_9.x.
  - Connection Profile Name – select MySybStore.
3. Click OK.
You see a progress window that indicates that the script is executing. When the script is finished running, you see the SQL Results view in the WorkSpace window.
Execute the testdata.sql script:
1. In the WorkSpace Navigator, expand the folder MySybStore_Tutorials/Setup/Database/SQL, right-click the testdata.sql file, and select Execute SQL File from the context menu.
2. When the Select Profile for the Editor dialog box opens, enter these values in the dialog box:
  - Database Type – select Adaptive Server Anywhere_9.x.
  - Connection Profile Name – select MySybStore.
3. Click OK.
Click the “X” on the SQL Results window’s title tab to close that view.