Step 4: Define Master Index External Systems

A SQL script is automatically created to insert the systems you specified in the wizard. These statements are provided in systems.sql in the master index project. Before you begin this step, complete Step 2: Create a Master Index Database and User and, optionally, Step 3: Define Master Index Database Indexes.

To Define an External System

1. Do one of the following:

   • Under the master index project in the Projects window, expand Database Scripts and then open systems.sql in the NetBeans editor.

   • On your computer, navigate to project_home/src/DatabaseScript, where project_home is the location of the master index project files. Open systems.sql in a text editor.

2. For each system, create an INSERT statement using the column descriptions in Master Index Database Table Description for sbyn_systems to define the VALUES clause.

   For example:

   INSERT into sbyn_systems (systemcode, description, status, id_length, format, input_mask, value_mask, create_date, create_userid) VALUES (’ARS’, ’Automated Registration System’, ’A’, 8, ’[0-9]{8}’, ’DD-DDD-DDD’, ’DD^DDD^DDD’, sysdate, 'admin’);

3. Delete any default INSERT statements you do not need.

4. Save and close the file.

5. Continue to Step 5: Define Master Index Code Lists.