Number of files: 1
Number of words: 41
File in index: IndexedFile(1: /US_States/stateServiceView.xmi)
A STATESERVICEVIEW mmuuid:8e9a4fcc-6c56-4838-8c13-756c4379f5ec stateServiceView     0 1 http://www.metamatrix.com/metamodels/Relational 111111  /US_States/stateServiceView.xmi stateServiceView ¡10 
C STATESERVICEVIEW.GETALLSTATEINFO.RESULT mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec stateServiceView.GetAllStateInfo.Result   mmuuid:837a75c2-d3dd-4b16-8147-a3e63437e747 mmuuid:2c8f26a8-e31d-4f1d-b31c-7131dd354c4bmmuuid:9c914235-6125-48a1-834d-7e5
e0a4ce2cfmmuuid:94db5506-e0e2-4c98-a0c7-906c5d8bd7bcmmuuid:95761b0f-30de-4d46-aded-9e1ebc296a1d  /US_States/stateServiceView.xmi Result ¡10 
C STATESERVICEVIEW.GETALLSTATEINFO_REQUEST.RESULT mmuuid:41971318-5c62-44c1-9b57-d6014577d15a stateServiceView.GetAllStateInfo_request.Result   mmuuid:3a7f8b41-ac7f-4666-8493-8f474645ca8c mmuuid:097c20da-f9a0-41bb-93c3-c1777129c6f6  /US_States/stateS
erviceView.xmi Result ¡10 
C STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.RESULT mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 stateServiceView.GetAllStateInfo_response.Result   mmuuid:c15ad153-4b4e-4796-a24e-9a695699d0cf mmuuid:ca1f0dac-03ab-45dd-862c-89c4a4f90f32mmuuid:102aa865-
e359-42a1-9610-983bfd5dbd5dmmuuid:97b4e382-752e-41fa-be5f-1e6d0e6532f6mmuuid:27aed7cc-e601-49b5-83a2-cc76989aed93  /US_States/stateServiceView.xmi Result ¡10 
C STATESERVICEVIEW.GETSTATEINFO.RESULT mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 stateServiceView.GetStateInfo.Result   mmuuid:435ef4d5-0336-4605-969c-6d1b7d0132ca mmuuid:4a519557-fbb6-4a6b-bda6-b221280e73c3mmuuid:e633d7f5-df66-44ca-81ef-9a5a14a03
d5cmmuuid:067d73eb-3ca6-4c48-8203-eee2dd93d6a2mmuuid:bf6b5783-5e70-4c81-9b2a-8c1ef275bf9f  /US_States/stateServiceView.xmi Result ¡10 
C STATESERVICEVIEW.GETSTATEINFO_REQUEST.RESULT mmuuid:ee1e58df-c63d-4a1c-977a-49d169567834 stateServiceView.GetStateInfo_request.Result   mmuuid:9d102f3b-e4e9-437b-b723-cb1af1f9f0f3 mmuuid:4c6fed09-9341-45bd-ba6e-826137e4d874  /US_States/stateService
View.xmi Result ¡10 
C STATESERVICEVIEW.GETSTATEINFO_RESPONSE.RESULT mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d stateServiceView.GetStateInfo_response.Result   mmuuid:6af790ef-8eb7-4fa5-9884-2875cd4cd42d mmuuid:78e03824-e658-4e9b-8ea2-f89d0913285dmmuuid:0562cb8b-a528-4
f00-8dd1-e73880c361b4mmuuid:b357228b-84a9-431f-afa7-d2c12a67315cmmuuid:4e8603ae-4345-4469-aa8b-872710b6ec1c  /US_States/stateServiceView.xmi Result ¡10 
E STATESERVICEVIEW.GETALLSTATEINFO_REQUEST mmuuid:3a7f8b41-ac7f-4666-8493-8f474645ca8c stateServiceView.GetAllStateInfo_request     01   mmuuid:41971318-5c62-44c1-9b57-d6014577d15a 0  /US_States/stateServiceView.xmi GetAllStateInfo_request ¡10 
E STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE mmuuid:c15ad153-4b4e-4796-a24e-9a695699d0cf stateServiceView.GetAllStateInfo_response     01 mmuuid:1d0478f9-8034-4147-9118-3e8615ca9b76 mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 0  /US_States/stateServic
eView.xmi GetAllStateInfo_response ¡10 
E STATESERVICEVIEW.GETALLSTATEINFO mmuuid:837a75c2-d3dd-4b16-8147-a3e63437e747 stateServiceView.GetAllStateInfo     01   mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec 0  /US_States/stateServiceView.xmi GetAllStateInfo ¡10 
E STATESERVICEVIEW.GETSTATEINFO_REQUEST mmuuid:9d102f3b-e4e9-437b-b723-cb1af1f9f0f3 stateServiceView.GetStateInfo_request     01 mmuuid:842b586b-99e1-4e3c-aa90-f7f4304b35b6 mmuuid:ee1e58df-c63d-4a1c-977a-49d169567834 0  /US_States/stateServiceView.xm
i GetStateInfo_request ¡10 
E STATESERVICEVIEW.GETSTATEINFO_RESPONSE mmuuid:6af790ef-8eb7-4fa5-9884-2875cd4cd42d stateServiceView.GetStateInfo_response     01 mmuuid:8af787ca-f333-418e-84cd-7e899fa4f193 mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d 0  /US_States/stateServiceView.
xmi GetStateInfo_response ¡10 
E STATESERVICEVIEW.GETSTATEINFO mmuuid:435ef4d5-0336-4605-969c-6d1b7d0132ca stateServiceView.GetStateInfo     01 mmuuid:a4d19ce9-2ee7-405c-8ec7-5ac460fed586 mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 0  /US_States/stateServiceView.xmi GetStateInfo ¡
10 
F STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.XML_IN mmuuid:1d0478f9-8034-4147-9118-3e8615ca9b76 stateServiceView.GetAllStateInfo_response.xml_in   mmuuid:c15ad153-4b4e-4796-a24e-9a695699d0cf   xml mmuuid:43f5274e-55e1-1f87-ba1c-eea49143eb32 0 10 0 0 0
 1 0 0  /US_States/stateServiceView.xmi xml_in ¡10 
