Example - Simulate the Occurrence of Initial Events

Run part of the Event_Studio_ELM_Agent_Modify_GOSALES.sql script to simulate data changes.

The data changes include the following:

  • change the date to the current date
  • change the follow-up code to -1 in four records.

    A code of -1 indicates that follow-up is required.

Procedure

  1. In SQL Query Analyzer, from the File menu, click Open.
  2. Go to c10_location/webcontent/samples/datasources/sqlserver and double-click the Event_Studio_ELM_Agent_Modify_GOSALES.sql file.
  3. In the toolbar, from the list of databases, click GOSALES.
  4. In the Query window, under Part 1, select all sixteen lines of code.
  5. From the Query menu, click Execute.

Results

The database is updated with the changes.