DEREF - pdm_deref - Everthing do you need know

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

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

 

commandDescription
  -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.)
-ruse 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.

2 people found this helpful

Attachments

    Outcomes