On the Properties tab, you can specify details of exactly what the link does.
The properties determine how incoming data is written and where the data is written. Some of the properties are required, although many have default settings. Properties without default settings are displayed in red in this tab and turn black when you supply a value for them.
The following table summarizes the properties and their attributes. A more detailed description of each property follows.
|Category and Property||Values||Default||Required?|
||False||Yes if Connection Method = Native|
|User||User ID||N/A||Yes if Connection Method = Native and Remote Server = True|
|Password||Password||N/A||Yes if Connection Method = Native and Remote Server = True|
|Close Command||Close command SQL statement||N/A||No|
|Open Command||Open command SQL statement||N/A||No|
|Silently Drop Columns Not in Table||
|Default String Length||String length||32||Yes|
Under Target, you must specify the write mode and destination table.
Select from the available values:
- Append. Appends new records to the table. The database user who writes in this mode must have Resource privileges. This is the mode is the default mode.
- Create. Creates a new table. The database user who writes in this mode must have Resource privileges. The stage returns an error if an existing table has the same name as the table name that you specified.
- Replace. Deletes the existing table and creates
a new one in its place. The database user who writes in this mode
must have Resource privileges.
You cannot create or replace a table that has primary keys. Do not specify primary keys in your metadata.
- Truncate. Retains the table attributes but discards existing records and appends new ones. The stage will run more slowly in this mode if the user does not have Resource privileges.
Specify the name of the Informix® table to write data to. The following property is dependent on the Table property:
- Select List
Specifies a list that determines which columns are written. If you do not supply the list, the stage writes data to all columns.