Adding a View in database manager

The Database Manager Views tab allows the administrator to add a view definition to the database.

Note: The system administrator can only access these features. These features are not available in Oracle environments.
  1. Select Administration > Database Manager on the navigation bar. Click the Views tab. The Views list view is displayed.
  2. Click New View in the Task pane. The Create View window is displayed.
  3. Select the Expose to model check box to make the view available to create as an entity in the Application Architect Entity model. The Display Name and Description fields are enabled only if this check box is selected.
    Note:  You cannot change this option after this option is selected and saved:
    • In the Display Name, type the view name you want to be displayed in Query Builder.
    • In the Description box, type a brief explanation of purpose of the view.
  4. Specify the view SQL definition in the Definition field. The view name must adhere to the following rules required by Infor CRM SLX system.
    Note: These rules omit some items allowed by Microsoft SQL Server and some items allowed by Oracle to remain compatible with both server platforms):
    • You cannot use Microsoft SQL Server or Oracle keywords or reserved words.
    • The name must begin with a letter (A-Z). Subsequent characters can be A-Z, 0-9, (underscore), $ (dollar sign) or # (pound sign). However, Oracle strongly discourages the use of $ and #.
    • The name cannot contain embedded spaces or special characters.
    • The name can be a maximum of 128 characters long for Microsoft SQL Server, or 30 characters long for Oracle.
    • The name must be unique. View names are not case sensitive.
  5. Click Execute.
  6. Select the view you added and use the detail pane tabs to add fields once finished. See Using the Database Manager View Fields tab
Related topics