DB Bulk Load Sybase IQ properties list

DB Bulk Load Sybase IQ properties list identifies the connection parameters and other items you define on the Database Configuration window.

Required properties

Property	Description
Interface	Specify the method or driver you want to use to connect to the data source.
Host Name	Specify the host where the Sybase IQ target is running.
Destination	Click the Destination Table icon to select the destination table from a set of existing tables.
Load Stage	Specify a Data File path or pipe name. The load stage file must reside on the same machine as the IQ Server. If you use named pipes on UNIX or Linux, the ETL Server and the IQ Server must reside on the same machine. This is not a requirement for Windows.

Optional properties

Property	Description
User and Password	Specify an authorized database user and a password to protect the database against unauthorized access.
Truncate	Select the option to remove all records from the destination table before the load.
Load Script	The Load Table Statement is generated on runtime based on the component settings, if this property is empty. To use a customized script, right-click the component, and select Generate Load Script. After you generate the script, you can click Load Script and edit the script.
Load Stage (Server)	Specify the server path to the data file or, leave it empty when using a pipe. If the Sybase IQ server needs to use a different path to the temporary data file than specified in the Load Stage property, you must enter it here.
Write Block Size	Specify the number of records to be written to the file or pipe in a single write operation.
Pre-processing SQL	Click the Pre-processing SQL icon to create a query that runs during component initialization. Queries can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Post-processing SQL	Click the Post-processing SQL icon to create a query that runs after all components execute. Queries can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Database	Specify the database you want to use as data source. Additionally, you must select an appropriate interface, and in some cases, specify an appropriate user ID and password.
Schema	Identifies the schema/owner you want to use as data source. The objects displayed will be restricted accordingly and new tables will be created in that schema.
Standardize Data Format	Select the option to convert incoming `DATE` and `NUMBER` information into a standard format that Sybase IQ ETL can move between systems that support different formats. Dates are converted into a format that includes the year, month, day, hour, minute, seconds, and fraction of a second: `YYYY-MM-DD hh:mm:ss.s`. For example, 2005-12-01 16:40:59.123 Numbers are converted with a '`.`' as the decimal separator.
Database Options	Click the Database Options icon to set options that override performance defaults and control the behavior of some transactions. See “Database connection settings”.