Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using one qvd creator application to create qvds.
I have qvds for last 6 months. It has one customer table having customer ids from various countries.
Now i need to update the customer ids of singapore country using the mapping file.
Is it possible to update the old qvds?
Thanks,
Durga
If I understand you want to change the id of singapore customers in 6 qvd.
Below the pseudocode.
- load the mapping file (singapore customer ids)
MapCustomer:
mapping load
CurrentCustomerId, NewCustomer Id
from somefile;
- loop on your 6 qvd files (read the qvd, change the id from current to new, store the qvd)
for each file in filelist(....)
SomeTable:
load
field1, field2, .......,
ApplyMap('MapCustomer', CustomerId) as CustomerId
from
.............; // use the variable file
store ..............;
drop table ............;
next;
If I understand you want to change the id of singapore customers in 6 qvd.
Below the pseudocode.
- load the mapping file (singapore customer ids)
MapCustomer:
mapping load
CurrentCustomerId, NewCustomer Id
from somefile;
- loop on your 6 qvd files (read the qvd, change the id from current to new, store the qvd)
for each file in filelist(....)
SomeTable:
load
field1, field2, .......,
ApplyMap('MapCustomer', CustomerId) as CustomerId
from
.............; // use the variable file
store ..............;
drop table ............;
next;