Hi,

How do I perform the following ROW - BY - ROW operation using in - built warehouse transformer with out writing user - defined stored procedure.

The following is just a sample(dummy) procedure to understand the functionality what I am trying to do.

Create procedure x
language SQL
BEGIN
For cur as
select a,b,c from table

DO
Declare Continue handler for duplicate values
Update sample
Set a=cur.a, b=cur.b where c=cur.c

Insert into sample(cur.a,cur.b);

end for
END
End


Thanks,
Thangam