- PowerCenter 10.4.1
- All Products
uid=user ID; pwd=password; eng=Sybase IQ database server name
Number of records per block in the target Sybase table. The external loader applies the block factor attribute to load operations for fixed-width flat file targets only for Sybase IQ versions up to 15.x.
Size of blocks used in Sybase database operations. The external loader applies the block size attribute to load operations for delimited flat file targets only for Sybase IQ versions up to 15.x.
If enabled, the Sybase IQ database issues a checkpoint after successfully loading the table. If disabled, the database issues no checkpoints.
Number of rows the Sybase IQ external loader loads before it writes a status message to the external loader log.
Server Datafile Directory
The Sybase IQ data file directory that is accessible from the machine where Integration Service runs.
If the directory is on a Windows system, use a backslash (\) in the directory path:
If the directory is on a UNIX system, use a forward slash (/) in the directory path:
Enter the directory path for the machine where the Integration Service runs.
External Loader Executable
For Sybase 15.x: dbisql -host<hostname> -port<port number>
Name of the Sybase IQ external loader executable. When you create a Sybase IQ external loader connection, the Workflow Manager sets the name of the external loader executable file to dbisql by default. If you use an executable file with a different name, you must update the External Loader Executable field. If the external loader executable file directory is not in the system path, you must enter the file path and file name in this field.
Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. Clear the attribute to load data from a named pipe. The Integration Service can write to a named pipe if the Integration Service is local to the Sybase IQ database.