bash test

Xml code posted
created at 16 Jan 22:58, updated at 08 Feb 11:00

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
<?xml version="1.0" encoding="UTF-8"?>
<endpoint>
    <endpointName>11030_NNS_PLZ_Netzbetreiber</endpointName>
    <typeName>DatabaseQuery</typeName>
    <endpointParameters>
        <endpointParameter>
            <endpointParameterName>Query</endpointParameterName>
            <value>
-- Ergebnis der Abfrage der Metadaten im Endpunkt verwenden

select ${ExecutionData.EndpointCallInvokerMap.Call_NNS_FUNCTION_META_PLZ_NETZBETREIBER.Result.First.CSV}
from NNS_PLZ_NETZBETREIBER@dbl_ENET_NNS
-- where PLZ = 07749
-- Wenn externer aufruf, dann 
where PLZ = ${EndpointParameterMap.PLZ}
-- AND GUELTIG_BIS = ${EndpointParameterMap.GUELTIG_BIS}
-- AND to_char(GUELTIG_BIS,'DD.MM.YY') = '${EndpointParameterMap.GUELTIG_BIS}'
AND to_number(to_char(GUELTIG_BIS,'YYYY')) >= '${EndpointParameterMap.GUELTIG_BIS}'

  </value>
            <fixedValue>false</fixedValue>
        </endpointParameter>
        <endpointParameter>
            <endpointParameterName>DataSourceName</endpointParameterName>
            <value>jdbc_oracle_pdm_enet</value>
            <fixedValue>true</fixedValue>
        </endpointParameter>
        <endpointParameter>
            <endpointParameterName>SessionPropertiesName</endpointParameterName>
            <value>jdbc_oracle</value>
            <fixedValue>true</fixedValue>
        </endpointParameter>
    </endpointParameters>
  <!-- SDDDD --> 
</endpoint>
1.38 KB in 2 ms with coderay