Specifications

Manipulating data
108 InfoMaker
For more about outer joins, see “Using ANSI outer joins” on page 171.
Dropping a database
view
Dropping a database view removes its definition from the database.
❖ To drop a view:
1 In the Objects view, select the database view you want to drop.
2 Click the Drop Object button or select Drop View from the pop-up menu.
InfoMaker prompts you to confirm the drop, then generates a
DROP VIEW
statement and submits it to the DBMS.
Exporting view syntax
You can export the syntax for a view to the log. This feature is useful when you
want to create a backup definition of the view before you alter it or when you
want to create the same view in another DBMS.
❖ To export the syntax of an existing view to a log:
1 Select the view in the painter workspace.
2 Select Export Syntax from the Object menu or the pop-up menu.
For more information about the log, see “Logging your work” on page 82.
Manipulating data
As you work on the database, you often want to look at existing data or create
some data for testing purposes. You might also want to test display formats,
validation rules, and edit styles on real data.
InfoMaker provides data manipulation for such purposes. With data
manipulation, you can:
• Retrieve and manipulate database information
• Save the contents of the database in a variety of formats (such as Excel,
PDF, or XML)