Pdm deref - Revision history

Gityerfix: Reverted edits by Agegeleruvy (Talk); changed back to last version by Jc.oakgov

2010-11-30T05:28:00Z

Reverted edits by Agegeleruvy (Talk); changed back to last version by Jc.oakgov

Agegeleruvy at 03:16, 24 November 2010

2010-11-24T03:16:49Z

Jc.oakgov: /* Overview */

2008-10-20T19:36:21Z

‎Overview

Gityerfix at 19:05, 26 July 2008

2008-07-26T19:05:05Z

Gityerfix at 05:29, 26 July 2008

2008-07-26T05:29:32Z

Gityerfix at 22:03, 25 July 2008

2008-07-25T22:03:39Z

Gityerfix: /* Examples */

2008-07-18T14:11:03Z

‎Examples

Gityerfix: /* Examples */

2008-07-02T19:23:33Z

‎Examples

Gityerfix: New page: Use this command to replaced 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" > outp...

2008-06-24T18:38:19Z

New page: Use this command to replaced 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" > outp...

New page

Use this command to replaced 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

----
<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

[[Category:Commands|Commands man]]

@@ Line 5: / Line 5: @@
 == Overview ==
-Use this command to replaced data with data found in another table.
+Use this command to replace data with data found in another table.
 For example, lets say you performed the following extract:

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
@@ Line 16: / Line 8: @@
 For example, lets say you performed the following extract:
-'''pdm_extract -f &quot;SELECT id,category FROM Call_Req&quot; &gt; output.txt.'''
+'''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] &lt;filename
+pdm_extract [-s] specfile [-c|-e|-r] [-d] [-h] [-n] [-p] [-u] [-v 1|2] <filename
-&lt;br&gt;
+<br>
 {|
 |-
@@ Line 60: / Line 52: @@
+|
 |-
-| -v &lt;nowiki&gt;[1|2]&lt;/nowiki&gt;
+| -v <nowiki>[1|2]</nowiki>
 | verbose. 1 is brief and 2 prints to a log file.
+|
@@ Line 73: / Line 65: @@
 == Specfile Example==
 A [[pdm_extract]] in the following format:
-&lt;source lang=text&gt;TABLE Call_Req
+<source lang=text>TABLE Call_Req
 	id category
-	{ &quot;499998&quot; ,&quot;pcat:400001&quot; }
+	{ "499998" ,"pcat:400001" }
-	{ &quot;499999&quot; ,&quot;pcat:400001&quot; }&lt;/source&gt;...will be change to this format:
+	{ "499999" ,"pcat:400001" }</source>...will be change to this format:
-&lt;source lang=text&gt;TABLE Call_Req
+<source lang=text>TABLE Call_Req
 	id category.sym
-	{ &quot;499998&quot; ,&quot;Sofware.Adobe Reader&quot; }
+	{ "499998" ,"Sofware.Adobe Reader" }
-         { &quot;499999&quot; ,&quot;Softtware.Adobe Writer&quot; }&lt;/source&gt;...by running a specfile containing the following SQL Statement:
+         { "499999" ,"Softtware.Adobe Writer" }</source>...by running a specfile containing the following SQL Statement:
-&lt;source lang=sql&gt;Deref
+<source lang=sql>Deref
+{
 input = category
 output = category.sym
-rule = &quot;SELECT sym FROM Prob_Category WHERE persid=?&quot;
+rule = "SELECT sym FROM Prob_Category WHERE persid=?"
-}&lt;/source&gt;
+}</source>
 == Examples ==
 * Deref of a basic text file
-  pdm_deref -s specfile.txt &lt; input.txt &gt; output.txt
+  pdm_deref -s specfile.txt < input.txt > output.txt