New ODBC Entry

The ODBC Entry Wizard will generate an Entry definition for a table from an ODBC Data Source.

You will have to:

• Select ODBC data source
  The Wizard will present a list with all the data sources that are available on the system. You have to select one from this list.
• Restrict Table retrieval
  A pre-selection for the table can be made based on a Catalog, Schema or Table/View.
• Select a table
  The wizard will show a list of all the available tables. You must select the table for which the wizard should generate an Entry. If you type the name of the table in the 'position to' field, the wizard will automatically position the selector.
  The Wizard uses the names of the fields from the table as names for the ITP Fields. These names can be converted according to the ITP conventions, thus generating valid ITP Field names. It is also possible to use the remark of the field as ITP Field name. If the remark is empty, the wizard will still use the field name.
• Define Fields
  In this screen, the wizard will show a list with details for all Entry Fields. Here you can change the name of a Field or uncheck it. If a Field is unchecked, it will not be part of the Fields definition of the Entry. Those Entry fields that have an UNKNOWN type will default be unchecked. The fields that are marked in red should be edited to adjust their length. You can only change the other attributes of the Fields manually in the generated output.
• Select Formal Parameters
  The wizard will show a screen with all the fields of the selected table. Here you must select the fields that should be used as formal parameters. This selection can be empty. The order in which the selected fields appear in the Wizard, is not related to the order in which they appear in the Entry Definition.
  If you did select formal parameters, the wizard can optionally generate a Key Retrieval definition as well.
• Select Screen Fields (optionally)
  If you selected the option Add key retrieval on the previous screen, you can select the (optional) additional Screen Fields that ITP has to display in a Key Selection screen. When you add additional Screen Fields, the end user will be able to make an easier selection in many cases. ITP will always display the Formal Parameters that you specified for an Entry.
• Entry Attributes
  You should specify the name of the Entry. By default, the wizard will suggest the name of the table, converted to ITP conventions.You must choose whether the Entry will be singular or plural (WITH or FORALL).If you did select formal parameters, the wizard can optionally generate a Key Retrieval definition as well.
• Completing the new ODBC Entry Wizard
  Select Finish to generate the code for this entry. The generated Entry definition will be inserted at the location of the cursor in the active DID document.