DB Data Sink Insert Properties List

The DB Data Sink Insert Properties list identifies the required and optional properties of the DB Data Sink Insert component.

Required Properties
Property	Description
Interface	Identify the method or driver to use to connect to the datasource.
Host Name	Identify the datasource. The options that appear in the Host Name list depend on the interface you select.
Destination Table	Select the destination table from a set of existing tables, or enter the table manually. You can also create a new destination table based on a components port structure.

Optional Properties
Property	Description
User and Password	Identify an authorized database user and protect the database against unauthorized access.
Shared Connection	Allow the component to share a single connection to the database with other target components that have identical connection and database parameters. A connection can be shared only between components within the same project. Components in different projects within the same job cannot share a connection. Components that use the same database interface and login information, but use different database options cannot share a connection, and generate an error when the project is executed or simulated.
Insert Options	Determine how records will be inserted. The Include columns specify the attributes to get values assigned from the component. Unselect any attributes for which you want to apply the database defaults. In the SQL INSERT clause column, you can overwrite the value of the incoming attribute with a new one. You can use any expression allowed in the SQL language of the underlying database. SBN expressions are evaluated during initialization of the component, so the value or expression is always constant during a single execution. For example, SQL INSERT value clauses are: Static value – ‘valid’ Dynamic value (evaluated by Sybase IQ InfoPrimer Server) – ‘[uDate(“now”)]’ Database function (evaluated by database server) – getdate()
Truncate Table	Remove all records from the destination table when initializing the transformation process.
Write Block Size	Specify the number of records to be written to the file or pipe in a single write operation.
Pre Processing SQL	Create a script that runs during component initialization. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Post Processing SQL	Create a script that runs after all components execute. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Opening Attribute Quote	Specify a prefix for attribute names in SQL statements.
Closing Attribute Quote	Specify a postfix for attribute names in SQL statements.
Database	Identify the database to use as datasource. If you select this option, you must also select an appropriate interface, and in some cases, specify an appropriate user ID and password.
Schema	Identify the schema or owner you want to use as datasource. The objects that appear are restricted accordingly and new tables are created in the schema you specify.
Standardize Data Format	Convert incoming `DATE` and `NUMBER` information into a standard format that Sybase IQ InfoPrimer can move between systems that support different formats. Dates are converted into this format: `YYYY-MM-DD hh:mm:ss.s`. For example: 2005-12-01 16:40:59.123 Numbers are converted using a period (“`.`”) as the decimal separator.
IQ Lock Table in Exclusive Mode	Lock the target table to prevent it from being updated by concurrent transactions. When an exclusive table lock is applied, no other transaction can execute queries or perform any updates against the locked table. The IQ Lock Table in Exclusive Mode option also queues multiple projects that load the same table in Sybase IQ.
Wait Time for IQ Lock Table	Specify the maximum blocking time that the project should wait before acquiring an exclusive lock. Specify the time argument in the format hh:mm:ss.sss.. When you do not enter a time argument, the server does not wait. When you specify “00:00:00.000” as the time argument, the server waits indefinitely until an exclusive lock is available or an interruption occurs.
Load Stage Path	Specify a data file path. The load stage file must reside on the same machine as the IQ Server. When using a Sybase IQ database, if you specify a load stage path, the component uses the LOAD TABLE statement instead of using SQL statements. This leads to faster performance. Note: You do not have to enter the load stage path if client-side load-balancing capability is available on your IQ Server. If available, it is automatically used with the LOAD TABLE statement to add records from files located on remote host machines into the Sybase IQ table. To create a pipe, specify pipe:// as the Load Stage parameter. A pipe is not used if the Load Stage is blank. If you use named pipes on UNIX or Linux, the Sybase IQ InfoPrimer Server and the IQ Server must reside on the same machine. This is not a requirement for Windows.
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, enter it here.
Database Options	Set options that override performance defaults and control the behavior of some transactions.
Transactional	All work performed by the component, including preprocessing SQL statements and postprocessing SQL statements, is done in a single database transaction that is committed when the project finishes normally. Select this option to roll back the transaction, if this component encounters an error.