F STATESERVICEVIEW.GETSTATEINFO.STATECODE mmuuid:a4d19ce9-2ee7-405c-8ec7-5ac460fed586 stateServiceView.GetStateInfo.stateCode   mmuuid:435ef4d5-0336-4605-969c-6d1b7d0132ca   string mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7 4000 10 0 0 0 1 0 0  /US_
States/stateServiceView.xmi stateCode ¡10 
F STATESERVICEVIEW.GETSTATEINFO_REQUEST.STATECODE mmuuid:842b586b-99e1-4e3c-aa90-f7f4304b35b6 stateServiceView.GetStateInfo_request.stateCode   mmuuid:9d102f3b-e4e9-437b-b723-cb1af1f9f0f3   string mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7 4000 10 0
 0 0 1 0 0  /US_States/stateServiceView.xmi stateCode ¡10 
F STATESERVICEVIEW.GETSTATEINFO_RESPONSE.XML_IN mmuuid:8af787ca-f333-418e-84cd-7e899fa4f193 stateServiceView.GetStateInfo_response.xml_in   mmuuid:6af790ef-8eb7-4fa5-9884-2875cd4cd42d   xml mmuuid:43f5274e-55e1-1f87-ba1c-eea49143eb32 0 10 0 0 0 1 0 0
  /US_States/stateServiceView.xmi xml_in ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO.RESULT.ABBREVIATION mmuuid:9c914235-6125-48a1-834d-7e5e0a4ce2cf stateServiceView.GetAllStateInfo.Result.Abbreviation   mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec 11011000 1 0 4000 0 0 2 4000 10 -1 -1       string  
 mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Abbreviation ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO.RESULT.CAPITAL mmuuid:94db5506-e0e2-4c98-a0c7-906c5d8bd7bc stateServiceView.GetAllStateInfo.Result.Capital   mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec 11011000 1 0 4000 0 0 3 4000 10 -1 -1       string   mmuuid:bf
6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Capital ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO.RESULT.NAME mmuuid:2c8f26a8-e31d-4f1d-b31c-7131dd354c4b stateServiceView.GetAllStateInfo.Result.Name   mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec 11011000 1 0 4000 0 0 1 4000 10 -1 -1       string   mmuuid:bf6c34c0
-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Name ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO.RESULT.YEAROFSTATEHOOD mmuuid:95761b0f-30de-4d46-aded-9e1ebc296a1d stateServiceView.GetAllStateInfo.Result.YearOfStatehood   mmuuid:f96d0941-cbdb-45bf-afac-1bf2546b74ec 11011000 1 0 0 0 0 4 0 10 -1 -1       biginteg
er   mmuuid:822b9a40-a066-1e26-9b08-d6079ebe1f0d    /US_States/stateServiceView.xmi YearOfStatehood ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO_REQUEST.RESULT.XML_OUT mmuuid:097c20da-f9a0-41bb-93c3-c1777129c6f6 stateServiceView.GetAllStateInfo_request.Result.xml_out   mmuuid:41971318-5c62-44c1-9b57-d6014577d15a 11011000 1 0 0 0 0 1 0 10 -1 -1       xml   mm
uuid:43f5274e-55e1-1f87-ba1c-eea49143eb32    /US_States/stateServiceView.xmi xml_out ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.RESULT.ABBREVIATION mmuuid:102aa865-e359-42a1-9610-983bfd5dbd5d stateServiceView.GetAllStateInfo_response.Result.Abbreviation   mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 11011000 1 0 4000 0 0 2 4000 10 -1
 -1       string   mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Abbreviation ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.RESULT.CAPITAL mmuuid:97b4e382-752e-41fa-be5f-1e6d0e6532f6 stateServiceView.GetAllStateInfo_response.Result.Capital   mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 11011000 1 0 4000 0 0 3 4000 10 -1 -1       
