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.
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.
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. |