The SybStore sample database is located in the SybStore_Sample/Setup/Database folder in the WorkSpace Navigator.
Database scripts, which define schema objects and stored procedures, are located in the SybStore_Sample/Setup/Database/SQL folder.
Viewing a script file
Expand SybStore_Sample/Setup/Database/SQL in the WorkSpace Navigator.
Right-click the file name and select Open With|SQL Editor from the context menu.
Viewing stored procedures defined in the SybStore_Sample
project
In the WorkSpace Enterprise Explorer, expand the SybStore database connection profile to reveal the SybStore database icon.
Below the SybStore database icon, expand Schemas/DBA/Procedures & Functions.
The following table describes these stored procedures.
Stored procedure |
Description |
|---|---|
sybstore_able_to_restock |
Used in restock checking to obtain current and back-order threshold quantities. |
sybstore_get_next_restock_id |
Used to obtain a new restock order ID. |
sybstore_get_next_sales_id |
Used to get an ID for a new sales order. |
sybstore_prepare_restock_order |
Processes new restock order requests. |
sybstore_save_salesdata |
Saves incoming sales orders in the database. |
sybstore_update_shelf |
Creates a record when the item is restocked on the store shelf. |
sybstore_validate_salesdata |
Used to validate incoming sales data. |
