Pdm deref

2008-10-20T19:36:21Z

Jc.oakgov: /* Overview */

__NOTOC__
[[Category:Commands]]
{{Global Header}}
{{Global Announcement}}

== Overview ==
Use this command to replace data with data found in another table.

For example, lets say you performed the following extract:
'''pdm_extract -f "SELECT id,category FROM Call_Req" > output.txt.'''
The resulting extract would have the category entries displayed in their persid format such as pcat:400001. If you wanted to replace the category persid with the sym, the pdm_deref can perform that function.

== Usage ==
pdm_extract [-s] specfile [-c|-e|-r] [-d] [-h] [-n] [-p] [-u] [-v 1|2] <filename
<br>
{|
|-
! Command
! Description
! Remarks
|-
| -s specfile
| file containing SQL statement
|
|-
| -c
| csv output
|
|-
| -e
| csv output with double double quotes
|
|-
| -r
| informal report output
|
|-
| -d
| diagnostics
|
|-
| -h
| Help
|
|-
| -p
| preserve whitespace
|
|-
| -u
| no headers
|
|-
| -v <nowiki>[1|2]</nowiki>
| verbose. 1 is brief and 2 prints to a log file.
|
|-
|-
| filename
| file to be processed
|
|-
|}

== Specfile Example==
A [[pdm_extract]] in the following format:
<source lang=text>TABLE Call_Req
id category
{ "499998" ,"pcat:400001" }
{ "499999" ,"pcat:400001" }</source>...will be change to this format:
<source lang=text>TABLE Call_Req
id category.sym
{ "499998" ,"Sofware.Adobe Reader" }
{ "499999" ,"Softtware.Adobe Writer" }</source>...by running a specfile containing the following SQL Statement:
<source lang=sql>Deref
{
input = category
output = category.sym
rule = "SELECT sym FROM Prob_Category WHERE persid=?"
}</source>

== Examples ==
* Deref of a basic text file
pdm_deref -s specfile.txt < input.txt > output.txt

SDU - User contributions [en]

Pdm deref