Use the DB Alias tab to define the specific parameters needed to perform the Load Process for the Sybase ASE loader.
For Sybase ASE (Version 12 or later), you can disable triggers:
You can augment the loader arguments created automatically by Archive with additional loader parameters, if necessary. The additional parameters you create are appended to the list created by Archive, but are not validated by Archive prior to starting the loader. Refer to Sybase ASE documentation for valid operands. If additional loader parameters are forced from within Product Options, you cannot modify them. Refer to the Installation and Configuration Guide.
The Disabling Trigger/Constraint Confirmation dialog displays the list of tables in the Load Process and tabs that contain the corresponding database triggers and referential integrity constraints for each table.
A Focus Arrow in the first grid column indicates the table for which triggers and constraints are listed. To display the corresponding triggers and constraints for a different table, click a Focus Arrow grid cell to reposition the arrow, or use the up/down arrows on your keyboard.
Right-click the Status During Process column to select to enable or disable the corresponding trigger or constraint during the Load Process.
Right-click the Status After Process column to select whether to enable or disable the corresponding trigger or constraint after the Load Process completes.
If you want to store archived data in a specific partition, you must pass the appropriate partition name when you run the Load process. (Contact your DBA for the appropriate partition names.) A Table Partition Mapping dialog is used to map the Destination Table to a Sybase Partition.
This dialog is displayed by clicking .
The Table Partition Mapping dialog includes a tab for each Sybase DB Alias in the subject Optim Load Request. The Destination Table column lists every table mapped within the Table Map Editor, and the Partition column is used to specify the Sybase partition identifier or name for each table. You can specify one partition name only for each table.
Say, for example, you created a table called “my_publishers” that is partitioned by list, according to the values in the state column, as indicated as follows. (Certain entries are shown in bold for emphasis only.)
create table my_publishers (pub_id char(4) not null, pub_name varchar(40) null, city varchar(20) null, state char(2) null) partition by list (state) (west values ('CA', 'OR', 'WA') on seg1, east values ('NY', 'MA') on seg2)
If your archive file contains data for three states — California (CA), Oregon (OR), and Washington (WA) — you would specify west as the Partition, as shown in the earlier Table Partition Mapping example. Conversely, if your archive file contained data for two states — New York (NY) and Massachusetts (MA) — you would specify east as the Partition.
After you specify the appropriate partition name(s), close the Table Partition Mapping dialog to redisplay the previous dialog.