We know CA technologie has a great documentation about your tools but sometimes we need more example about some command where explain how to use.
"pdm_deref is a tool to replace data with data found in another table." cdtj something like a inner join on SQL Command or VLOOKUP / PROCV using MS Excel.
pdm_deref -h
Usage: C:\PROGRA~2\CA\SERVIC~1\bin\deref.exe
| command | Description |
|---|
| -h | (help) |
| -d | (diagnostics) |
| -v | (verbose) |
| -p | (preserve whitespace) |
| -s | (spec_file) Required |
| -c | (use CSV format for output) |
| -e | (use CSV format with embedded double quotes escaped with a double quote) |
| -n | (allows 0 length strings for hook values.) |
| -r | use informal report format for output) |
| -u | (no headers) |
How to use:
CA_CONTACT x Access Type
01. Do your own input file, example: pdm_extract -f "select userid, last_name from ca_contact" > inputfile.txt
inputfile.txt
TABLE usp_contact userid c_acctyp_id {"name.lastname","10002"} |
02. spec parameters
spec.txt
Deref { input = id output = contact_uuid rule = "select id FROM ca_contact WHERE userid=?" } |
03. Command
pdm_deref -v -s spec.txt < inputfile.txt > exit.txt
exit.txt
TABLE usp_contact location_uuid c_acctyp_id { "6429915D4A19D74CA629E454E729CE20", "10002" } } |
Deepening on the Dref, how to do using Access Type
ACCESS_TYPE x contact
Access Type - acctyp - Brazilian Portuguese
inputfile.txt
TABLE ca_contact userid access {"name.lastname","Administração"} |
spec.txt
Deref { input = access output = c_acctyp_id rule = "select id FROM Access_Type_v2 WHERE sym=?" } |
Command
pdm_deref -v -s spec.txt < inputfile.txt > exit.txt |
exit.txt
TABLE ca_contact userid c_acctyp_id { "name.lastname", "10002" } |
Notification_Urgency x contact
CA SDM - noturg Notification_Urgency
inputfile.txt
TABLE ca_contact userid notify_method1 notify_method2 notify_method3 notify_method4 {"name.lastname","Normal","Normal","Normal","Normal"} |
spec.txt
Deref { input = notify_method1 output = notify_urgency1 rule = "select id FROM Notification_Urgency WHERE sym=?" } |
Command
pdm_deref -v -s spec.txt < inputfile.txt > exit.txt |
exit.txt
TABLE ca_contact userid notify_urgency1 notify_method2 notify_method3 notify_method4 { "name.lastname", "401", "Normal", "Normal", "Normal" } |
More about:
How to Use pdm_deref Example - CA Service Management - 14.1 - CA Wiki
Exemplo de como usar pdm_deref - CA Service Management - 14.1 - Portuguese - Brazil - CA Wiki
Administration Guide Release 12.7.00
Pdm deref - SDU
CA SDM Loading contacts pdm_load
Tiago Macul contents
Was this information helpful? left a comment.