Short question about Update routine fro ODS
I try write a update routine for update fields from ODS2 to ODS1 (for example). And I have trouble with addressing fields of ODSes. For example:
ODS1 have fields: key char(1), data1 decimal and data3 decimal. And ODS2 have key char(1) and data2 decimal. I need for write update routine for update ODS1-data3=ODS1-data1 + ODS2-data2. But I can't understand - if I declare tables for ODS1 and ODS2 (how I must do it?) and write ODS1-data1 is it mean that data1 will be get from ODS1 FROM ROW THAT UPDATING IN THIS MOMENT? I have bad English (sorri) and try ask another way: if ODS1 have records
'1', 2, 0;
'2', 3, 0;
'3', 4, 0
and I write "ODS1-data1", will I get 2 when row with key = '1' was updated and 4 when key = '3' ?