Creating CONNX View in the CONNX Data Dictionary Manually
1. Launch CONNX Data Dictionary.
2. In the Open dialog box, select a CDD from the list, and click Open.
3. The CONNX Data Dictionary Manager window appears. Click Add.
4. Type a name for the view in the SQL Object Name text box in the Enter the Name of the New Table or View dialog box. Do not use spaces or symbols in the object name. Select View in the Object Type list box, then click OK.
5. The CONNX Data Dictionary Manager window appears. In the View Properties tab, type an SQL statement, and click Syntax Check.
The results of the SQL statement appear on the View Properties tab. In the View Columns tab, the selected columns are listed along with their SQL data type and column length.