- PowerCenter 10.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 server location that is accessible from the machine that hosts the Integration Service. If you specify the target file location, the Sybase IQ server might fail to access the file.
Specify this attribute relative to the database server installation directory.
If the directory is in a Windows system, use a backslash (\) in the directory path:
If the directory is in a UNIX system, use a forward slash (/) in the directory path:
Enter the directory path by using the syntax for the machine hosting the database server installation. For example, if the Integration Service is on a Windows machine and the Sybase IQ server is on a UNIX machine, use UNIX syntax.
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.