Specifications

Saving a pipeline
138 InfoMaker
❖ To correct pipeline errors:
1 Change data values for the appropriate columns in the error rows.
2 Click the Update DB button, or select Design>Update Database from the
menu bar.
InfoMaker pipes rows in which errors were corrected to the destination
table and displays any remaining errors.
3 Repeat steps 1 and 2 until all errors are corrected.
The Data Pipeline painter workspace displays.
Viewing an error
message
Sometimes you cannot see an entire error message because the column is not
wide enough. Move the pointer to the error message and press the Right Arrow
key to scroll through it. You can also drag the Error Message column border to
the width needed.
Making the error messages shorter
For ODBC data sources, you can set the MsgTerse database parameter in the
destination database profile to make the error messages shorter. If you type
MsgTerse = 'Yes', then the SQLSTATE error number does not display. For
more information on the MsgTerse parameter, see the online Help.
Saving a pipeline
When you have generated a pipeline definition in the Data Pipeline painter
workspace, you should save the pipeline. You can then reuse it later.
❖ To save a pipeline:
• Click the Save button, or select File>Save from the menu bar.
For a new pipeline
When you save a pipeline for the first time, you must specify a name. The name
can be any valid identifier with up to 80 characters. A common convention is
to prefix the name with the string
pipe_.
InfoMaker saves the pipeline in the current library. For information about
changing the current library, see “Working with libraries” on page 14.