Database Reference
In-Depth Information
ity, such as EBCDIC to ASCII conversion, see aminoSoftware's Lysine EBCDIC
source.
All source component queries are written in whatever brand of SQL the database
uses. DB2's RDBMS-specific language is called SQL PL, and PL/SQL can also be
used for later versions. If you receive an error message about syntax, be sure that your
syntax matches the guidelines found on IBM's website:
ht-
In certain cases, you may want to use parameters to limit the data returned from the
database. Let's take a look at parameterizing your queries now.
DB2 Source Component Parameters
An important part of writing source queries is that doing so allows you to filter the data
that enters the pipeline. There are a number of reasons why you would want to do this,
including loading data incrementally, reusing the same package for different depart-
ments, or reducing the amount of data that is run at one time. When using the Mi-
crosoft OLE DB Provider for DB2, you need to set the Derive Parameters property to
True
. You find this property in the connection manager, by clicking the Data Links
button, and on the resulting Data Link Properties window, choosing the All tab. When
you click on Derive Parameters in the properties list, an Edit Property Value window
appears, as shown in
Figure 6-7
.
Search WWH ::
Custom Search