string   mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Capital ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.RESULT.NAME mmuuid:ca1f0dac-03ab-45dd-862c-89c4a4f90f32 stateServiceView.GetAllStateInfo_response.Result.Name   mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 11011000 1 0 4000 0 0 1 4000 10 -1 -1       string
   mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Name ¡10 
G STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE.RESULT.YEAROFSTATEHOOD mmuuid:27aed7cc-e601-49b5-83a2-cc76989aed93 stateServiceView.GetAllStateInfo_response.Result.YearOfStatehood   mmuuid:44cf9356-7ca9-4087-8da8-642b08208340 11011000 1 0 0 0 0 4 0 10 -1
 -1       biginteger   mmuuid:822b9a40-a066-1e26-9b08-d6079ebe1f0d    /US_States/stateServiceView.xmi YearOfStatehood ¡10 
G STATESERVICEVIEW.GETSTATEINFO.RESULT.ABBREVIATION mmuuid:e633d7f5-df66-44ca-81ef-9a5a14a03d5c stateServiceView.GetStateInfo.Result.Abbreviation   mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 11011000 1 0 4000 0 0 2 4000 10 -1 -1       string   mmuui
d:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Abbreviation ¡10 
G STATESERVICEVIEW.GETSTATEINFO.RESULT.CAPITAL mmuuid:067d73eb-3ca6-4c48-8203-eee2dd93d6a2 stateServiceView.GetStateInfo.Result.Capital   mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 11011000 1 0 4000 0 0 3 4000 10 -1 -1       string   mmuuid:bf6c34c0
-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Capital ¡10 
G STATESERVICEVIEW.GETSTATEINFO.RESULT.NAME mmuuid:4a519557-fbb6-4a6b-bda6-b221280e73c3 stateServiceView.GetStateInfo.Result.Name   mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 11011000 1 0 4000 0 0 1 4000 10 -1 -1       string   mmuuid:bf6c34c0-c442-
1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Name ¡10 
G STATESERVICEVIEW.GETSTATEINFO.RESULT.YEAROFSTATEHOOD mmuuid:bf6b5783-5e70-4c81-9b2a-8c1ef275bf9f stateServiceView.GetStateInfo.Result.YearOfStatehood   mmuuid:9ed6feff-514f-4778-bd07-f6482c8e1ac0 11011000 1 0 0 0 0 4 0 10 -1 -1       biginteger   m
muuid:822b9a40-a066-1e26-9b08-d6079ebe1f0d    /US_States/stateServiceView.xmi YearOfStatehood ¡10 
G STATESERVICEVIEW.GETSTATEINFO_REQUEST.RESULT.XML_OUT mmuuid:4c6fed09-9341-45bd-ba6e-826137e4d874 stateServiceView.GetStateInfo_request.Result.xml_out   mmuuid:ee1e58df-c63d-4a1c-977a-49d169567834 11011000 1 0 0 0 0 1 0 10 -1 -1       xml   mmuuid:4
3f5274e-55e1-1f87-ba1c-eea49143eb32    /US_States/stateServiceView.xmi xml_out ¡10 
G STATESERVICEVIEW.GETSTATEINFO_RESPONSE.RESULT.ABBREVIATION mmuuid:0562cb8b-a528-4f00-8dd1-e73880c361b4 stateServiceView.GetStateInfo_response.Result.Abbreviation   mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d 11011000 1 0 4000 0 0 2 4000 10 -1 -1   
    string   mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Abbreviation ¡10 
G STATESERVICEVIEW.GETSTATEINFO_RESPONSE.RESULT.CAPITAL mmuuid:b357228b-84a9-431f-afa7-d2c12a67315c stateServiceView.GetStateInfo_response.Result.Capital   mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d 11011000 1 0 4000 0 0 3 4000 10 -1 -1       string
   mmuuid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Capital ¡10 
G STATESERVICEVIEW.GETSTATEINFO_RESPONSE.RESULT.NAME mmuuid:78e03824-e658-4e9b-8ea2-f89d0913285d stateServiceView.GetStateInfo_response.Result.Name   mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d 11011000 1 0 4000 0 0 1 4000 10 -1 -1       string   mmu
uid:bf6c34c0-c442-1e24-9b01-c8207cd53eb7    /US_States/stateServiceView.xmi Name ¡10 
G STATESERVICEVIEW.GETSTATEINFO_RESPONSE.RESULT.YEAROFSTATEHOOD mmuuid:4e8603ae-4345-4469-aa8b-872710b6ec1c stateServiceView.GetStateInfo_response.Result.YearOfStatehood   mmuuid:b28efbed-f1d4-4c27-acf8-1bcba17c241d 11011000 1 0 0 0 0 4 0 10 -1 -1   
    biginteger   mmuuid:822b9a40-a066-1e26-9b08-d6079ebe1f0d    /US_States/stateServiceView.xmi YearOfStatehood ¡10 
