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 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.
Load Request Editor
- 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.