Title / Description
Code <?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>
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code
1.1.2
1.1.2