Database Reference
In-Depth Information
Figure 6-7
.
Edit Property Value window on the Data Link Properties window
Once the Derive Parameters property is set, you will write your query using ques-
tion marks, similar to those in
Listing 6-2
.
Put the query in the SQL command in the
source component.
Listing 6-2
.
Sample Query to Illustrate DB2 Parameters
SELECT col1
, col2
, col3
FROM tab1
WHERE col4 = ?
Search WWH ::
Custom Search