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


pdm_load -i -f load_cnt.txt


---------------------------------- load_cnt.txt ----------------------------------

TABLE ca_contact

userid  last_name email_address

{"name.lastname","My last name",""}

---------------------------------- load_cnt.txt ----------------------------------


TABLE usp_contact

userid access notify_method1 notify_method2 notify_method3 notify_method4

{"name.lastname", "Cliente" , "Normal","Normal","Normal","Normal"}





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






Veja o artigo em Português

CA SDM carregando contatos ca_contact/usp_contact usando pdm_load

1 person found this helpful