Return to Navigation

Editing Matching SQL

To edit matching SQL, use the Edit Matching SQL (RB_IMP_MATCH_EDIT) component.

These topics discuss how to:

Page Name

Definition Name

Usage

Edit Matching SQL Page

RB_EDIT_MATCHING

Select a SQL statement for editing.

Edit SQL page for Data Import Page

RB_EDIT_SQL

Edit a SQL statement.

Use the Edit Matching SQL page (RB_EDIT_MATCHING) to select a SQL statement for editing.

Navigation

select Customers CRM, then select Data Import, then select Edit Matching SQL

This page enables you to view SQL statements and their processing time from the last run of the data import template. You can select a statement and edit it.

Use the Edit SQL page for Data Import page (RB_EDIT_SQL) to edit a SQL statement.

Navigation

Click the Edit button for any SQL statement on the Edit Matching SQL page.

Image: Edit SQL page for Data Import page.

This example illustrates the fields and controls on the Edit SQL page for Data Import page.. You can find definitions for the fields and controls later on this page.

Edit SQL page for Data Import page.

Use this page to cut and paste the SQL statement to Query Analyzer, tune it, and replace the SQL statement with the tuned statement.

For example, an administrator runs a Data Import job with the Keep Tables option selected. After the job finishes or terminates due to performance issues, the administrator can access this page to review the SQL statements to see how long each one took and start tuning those ones that took a long time.

When finished editing, the administrator saves the matching SQL and can rerun the same Data Import template.