test

Developing Sun Master Indexes

ProcedureTo Customize Common Table Data for Oracle

  1. Do one of the following:

    • Under the master index project in the Projects window, expand Database Scripts and then open codelist.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 codelist.sql in a text editor.

  2. Scroll to the following line.


    codes tCodeList := tCodeList(

    The statements following this line must be customized.

  3. In the first code list stanza, change “module description” in the first line to a brief description of the code type.

    For example:


    -- ****         PHONTYPE   ****
tCode(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’),

  4. Create the entries for the module using the following syntax:


    tCode(’V’, ’code’, ’code description’),

    where “code” is the processing code of the data element and “code description” is the description of the element as you want it to appear on the Master Index Data Manager windows. For example:


    -- ****         PHONTYPE   ****
tCode(’L’, ’PHONTYPE’, ’TELEPHONE TYPE’),
tCode(’V’, ’H’, ’HOME’),
tCode(’V’, ’C’, ’CELL’),
tCode(’V’, ’F’, ’FAX’),
tCode(’V’, ’O’, ’OFFICE’),
tCode(’V’, ’HB’, ’HOME BUSINESS’),

  5. Repeat the previous two steps for each code list type defined in the file.

  6. If you specified additional code list fields in object.xml and midm.xml after the database scripts were generated, add a new stanza for each new code type.

  7. In the last code module stanza, make sure each line except the last contains a comma at the end.

    For example:


    -- ****         ADDRTYPE   ****
tCode(’L’, ’ADDRTYPE’, ’ADDRESS TYPE’),
tCode(’V’, ’H’, ’HOME’),
tCode(’V’, ’B’, ’BUSINESS’),
tCode(’V’, ’M’, ’MAILING’)

  8. Save and close the file.

  9. Do one of the following: