Hi,
I have a requirement where I need to add couple of values to the values I selected from a tables. How do I implement this in datastage.
For example, I do a select field1 from TableA on a DB2 stage. And now I need to add two more values to this selected field1 like AAA and BBB. When I do
select field1 from TableA
union all
values ('AAA')
union all
values('BBB')
The DB2 stage takes for ever to return the value. Is there any other alternate method. Thanks in advance.
Union Function
Moderators: chulett, rschirm, roy
I think for using funnel operation the metadata of input links should be same....anbu wrote:You can create two rows using Row Generator by setting Number of Records as 2 and define the default values as "AAA" and "BBB".
Use funnel to combine DB2 data and Row Generator data.
correct me if iam wrong...
Yes.
From Anbu's design..
--Define the column name(field 1) in the row generator as the same as what is defined in DB2.
-- Open the properties for that column in the row generator stage. Click on Algorithm. Add values ('AAA'). Add the values again ('BBB').
-- Set the row generator to run only for 2 rows and join with the DB2 output using the funnel stage.
From Anbu's design..
--Define the column name(field 1) in the row generator as the same as what is defined in DB2.
-- Open the properties for that column in the row generator stage. Click on Algorithm. Add values ('AAA'). Add the values again ('BBB').
-- Set the row generator to run only for 2 rows and join with the DB2 output using the funnel stage.