DSXchange

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.

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.

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.

I think for using funnel operation the metadata of input links should be same....

correct me if iam wrong...

Yes metadata should be same in all input links to the Funnel stage.

The OP's post and example indicates that the output is required only one column and not multiple columns. So, anbu's solution will work.

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.

kris007 wrote:The OP's post and example indicates that the output is required only one column and not multiple columns. So, anbu's solution will work.

Yes ...i over looked it...

This works perfect.

Thank you all for your help.