SnapShot Connector EmbeddedSQL

Necessary namespaces:

<namespace-def name="cmd" value="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.XdsCommandProcessor"/>
<namespace-def name="query" value="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.XdsQueryProcessor"/>
<namespace-def name="ssc" value="urn:dirxml:ssc"/>

<rule>
 <description>Get current values from DB</description>
 <comment name="author" xml:space="preserve">Aleksandar Mujadin</comment>
 <comment name="version" xml:space="preserve">1.0</comment>
 <comment name="lastchanged" xml:space="preserve">2015-12-16</comment>
 <conditions>
  <and/>
 </conditions>
 <actions>
  <do-set-local-variable name="lv-query" scope="policy">
   <arg-node-set>
    <token-xml-parse>
     <token-text xml:space="preserve">&lt;nds dtdversion="2.0" ndsversion="8.x">
&lt;input xmlns:ssc="urn:dirxml:ssc">
&lt;ssc:sql ssc:class-cfg="Person">
&lt;ssc:statement ssc:query="true">select EMAIL from IST.EMAIL where PERSONID = '$lv.workforceid$'&lt;/ssc:statement>
&lt;/ssc:sql>
&lt;/input>
&lt;/nds></token-text>
    </token-xml-parse>
   </arg-node-set>
  </do-set-local-variable>
  <do-set-local-variable name="executeSQLquery" scope="policy">
   <arg-node-set>
    <token-xpath expression="query:query($destQueryProcessor,$lv-query)"/>
   </arg-node-set>
  </do-set-local-variable>
 </actions>
</rule>