OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Objects in OneData | Creating An Object For A View | Best Practices for Creating a View
 
Best Practices for Creating a View
Use the following guidelines when creating a view:
*Use a prefix or suffix to distinguish the view from the physical table. For example, for the table, Product, you can create a view with the name Product_VW.
*While creating views, use specific columns rather than using the an asterisk (*) operator. In this case, if you expand the tables used in the view, the view is not affected.
*For a column that has default value in the base table, you must configure the corresponding column in the view as non-editable.
In the view, if the column with a default value in the base table is editable and a user enters a value in it, the column will not retain the new value. Instead, it holds the default value.
*You can use the Define > Structures > Run DDL function in OneData to create a view. This way the DDL is logged in OneData.
*Before creating a view using Run DDL, verify the SQL used to create the view.
You can verify the SQL, by executing a report in OneData by Use Free-Hand method and providing the Select part of the create view statement.