T STATESERVICEVIEW.GETALLSTATEINFO_REQUEST mmuuid:3a7f8b41-ac7f-4666-8493-8f474645ca8c mmuuid:0c05f52a-8386-47ec-8e62-b17357f31852 CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT
		XMLELEMENT(NAME GetAllStateInfo, XMLNAMESPACES(DEFAULT 'http://www.teiid.org/stateService/') 
) AS xml_out;
END      /US_States/stateServiceView.xmi GetAllStateInfo_request ¡10 
T STATESERVICEVIEW.GETALLSTATEINFO_RESPONSE mmuuid:c15ad153-4b4e-4796-a24e-9a695699d0cf mmuuid:0d799c15-14b1-4d84-8e72-90fbb7a9a145 CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT t.* FROM
		XMLTABLE(XMLNAMESPACES('http://www.teiid.org/stateService/' AS ns) , '/ns:GetAllStateInfoResponse/AllStateInfo' PASSING stateServiceView.GetAllStateInfo_response.xml_in 
	COLUMNS 
		Name string PATH '/Name', 
		Abbreviation string PATH '/Abbreviation', 
		Capital string PATH '/Capital', 
		YearOfStatehood biginteger PATH '/YearOfStatehood') AS t;
END      /US_States/stateServiceView.xmi GetAllStateInfo_response ¡10 
T STATESERVICEVIEW.GETALLSTATEINFO mmuuid:837a75c2-d3dd-4b16-8147-a3e63437e747 mmuuid:31f26c55-cbb2-42a1-92dc-f1867d4f9838 CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT t.* FROM
		TABLE(EXEC stateServiceView.GetAllStateInfo_request())
				AS request,
		TABLE(EXEC stateService.invoke('SOAP11', 'http://www.teiid.org/stateService/GetStateInfo', REQUEST.xml_out, null))
				AS response,
		TABLE(EXEC stateServiceView.GetAllStateInfo_response(RESPONSE.result))
				AS t;
END      /US_States/stateServiceView.xmi GetAllStateInfo ¡10 
T STATESERVICEVIEW.GETSTATEINFO_REQUEST mmuuid:9d102f3b-e4e9-437b-b723-cb1af1f9f0f3 mmuuid:5e4ae79c-e359-4582-8d08-b8e1e8b7a038 CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT XMLELEMENT(NAME GetStateInfo, XMLNAMESPACES(DEFAULT 'http://www.teiid.org/stateService/'), XMLELEMENT(NAME stateCode, XMLNAMESPACES(NO DEFAULT), stateServiceView.GetStateInfo_request.stateCode)) AS xml_out;
END      /US_States/stateServiceView.xmi GetStateInfo_request ¡10 
T STATESERVICEVIEW.GETSTATEINFO_RESPONSE mmuuid:6af790ef-8eb7-4fa5-9884-2875cd4cd42d mmuuid:423f112b-28a3-46b5-a9d5-eebfda0e9e4a CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT t.* FROM
		XMLTABLE(XMLNAMESPACES('http://www.teiid.org/stateService/' AS ns) , '/ns:GetStateInfoResponse/StateInfo' PASSING stateServiceView.GetStateInfo_response.xml_in 
	COLUMNS 
		Name string PATH '/Name', 
		Abbreviation string PATH '/Abbreviation', 
		Capital string PATH '/Capital', 
		YearOfStatehood biginteger PATH '/YearOfStatehood') AS t;
END      /US_States/stateServiceView.xmi GetStateInfo_response ¡10 
T STATESERVICEVIEW.GETSTATEINFO mmuuid:435ef4d5-0336-4605-969c-6d1b7d0132ca mmuuid:cdb1df19-0fb5-42bb-a079-37eb614a6abb CREATE VIRTUAL PROCEDURE
BEGIN
	SELECT t.* FROM
		TABLE(EXEC stateServiceView.GetStateInfo_request(				stateServiceView.GetStateInfo.stateCode))
				AS request,
		TABLE(EXEC stateService.invoke('SOAP11', 'http://www.teiid.org/stateService/GetStateInfo', REQUEST.xml_out, null))
				AS response,
		TABLE(EXEC stateServiceView.GetStateInfo_response(RESPONSE.result))
				AS t;
END      /US_States/stateServiceView.xmi GetStateInfo ¡10