Optim™ supports the Sybase ASE loader. Use the DB Alias tab to define the specific parameters needed to perform the Load Process.
For Sybase ASE (Version 12 or later), you can disable triggers:
This field is provided to allow you to augment the loader arguments created automatically by Optim with additional loader parameters, if necessary. The additional parameters you create append to the list created by Optim, but are not validated by Optim prior to starting the loader. Refer to Sybase ASE documentation for valid operands. If additional loader parameters are forced from within Product Options, this field cannot be modified. (See 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 extracted 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 Extract 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 Extract 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.