Specifications

Modifying the data pipeline definition
134 InfoMaker
About transactions
A transaction is a logical unit of work done by a DBMS, within which either
all the work in the unit must be completed or none of the work in the unit must
be completed. If the destination DBMS does not support transactions or is not
in the scope of a transaction, each row that is inserted or updated is committed.
About the All and
None commit values
In the Data Pipeline painter, the Commit values All and None have the same
meaning.
Piping blob data
Blob data is data that is a binary large-object such as a Microsoft Word
document or an Excel spreadsheet. A data pipeline can pipe columns
containing blob data.
The name of the datatype that supports blob data varies by DBMS. Table 4-5
shows some examples.
Table 4-5: Examples of datatypes that support blob data
For information about the datatype that supports blob data in your DBMS, see
your DBMS documentation.
DBMS Datatypes that support blob data
Sybase SQL Anywhere LONG BINARY,
LONG VARCHAR (if more than 32 KB)
Sybase Adaptive Server
Enterprise
IMAGE,
TEXT
Microsoft SQL Server IMAGE,
TEXT
Oracle RAW,
LONG RAW
Informix BYTE,
TEXT