Hi all,
I'm having problem with this:
I have two tables - source and target.
Source:
record_id C(5), fld_1, fld_2, fld_3 ...
Target:
record_id C(6), fld_a, fld_b, fld_c ...
The structure isn't exactly the same so I create sql select from source table where I change field names to match the target table. the I scan this select and insert records into target table. The purpose of this is generating od unique IDs by stored dbc procedure. And now I need to create cursor/table which will have two columns OLD_ID and NEW_ID. Old_ID will be RECORD_ID from source table, an NEW_ID is RECORD_ID from target table.
I can't move on. Please help.
Thanx in advance.
Dezider