Show TOC

Procedure documentationViewing the Databases

Procedure

The store component applications place captured data into two SQL databases: backoff.db and journal.db.

The majority of issues revolve around the backoff.db file as it is the larger database that contains all the tables surrounding the data flow. Any requests from the POS or Store Manager generally access one or many tables within the backoff.db file. The journal.db file contains journal data (organized for searching and reporting) and signature images (stored if using a signature capture device). In order to view the information within the tables of a database, a tool such as SQL Central must be used.

  1. To open SQL Central, on the Windows task bar, click Start, point to Programs, then Triversity Inc., and then SQL Central.

  2. On the Sybase Central menu bar, click Connect.

  3. On the next dialog box, in the UserID field, type DBA. In the Password field, type SQL.

  4. If the database has already been started before opening SQL Central, click OK to automatically connect to that open database at this time. If there are no databases currently running, click Browse to specify the path and filename of the database to which you wish to connect.

    Note Note

    Remember that the backoff.db and journal.db files are stored, by default, in c:\Program Files\Triversity Databases\.

    End of the note.

  5. Click OK to complete the connect process. The database connect is successful if the database name appears in the Sybase Central window, beneath the Utilities folder.

  6. Click the + sign to the left of the database name to expand and view its contents.

  7. Click the + sign to the left of backoff (dba) to view the various folders within the backoff.db database.

  8. Click the + sign to the left of the Tables folder to view the names of all the tables within the backoff.db database.

  9. To view the data within a given table, right-click the desired table, and select View Data from the drop-down list.

    After you choose to view the data, the Interactive SQL (ISQL) application appears in a new window.

    • The upper portion of the window displays all the fields and records for the selected table.

    • The middle portion of the window displays the statistics for the selected table, such as number of rows and amount of time to open the table.

    • The lower portion displays the actual SQL command used to perform the action requested.