|
SELECT D.ELEMENT_UID ,DOC.DOC_UID ,B.ELEMENT_PREFIX ,%Substring(B1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS SERVICENAMEW ,%Substring(C1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS PORTNAME ,C2.QSPACE AS QBINDING
,%Substring(C2.WS_ATTRIBUTE_VALUE, 1, 60 ) AS BINDINGNAME ,D1.WS_ATTRIBUTE_VALUE AS ENDPOINT FROM PSDOCUMENT DOC , PSELEMENT A , PSATTRIBUTE A1 , PSELEMENT B , PSATTRIBUTE B1 , PSELEMENT C , PSATTRIBUTE C1 , PSATTRIBUTE C2 , PSELEMENT D , PSATTRIBUTE D1 WHERE
A.DOC_UID = DOC.DOC_UID AND DOC.DOC_UID_SEQNO = 1 AND A.PARENT_UID = '0' AND A.ELEMENT_ORD = 1 AND A.ELEMENT_TAG = 'definitions' AND A1.DOC_UID = A.DOC_UID AND A1.ELEMENT_UID = A.ELEMENT_UID AND
A1.WS_ATTRIBUTE_VALUE = 'http://schemas.xmlsoap.org/wsdl/soap/' AND B.DOC_UID = A.DOC_UID AND B.PARENT_UID = A.ELEMENT_UID AND B.ELEMENT_PREFIX = A.ELEMENT_PREFIX AND B.ELEMENT_TAG = 'service' AND
B1.DOC_UID = B.DOC_UID AND B1.ELEMENT_UID = B.ELEMENT_UID AND B1.ATTRIBUTE_TAG = 'name' AND C.DOC_UID = B.DOC_UID AND C.PARENT_UID = B.ELEMENT_UID AND C.ELEMENT_PREFIX = B.ELEMENT_PREFIX AND
C.ELEMENT_TAG = 'port' AND C1.DOC_UID = C.DOC_UID AND C1.ELEMENT_UID = C.ELEMENT_UID AND C1.ATTRIBUTE_TAG = 'name' AND C2.ELEMENT_UID = C.ELEMENT_UID AND C2.ATTRIBUTE_TAG = 'binding' AND D.DOC_UID =
C.DOC_UID AND D.PARENT_UID = C.ELEMENT_UID AND D.ELEMENT_PREFIX = %Substring(A1.ATTRIBUTE_TAG,7,54) AND D.ELEMENT_TAG = 'address' AND D1.DOC_UID = D.DOC_UID AND D1.ELEMENT_UID = D.ELEMENT_UID AND
D1.ATTRIBUTE_TAG = 'location'
|
ENDPOINT_UID