Use the DB Alias tab to define the parameters needed for theSybase ASE loader. The availability of certain options and fields might be dependent upon your entries for related options and fields on the tab.

Use these options to disable triggers:
You can augment the loader arguments created automatically with additional loader parameters. The parameters you create are appended to the list created automatically, but are not validated before starting the loader. For valid operands, see the database loader documentation. If additional loader parameters are forced from within product options, you cannot modify them.

Default directory path for temporary loader files.
If you want to store data in a specific partition, you must pass the partition name when you run the load. Use the Table Partition Mapping dialog to map the target or destination table to a partition. Use to open the dialog.

The Table Partition Mapping dialog includes a tab for each Sybase DB alias referenced by the load request. Destination Table lists every table mapped by the table map. Use Partition to identify the partition for each table. Only one partition can be specified for a table. If the table contains data for other partitions, the loader generates an error. See the following example in which a table called “my_publishers” is partitioned, according to the values in the state column:
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 the file contains data for California (CA), Oregon (OR), and Washington (WA), west is the partition. Conversely, if the file contains data for New York (NY) and Massachusetts (MA), east is the Partition.