Description:

Loading data through pdm_load into the ca_contact and the usp_contact.

Solution:

Example with ca_contact and usp_contact:

1. Create a load file for ca_contact with the relevant user. E.g. file1.txt
   TABLE ca_contact
   { "" ,"" ,"" ,"" ,"sonia.pires" ,"" ,"" ,"","pires" ,"0" }
   
   
2. Load this user...
   pdm_load -v -i -f file1.txt
   
   
3. Extract the uuid from ca_contact table and divert the output into a file.
   pdm_extract -f "select id from ca_contact where last_name='pires'" >p.txt
   
   
4. Edit the p.txt file...
   TABLE ca_contact
   id
   { "BBAE5BC462180E469FE39E6B2B1B66A8" }
   
   Modify the text and add the extra fields you want to include into the
   usp_contact table and change the ca_contact to usp_contact
   TABLE usp_contact
   id c_acctyp_id
   { "BBAE5BC462180E469FE39E6B2B1B66A8" , "2405" }
   
   
5. Save the above.
   
   
6. Load the newly modified p.txt file..
   pdm_load -v -f p.txt
   NOTE1: do not use the -i option in here.
   
   NOTE2: Running pdm_cache_refresh during normal production hours
   isn't advisable.
   
   
7. Refresh the table data so that the domsrvr picks up the changes..
   pdm_cache_refresh -t ca_contact
   No need to run pdm_cache_refresh against the usp_contact table

Release:
Component: ARGIS