CA SDM Loading contacts pdm_load on usp_contact

Document created by TMACUL Champion on Sep 1, 2015Last modified by TMACUL Champion on Jan 17, 2017
Version 2Show Document
  • View in full screen mode

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

CASDM_cntload_04.jpg

 

load_uspcnt_exit_A.txt

 

 

Veja o artigo em Português

CA SDM carregando contatos ca_contact/usp_contact usando pdm_load

1 person found this helpful

Attachments

    Outcomes