Properties tab

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.

Table 1. Input link properties and values
Category and Property Values Default Required?
Target      
Target Category
  • Append
  • Create
  • Replace
  • Truncate
 Append Yes
Table Table Name N/A Yes
Connection      
Connection method
  • XPS Fast
  • HPL
  • Native
 XPS Fast Yes
Remote Server
  • True
  • False
 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
Database Database name N/A Yes
Server Server name N/A No
Options      
Close Command Close command SQL statement N/A No
Open Command Open command SQL statement N/A No
Silently Drop Columns Not in Table
  • True
  • False
 False Yes
Default String Length String length 32 Yes

Target category

Under Target, you must specify the write mode and destination table.

Write mode

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.

Table

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.