Modifying the data pipeline definition

Contents

Choosing a pipeline operation
Dependency of modifications on pipeline operation
When execution stops
Piping blob data
Changing the destination and source databases

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.

The following table lists properties you can modify that apply to
the destination table. These properties display at the top of the Data
Pipeline painter workspace.

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 The following table.
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.

The following table 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.

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.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2017

August 20, 2023

Was this article helpful?