Customer has requested that we add Logical Files to the view node. These files act as views yet do not have DDL statements, they are written to file using DDS syntax. We will add them to the view node so they can be accessed in the query builder and object search, but they will not have scripting support. Will add an extra column to both the tablesDetail & viewsDetail to show there types. Tables could have types [Table, Physical File] and views could have types [View, Logical File]
157 KB
The code is complete and checked in.
for testing, please make sure that the logical files show up in the views node. That they do not have GUI or scripting support via the menus. If you attempt to select multiple objects, the logical files should not show up as scriptable objects. Schema script generator should not load logical files as objects when [views] are selected. In the object search windows, logical files will be found when searching for views. In the query builder, logical files should be accessible in the views box.
Logical Files is a database file that logically represents one or more physical files. Logical files do not contain data records, but they define record formats. The data records are contained in the physical files associated with the logical files.
Verified in ADS v16.0.1-11. Now the logical files appear in autocompletion as well.
@ivan: can you port to v17 as well ? Everything looks fine now
Verified in ADS v16.0.1-11. Now the logical files appear in autocompletion as well.
@ivan: can you port to v17 as well ? Everything looks fine now
Issue #13186 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.1-10 |
No time estimate |
The code is complete and checked in.
for testing, please make sure that the logical files show up in the views node. That they do not have GUI or scripting support via the menus. If you attempt to select multiple objects, the logical files should not show up as scriptable objects. Schema script generator should not load logical files as objects when [views] are selected. In the object search windows, logical files will be found when searching for views. In the query builder, logical files should be accessible in the views box.
Logical Files is a database file that logically represents one or more physical files. Logical files do not contain data records, but they define record formats. The data records are contained in the physical files associated with the logical files.