Modifying the data pipeline definition

After you create a pipeline definition, you can modify it in a variety of ways. The changes you make depend on what pipeline operation you select, the destination DBMS, and what you are trying to accomplish by executing the pipeline.

Table 17-1 lists properties you can modify that apply to the destination table. These properties display at the top of the Data Pipeline painter workspace.

**Table 17-1: Pipeline properties for the destination table**
Item	Description	Default	How to edit
Table	Name of the destination table.	If source and destination are different, name of first table specified in the source data or name of the stored procedure. If the same, _copy is appended.	For Create or Replace, enter a name. For Refresh, Append, or Update, select a name from the drop-down list.
Options	Pipeline operation: Create, Replace, Refresh, Append, or Update.	Create - Add Table.	Select an option from the drop-down list. See Table 17-3.
Commit	Number of rows piped to the destination database before PowerBuilder commits the rows to the database.	100 rows.	Select a number, All, or None from the drop-down list.
Key	Key name for the table in the destination database.	If the source is only one table, the table name is followed by _x.	(Create or Replace only) Enter a name.
Max Errors	Number of errors allowed before the pipeline stops.	100 errors.	Select a number or No Limit from the drop-down list.
Extended Attributes	(Create and Replace only) Specifies whether or not the extended attributes of the selected source columns are piped to the extended attribute system tables of the destination database.	Not checked.	Click the check box.

Table 17-1: Pipeline properties for the destination table

Item

Description

Default

How to edit

Table

Name of the destination table.

If source and destination are different, name of first table specified in the source data or name of the stored procedure. If the same, _copy is appended.

For Create or Replace, enter a name.

For Refresh, Append, or Update, select a name from the drop-down list.

Options

Pipeline operation: Create, Replace, Refresh, Append, or Update.

Create - Add Table.

Select an option from the drop-down list. See Table 17-3.

Commit

Number of rows piped to the destination database before PowerBuilder commits the rows to the database.

100 rows.

Select a number, All, or None from the drop-down list.

Key

Key name for the table in the destination database.

If the source is only one table, the table name is followed by _x.

(Create or Replace only) Enter a name.

Max Errors

Number of errors allowed before the pipeline stops.

100 errors.

Select a number or No Limit from the drop-down list.

Extended Attributes

(Create and Replace only) Specifies whether or not the extended attributes of the selected source columns are piped to the extended attribute system tables of the destination database.

Not checked.

Click the check box.

Table 17-2 lists properties that you can modify that apply to the destination table’s columns and keys. These properties display under the properties that apply to the table itself and most can be modified only for the Create and Replace pipeline operations.

Column names and datatypes that cannot be modified You cannot modify the source column names and datatypes that display at the left of the workspace.

**Table 17-2: Pipeline properties for the destination table’s columns and keys**
Item	Description	Default	How to edit
Destination Name	Column name	Source column name.	Enter a name.
Type	Column datatype	If the DBMS is unchanged, source column datatype. If the DBMS is different, a best-guess datatype.	Select a type from the drop-down list.
Key	Whether the column is a key column (check means yes)	Source table's key columns (if the source is only one table and all key columns were selected).	Select or clear check boxes.
Width	Column width	Source column width.	Enter a number.
Dec	Decimal places for the column	Source column decimal places.	Enter a number.
Nulls	Whether NULL is allowed for the column (check means yes)	Source column value.	Select or clear check boxes.
Initial Value	Column initial value	Source column initial value. (If no initial value, character columns default to spaces and numeric columns default to 0.)	Select an initial value from the drop-down list.
Default Value	Column default value	None. Default values stored in the source database are not piped to the destination database.	Select a default value from the drop-down list or enter a default value. Keyword values depend on destination DBMS.

Table 17-2: Pipeline properties for the destination table’s columns and keys

Item

Description

Default

How to edit

Destination Name

Column name

Source column name.

Enter a name.

Type

Column datatype

If the DBMS is unchanged, source column datatype. If the DBMS is different, a best-guess datatype.

Select a type from the drop-down list.

Key

Whether the column is a key column (check means yes)

Source table's key columns (if the source is only one table and all key columns were selected).

Select or clear check boxes.

Width

Column width

Source column width.

Enter a number.

Dec

Decimal places for the column

Source column decimal places.

Enter a number.

Nulls

Whether NULL is allowed for the column (check means yes)

Source column value.

Select or clear check boxes.

Initial Value

Column initial value

Source column initial value. (If no initial value, character columns default to spaces and numeric columns default to 0.)

Select an initial value from the drop-down list.

Default Value

Column default value

None. Default values stored in the source database are not piped to the destination database.

Select a default value from the drop-down list or enter a default value. Keyword values depend on destination DBMS.