x

The Procedures button shows saved flows, procedures, and user functions. You can add flows and procedures to a process flow by dragging them from the navigation pane into the workspace. The following image shows the navigation pane with the Procedures button selected.

If you right-click a flow or a procedure or highlight one and press the menu key , a shortcut menu opens, as seen in the following image.

The following options are available:

Open

Places the flow or stored procedure in the workspace.

Edit as Text

Opens the code behind the flow in the workspace.

Note: If you change the text behind the flow, those manual changes will be lost if you edit and resave the flow in the DMC. This option is only available for a flow.

Submit

Submits the flow to the server. This option is only available for a flow.

Run

Runs the flow or stored procedure immediately.

Run Advanced

Has the following option:

• Run with Options. Runs the flow or stored procedure. The Run flow/procedure dialog box opens, as seen in the following image.

  

  Run changing defaults

  Allows you to run the flow or stored procedure with values assigned for any variables used in the flow or stored procedure, for example, in a WHERE condition.

  Run with Limits

  Allows you to set start and stop record loading limits. This option is only available for a flow.

Submit with Options

Submits the flow or stored procedure to the server to be run, with the same options available in Run with Options: Submit changing defaults and Submit with Limits. The Submit flow/procedure dialog box opens as shown in the following image.

• Do not wait for completion. Allows you to continue your work as you wait for the submitted flow or stored procedure to complete. When this option is selected an additional check box appears which allows you to specify that the flow or procedure should be run at a specified date time.
• Submit changing defaults. Prompt to override default values for variables procedure or flow, then run it.
• Submit with Limits. This option is only available for DataMigrator flows, not stored procedures. Allows you to specify the start and end of the loading records.
• E-mail Notification Condition. Allows you to specify conditions for sending e-mail. The options are:

  On Start

  When the procedure begins.

  On Completion

  When the procedure completes.

  On Failure

  Only used if the procedure fails.

  Mail To

  Field where you enter the e-mail address that the message is being sent to.

  On Completion or Failure, the e-mail message will contain attachments of the log and output from the procedure, if any.

Schedule and E-mail

Has the following options:

• Manage. Allows the schedule and e-mail notification settings for a flow or stored procedure to be changed without opening the flow, as seen in the following image.

  

  For more information about scheduler options, see Schedule Attribute Pane. For more information on e-mail notifications, see Flow Properties Pane - E-Mail Notification Attribute.

• Scheduler Agents. This report runs for the user whose ID value is stored in the sched_scan_id of a Scheduler. The Scheduler must be active to run the Scheduler Agents report.
• Scheduled Events. Opens a window that shows all jobs scheduled to run during a specified time range, as seen in the following image.

  

  The Scheduler must be active to run the Scheduler Events report.

Logs

Has the following options:

• Last Log. Shows the last log available for the selected flow or stored procedure.
• Last Output. Shows the last output, if any, for the selected flow.
• Log and Statistics. Opens the Log and Statistics dialog box that enables you to view a log or statistics report, as seen in the following image.

  

  Report Type

  Allows you to select either a log or statistics report.

  Report Range

  Allows you to select to view the last report, all the reports, or a report specified within a select time range.

  Completion Status

  Allows you to view all reports, all completed reports, all completed successfully reports, or all completed reports that contained errors.

  Run by

  Allows you to view reports for all flows, and those initiated by the scheduler or submit. This includes flows initiated from the DMC, WC, and CMRUN.

Impact Analysis

Opens a report that shows every flow or stored procedure that calls the selected flow.

Flow Report

Provides a summary of the attributes of the flow. This option is only available for flows.

Cut, Copy, Delete, Rename

Cuts, copies, deletes, or renames the flow or stored procedure.

Privileges

This option is only available if the server is started with security enabled. For more information, see Manage Privileges Dialog Box.

Source Control

This option only appears if you have a source management program configured on your machine. It has the following options:

Add/Check In

Adds or checks files into source management.

Check Out

Checks files out of source management.

Undo Check Out

Cancels a check out.

History

Provides the source management history of a file.

Properties

Opens a Properties dialog box of the selected flow or stored procedure.

x

1. Right-click Application Directories or an individual application directory and select Schedule/E-mail, Manage.

   The Select Active Schedule for Procedures/Flows in window opens, as shown in the following image.

   

2. Select or deselect the check boxes for any flow you want to make active or inactive.
3. Click Update.

x

The Synonyms button shows synonyms that describe the data. You can use them as data sources or data targets in your flow. The synonym type is listed after its name. The type of synonyms available will depend on the adapters that are configured on your server. The following image shows the active Synonyms button.

If you right-click a synonym or highlight one and click the menu key , the following options are available:

Open

Opens the synonym in the workspace. The file, segments, and columns appear on the left and their attributes and values appear on the right.

Edit as Text

Places the synonym code in the workspace where it can be edited.

Edit Access File as Text

Places a relational synonym Access File in the workspace where it can be edited. This option is not available for FOCUS files.

Create Business View

In WebFOCUS Developer Studio, enables you to create a business view of a synonym by limiting the columns available to any retrieval request that references the business view.

Note: The use of Business Views as a source in DataMigrator is planned for a future release.

Sample Data

Shows a sample of the data associated with the synonym.

Data Profiling

Provides the data characteristics for synonym columns. This selection has the following options:

Statistics

Shows the values for the selected synonym only.

Count

Key Analysis

Allows you to select the columns that you would like to analyze as potential keys to the source table.

Data Management

This selection has the following options:

Recreate DBMS Table

Deletes the data and recreates the underlying DBMS table of the synonym.

Synonyms created in Release 7.7.04 or later include information about database indexes.

Note: Use caution when using this command if the database table was created using the data description language of a particular RDBMS. Some attributes of relational database tables, including the column order and database constraints are not reflected in the synonym, and therefore, cannot be recreated.

Delete ALL Data

Deletes the data from a synonym. This is useful to clear a synonym that will be used as a data target.

Insert Sample Data

Loads the synonym with sample records (for relational and flat file synonyms). You will be prompted for the number of sample records to load into the table.

Note: If you are inserting sample data into a flat file, the synonym must contain a DATASET statement indicating where to put the data.

Quick ETL Copy

Creates a simple Data Flow that selects all rows and columns from a source table.

Impact Analysis

Allows you to assess the impact of a change to the synonym on this server and any subservers that use it. Lists all flows, stored procedures, or reports using the synonym. For data flows, it will indicate whether the synonym is used as a source or a target. Flows and stored procedures are referred to generically as procedures.

Source Control

This option only appears if you have a source management program configured on your PC. It has the following options:

Add/Check In

Adds or checks files into source management.

Check Out

Checks files out of source management.

Undo Check Out

Cancels a check out.

History

Provides the source management history of a file.

For more information regarding source management programs, see Source Management.

Cut, Copy, Delete, Rename

Cuts, copies, deletes, or renames the synonym.

Privileges

This option is only available if the server is started with security enabled. For more information, see Manage Privileges Dialog Box.

Properties

Opens a Properties dialog box of the selected synonym.

x

The Advanced button gives you finer control over the file types that appear in the navigation pane. For example, you could specify that you only want to see synonyms for the MS SQL Server tables. It also lets you restrict display to files with specified names (using wildcards) or descriptions, files modified in a specific time period or of a specified size.