Differences

This shows you the differences between two versions of the page.

--- novo_motion_novo_gen.schema [2011/03/16 18:05] – novowiki
+++ novo_motion_novo_gen.schema [2021/02/05 16:20] (current) – dlm
@@ Line 1: / Line 1: @@
-{{file_jo_novo_logo_verbage3.gif}}
+[[main_page|NovoMotion Outbound Menu]]
+====== NovoMotion NOVO.GEN.SCHEMA ======
+The NovoMotion Base Schema Generator is used to generate a base schema. Once generated, the schema can be viewed or modified from the [[novo_motion_schema_editor|NovoMotion Schema Editor]].
-===== **NovoMotion NOVO.GEN.SCHEMA** =====
+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 NovoMotion Base Schema Generator is used to generate a base schema. Once generated, the schema can be viewed or modified from the [[novo_motion_schema_editor]].
+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.
-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.
+**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:
-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 multivalued 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:
@@ Line 33: / Line 28: @@
-  * An I descriptor is created to take a specific number of characters and only send through that number of characters.
+  * An I-descriptor is created to take a specific number of characters and only send through that number of characters.
-INSERT SCREEN SHOT
+{{:file:novo_gen_schema1.jpg|}}
-The schema creator takes the base file entered (UniData File name on screen) and builds a schema using the name entered (Schema Name) in on the screen for the range of dictionaries specified (Starting Dict and Ending Dict).
+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**).
@@ Line 49: / Line 44: @@
-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.
+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 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 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 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 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.
-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.
+\\
+[[main_page|NovoMotion Outbound  Menu]]