The NovoMotion Base Schema Generator is used to generate a base schema. Once generated, the schema can be viewed or modified from the NovoMotion Schema Editor.

The Generator allows for the entry of a base file and a range of attributes. A schema is then generated for that range - with attribute 0 as the primary key. Only those attributes that are single-valued are included in the primary schema. It has the name of Filenamexxxx_auto.

The Generator also creates a separate schema for each multi-valued set in the range. The operator is asked if they want to include set elements outside of the entered range. Each generated set has the name of FilenameSetname_auto. The primary key for the set is defined as the controlling attribute of the set.

Note: Standalone multi-valued attributes are skipped by both the single-valued and the multi-valued processes. Standalone multi-values need to be evaluated and are usually handled in one of the following ways:

• An I-descriptor is created that swaps the multi-values with a space and then a varchar type attribute is tied to that I-descriptor in the schema. This is most often used for a description or comments.

• An I-descriptor is created that extracts each multi-value up to n values. Each I-descriptor is then sent as a separate char type attribute as part of the schema. This method is often used for address fields.

• An I-descriptor is created to take a specific number of characters and only send through that number of characters.

The schema creator takes the base file entered (UniData File name on screen) and builds a schema using the name entered (Schema Name) in the screen for the range of dictionaries specified (Starting Dict and Ending Dict).

Regardless of the range selected, attribute 0 is also included as the primary key of the new base schema.

Each muti-valued set (other than the standalone sets described above) is generated with the set prefix entered (Set Prefix) with additional components of the schema name entered and the specific set being processed. If the Include full Sets field is set to Y, any additional elements of the set found outside of the entered range are also included.

The Include Action toggle is used to specify if the @ACTION keyword is to be added. @ACTION is used for SQL tables that can have inserts, deletes, or changes. For a SQL table that only does inserts (like the Sales Analysis file), the @ACTION is not needed.

The Include Multi toggle is used to indicate that sets should include the @MULTIVALUEID. When this option is set, the primary key of any set is defined as attribute 0 of the U2 file along with controlling dictionary of the set.

The Additional Dicts field is used to enter fields outside of the range or I descriptors that also need to be included.

The Function Names information is used as a way to chase down dictionaries (including I-descriptors) from a specific paragraph without having to manually enter them in the Additional Dicts field. Any function names entered are investigated to find a list of dictionaries to add to the schema. The dictionaries found are then displayed in the Additional Dicts. The user can then leave the dictionaries selected or remove those that are not needed from the Additional Dicts field prior to ending out of the function.

The Function Module is used as a way to specify a grouping of Function Names to investigate en masse. The module is used to find all the dictionaries (including I-descriptors) for the File Name entered. The dictionaries found are then displayed in the Additional Dicts. The user can then leave the dictionaries selected or remove those that are not needed from the Additional Dicts field prior to ending out of the function.

NovoMotion Outbound Menu