01. Looking for Access Type: for know more about Access Type click Access Type - acctyp - Brazilian Portuguese
02. load usp_contact - for know more about load ca_contact click CA SDM Loading contacts pdm_load
03. You can use pdm_deref or you can follow these steps out of the box
https://wiki.ca.com/display/CASM1401/How+to+Use+pdm_deref+Example
pdm_load -i -f load_cnt.txt
---------------------------------- load_cnt.txt ----------------------------------
TABLE ca_contact
userid last_name email_address
{"name.lastname","My last name","my.mail@website.com"}
---------------------------------- load_cnt.txt ----------------------------------
TABLE usp_contact
userid access notify_method1 notify_method2 notify_method3 notify_method4
{"name.lastname", "Cliente" , "Normal","Normal","Normal","Normal"}
cnt_spec.txt
Deref
{
input = userid
output = id
rule = "select id FROM ca_contact WHERE userid=?"
}
pdm_dref -s (spec file name) < (input file name) > (exit file name)
pdm_deref -v -s cnt_spec.txt < load_uspcnt.txt > load_uspcnt_exit_A.txt
load_uspcnt_exit_A.txt
Veja o artigo em Português
CA SDM carregando contatos ca_contact/usp_contact usando pdm_load