New Oracle Entry
The Oracle Entry Wizard will generate an Entry definition for a table from an Oracle database.
You will have to:
- Select driver
Select the ODBC driver that is used to access the Oracle Database. For user and password you have to enter an oracle account and the password for that account. Server is the name of the oracle database server. - Restrict Table Retrieval
A pre-selection for the table can be made based on the table owner or the Table/View. - Select 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.
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
After you selected the table, the wizard will show a screen with all the fields of this 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.