Using the Load Request Editor

Use the Load Request Editor to design or edit a load request to be used for load processing.

Resource Estimation

As you design or modify a load request, you can use the resource estimator to calculate the storage needed to process the load request. From the Load Request Editor, click Tools > Estimate Resources to calculate the amount of storage needed for the conversion process and create a Resource Estimation Report. Generally, you might want to run the resource estimator offline or during nonproduction times to prevent possible resource contention issues.

Editor

Load Request Editor. The elements of the Load Request Editor are described in the following text.
Description
Optional text of up to 40 characters to identify the load request.
Tabs
Tabs in the Load Request Editor group parameters and options needed to design and maintain load requests. Each tab in the editor serves a unique purpose.
General
Specifications for running DBMS loaders. Each time you open the editor, the General tab is shown first.
<DB Alias>
A tab for each DB alias required to connect to tables referenced in the table map.
Age Function
Default parameters for optional aging of dates in columns for which an age function is indicated in a column map.
Global Aging
Default parameters for optional aging of dates in columns that have a native data type.
Currency
Default currency table and currency conversion parameters for columns with a native currency data type.
Report Options
Parameters for displaying errors and aging specifications on the process report.
Notify
Options for automatic email notification of the success or failure of the process.

Menu Commands

In addition to the standard File, Edit, and Tools menu commands, you can select the following commands from menus on the Load Request Editor:

Tools Menu
Convert to Local
Embed the load request in the restore request. (Available only when editing a named load request as an adjunct to editing a restore request.
Edit Table Map
Open the Table Map Editor, and design, edit, or browse a table map associated with the active load request.
Respecify Options
Open the Load Request Editor Options dialog to change the source file, control file, or table map.
Edit Exception Table Map
Open the Exception Table Mapping dialog to explicitly designate exception or violation tables.
Edit Partition Map
Open the Table Partition Mapping dialog to map a destination table to a Sybase partition.
Estimate Resources
Create a Resource Estimation Report for this load request.
Edit ACL
Open the Access Control List Editor to secure the load request. This menu selection is available when object security is enabled.
Delete ACL
Delete the access control list for a secured load request.
Options Menu
Show Aging
Hide or display the corresponding tab.
Show Currency
Hide or display the corresponding tab.


Feedback