GRANT SELECT ON stores_demo_rdf.inf10ma.items TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.catalog TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.msgs TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.state TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.orders TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.stock TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.customer TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.call_type TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.manufact TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON stores_demo_rdf.inf10ma.cust_calls TO "SPARQL", "SPARQL_UPDATE";
GRANT SPARQL_UPDATE to "SPARQL";
create function DB.DBA.CUST_CALLS_IRI (in customer_num integer, in call_dtime datetime) returns varchar
{
declare _call_dtime any;
_call_dtime := cast(call_dtime as varchar);
return sprintf('http://localhost:8890/informix/stores_demo/cust_calls#%d_%U', customer_num, _call_dtime);
};
create function DB.DBA.CUST_CALLS_IRI_INV_1 (in cust_calls_iri varchar) returns integer
{
declare parts any;
parts := sprintf_inverse(cust_calls_iri, 'http://localhost:8890/informix/stores_demo/cust_calls#%d_%U', 1);
if(parts is not null)
{
return parts[0];
}
return NULL;
};
create function DB.DBA.CUST_CALLS_IRI_INV_2 (in cust_calls_iri varchar) returns datetime
{
declare parts any;
parts := sprintf_inverse(cust_calls_iri, 'http://localhost:8890/informix/stores_demo/cust_calls#%d_%U', 1);
if(parts is not null)
{
return parts[1];
}
return NULL;
};
grant execute on DB.DBA.CUST_CALLS_IRI to "SPARQL", "SPARQL_UPDATE";
grant execute on DB.DBA.CUST_CALLS_IRI_INV_1 to "SPARQL", "SPARQL_UPDATE";
grant execute on DB.DBA.CUST_CALLS_IRI_INV_2 to "SPARQL", "SPARQL_UPDATE";
-------- Create rdfs:Class definitions ----------------------------
ttlp (
'
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix items: <http://localhost:8890/informix/schemas/items#> .
@prefix catalog: <http://localhost:8890/informix/schemas/catalog#> .
@prefix stock: <http://localhost:8890/informix/schemas/stock#> .
@prefix msgs: <http://localhost:8890/informix/schemas/msgs#> .
@prefix state: <http://localhost:8890/informix/schemas/state#> .
@prefix orders: <http://localhost:8890/informix/schemas/orders#> .
@prefix manuf: <http://localhost:8890/informix/schemas/manufact#> .
@prefix cust: <http://localhost:8890/informix/schemas/customer#> .
@prefix callt: <http://localhost:8890/informix/schemas/call_type#> .
@prefix custc: <http://localhost:8890/informix/schemas/cust_calls#> .
items:Items a rdfs:Class ;
rdfs:label "Items" ;
rdfs:comment "Informix SD items table" .
items:item_num a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range xsd:integer ;
rdfs:label "ITEM NUMBER" .
items:quantity a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range xsd:integer ;
rdfs:label "QUANTITY" .
items:total_price a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range xsd:decimal ;
rdfs:label "TOTAL PRICE" .
items:order_num_fk a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range orders:Orders ;
rdfs:label "ORDER NUMBER" .
items:stock_num_fk a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range stock:Stock ;
rdfs:label "STOCK NUMBER" .
items:manu_code_fk a rdf:Property ;
rdfs:domain items:Items ;
rdfs:range stock:Stock ;
rdfs:label "MANUAL CODE" .
catalog:Catalog a rdfs:Class ;
rdfs:label "catalog" ;
rdfs:comment "Informix SD catalog table" .
catalog:manu_code a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range xsd:integer ;
rdfs:label "MANUAL CODE" .
catalog:cat_descr a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range xsd:string ;
rdfs:label "CATALOG DESCRIPTION" .
catalog:cat_picture a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range xsd:byte ;
rdfs:label "CATALOG PICTURE" .
catalog:cat_advert a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range xsd:string ;
rdfs:label "CATALOG ADVERT" .
catalog:catalog_num_fk a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range stock:Stock ;
rdfs:label "CATALOG NUMBER" .
catalog:stock_num_fk a rdf:Property ;
rdfs:domain catalog:Catalog ;
rdfs:range stock:Stock ;
rdfs:label "STOCK NUMBER" .
msgs:Msgs a rdfs:Class ;
rdfs:label "Msgs" ;
rdfs:comment "Informix SD msgs table" .
msgs:lang a rdf:Property ;
rdfs:domain msgs:Msgs ;
rdfs:range xsd:string ;
rdfs:label "LANGUAGE" .
msgs:number a rdf:Property ;
rdfs:domain msgs:Msgs ;
rdfs:range xsd:integer ;
rdfs:label "NUMBER" .
msgs:message a rdf:Property ;
rdfs:domain msgs:Msgs ;
rdfs:range xsd:string ;
rdfs:label "MESSAGE" .
state:State a rdfs:Class ;
rdfs:label "State" ;
rdfs:comment "Informix SD state table" .
state:code a rdf:Property ;
rdfs:domain state:State ;
rdfs:range xsd:string ;
rdfs:label "STATE CODE" .
state:sname a rdf:Property ;
rdfs:domain state:State ;
rdfs:range xsd:string ;
rdfs:label "STATE NAME" .
orders:Orders a rdfs:Class ;
rdfs:label "Orders" ;
rdfs:comment "Informix SD orders table" .
orders:order_num a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:integer ;
rdfs:label "ORDER NUMBER" .
orders:order_date a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:date ;
rdfs:label "ORDER DATE" .
orders:ship_instruct a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:string ;
rdfs:label "SHIPPING INSTRUCTION" .
orders:backlog a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:string ;
rdfs:label "BACKLOG" .
orders:po_num a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:string ;
rdfs:label "PURCHASE ORDER NUMBER" .
orders:ship_date a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:date ;
rdfs:label "SHIPPING DATE" .
orders:ship_weight a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:decimal ;
rdfs:label "SHIPPING WEIGHT" .
orders:ship_charge a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:decimal ;
rdfs:label "SHIPPING CHARGE" .
orders:paid_date a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range xsd:date ;
rdfs:label "PAID DATE" .
orders:customer_num_fk a rdf:Property ;
rdfs:domain orders:Orders ;
rdfs:range cust:Customer ;
rdfs:label "CUSTOMER NUMBER" .
stock:Stock a rdfs:Class ;
rdfs:label "Stock" ;
rdfs:comment "Informix SD stock table" .
stock:stock_num a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range xsd:integer ;
rdfs:label "STOCK NUMBER" .
stock:description a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range xsd:string ;
rdfs:label "DESCRIPTION" .
stock:unit_price a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range xsd:decimal ;
rdfs:label "UNIT PRICE" .
stock:unit a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range xsd:string ;
rdfs:label "UNIT" .
stock:unit_descr a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range xsd:decimal ;
rdfs:label "UNIT DESCRIPTION" .
stock:manu_code_fk a rdf:Property ;
rdfs:domain stock:Stock ;
rdfs:range manuf:Manufact ;
rdfs:label "MANUAL CODE" .
cust:Customer a rdfs:Class ;
rdfs:label "Customer" ;
rdfs:comment "Informix SD customer table" .
cust:customer_num a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:integer ;
rdfs:label "CUSTOMER NUMBER" .
cust:fname a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "FIRST NAME" .
cust:lname a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "LAST NAME" .
cust:company a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "COMPANY" .
cust:address1 a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "ADDRESS1" .
cust:address2 a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "ADDRESS2" .
cust:city a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "CITY" .
cust:state a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "STATE" .
cust:zipcode a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "ZIP CODE" .
cust:phone a rdf:Property ;
rdfs:domain cust:Customer ;
rdfs:range xsd:string ;
rdfs:label "PHONE NUMBER" .
callt:Call_type a rdfs:Class ;
rdfs:label "Call_type" ;
rdfs:comment "Informix SD call_type table" .
callt:call_code a rdf:Property ;
rdfs:domain callt:Call_type ;
rdfs:range xsd:string ;
rdfs:label "CALL CODE" .
callt:code_descr a rdf:Property ;
rdfs:domain callt:Call_type ;
rdfs:range xsd:string ;
rdfs:label "CODE DESCRIPTION" .
manuf:Manufact a rdfs:Class ;
rdfs:label "Manufact" ;
rdfs:comment "Informix SD manufact table" .
manuf:manu_code a rdf:Property ;
rdfs:domain manuf:Manufact ;
rdfs:range xsd:string ;
rdfs:label "MANUFACTURE CODE" .
manuf:manu_name a rdf:Property ;
rdfs:domain manuf:Manufact ;
rdfs:range xsd:string ;
rdfs:label "MANUFACTURE NAME" .
manuf:lead_time a rdf:Property ;
rdfs:domain manuf:Manufact ;
rdfs:range xsd:integer ;
rdfs:label "LEAD TIME" .
custc:Cust_calls a rdfs:Class ;
rdfs:label "Cust_calls" ;
rdfs:comment "Informix SD cust_calls table" .
custc:call_dtime a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range xsd:datetime ;
rdfs:label "CALL TIME" .
custc:user_id a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range xsd:string ;
rdfs:label "USER ID" .
custc:call_descr a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range xsd:string ;
rdfs:label "CALL DESCRIPTION" .
custc:res_dtime a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range xsd:datetime ;
rdfs:label "RES TIME" .
custc:res_descr a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range xsd:string ;
rdfs:label "RES DESCRIPTION" .
custc:customer_num_fk a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range cust:Customer ;
rdfs:label "CUSTOMER NUM" .
custc:call_code_fk a rdf:Property ;
rdfs:domain manuf:Cust_calls ;
rdfs:range callt:Call_type ;
rdfs:label "CALL CODE" .
', '', 'http://^{URIQADefaultHost}^/schemas/istores_demo#', 0);
----------- Create IRI Classes -------------
sparql
prefix items: <http://localhost:8890/informix/schemas/items#>
prefix catalog: <http://localhost:8890/informix/schemas/catalog#>
prefix stock: <http://localhost:8890/informix/schemas/stock#>
prefix msgs: <http://localhost:8890/informix/schemas/msgs#>
prefix state: <http://localhost:8890/informix/schemas/state#>
prefix orders: <http://localhost:8890/informix/schemas/orders#>
prefix manuf: <http://localhost:8890/informix/schemas/manufact#>
prefix cust: <http://localhost:8890/informix/schemas/customer#>
prefix callt: <http://localhost:8890/informix/schemas/call_type#>
prefix custc: <http://localhost:8890/informix/schemas/cust_calls#>
create iri class items:items_iri
"http://localhost:8890/informix/stores_demo/items#%d_%d"
(in item_num integer not null, in order_num integer not null) .
create iri class catalog:catalog_iri
"http://localhost:8890/informix/stores_demo/catalog#%d"
(in catalog_num integer not null) .
create iri class msgs:msgs_iri
"http://localhost:8890/informix/stores_demo/msgs#%U_%d_%U"
(in _lang varchar not null, in number integer not null, in message varchar not null) .
create iri class state:state_iri
"http://localhost:8890/informix/stores_demo/state#%U"
(in code varchar not null) .
create iri class orders:orders_iri
"http://localhost:8890/informix/stores_demo/orders#%d"
(in order_num varchar not null) .
create iri class stock:stock_iri
"http://localhost:8890/informix/stores_demo/stock#%d_%U"
(in stock_num integer not null, in manu_code varchar not null) .
create iri class cust:customer_iri
"http://localhost:8890/informix/stores_demo/customer#%d"
(in customer_num integer not null) .
create iri class callt:call_type_iri
"http://localhost:8890/informix/stores_demo/call_type#%U"
(in call_code varchar not null) .
create iri class manuf:manufact_iri
"http://localhost:8890/informix/stores_demo/manufact#%U"
(in manu_code varchar not null) .
create iri class custc:cust_calls_iri using
function DB.DBA.CUST_CALLS_IRI (in customer_num integer, in call_dtime datetime) returns varchar,
function DB.DBA.CUST_CALLS_IRI_INV_1 (in cust_calls_iri varchar) returns integer,
function DB.DBA.CUST_CALLS_IRI_INV_2 (in cust_calls_iri varchar) returns datetime .
;
------------- Create Quad Store ------------------------------------
sparql
prefix items: <http://localhost:8890/informix/schemas/items#>
prefix catalog: <http://localhost:8890/informix/schemas/catalog#>
prefix stock: <http://localhost:8890/informix/schemas/stock#>
prefix msgs: <http://localhost:8890/informix/schemas/msgs#>
prefix state: <http://localhost:8890/informix/schemas/state#>
prefix orders: <http://localhost:8890/informix/schemas/orders#>
prefix manuf: <http://localhost:8890/informix/schemas/manufact#>
prefix cust: <http://localhost:8890/informix/schemas/customer#>
prefix callt: <http://localhost:8890/informix/schemas/call_type#>
prefix custc: <http://localhost:8890/informix/schemas/cust_calls#>
alter quad storage virtrdf:DefaultQuadStorage
from stores_demo_rdf.inf10ma.items as items_tbl
from stores_demo_rdf.inf10ma.catalog as catalog_tbl
from stores_demo_rdf.inf10ma.msgs as msgs_tbl
from stores_demo_rdf.inf10ma.state as state_tbl
from stores_demo_rdf.inf10ma.orders as orders_tbl
from stores_demo_rdf.inf10ma.stock as stock_tbl
from stores_demo_rdf.inf10ma.customer as customer_tbl
from stores_demo_rdf.inf10ma.call_type as call_type_tbl
from stores_demo_rdf.inf10ma.manufact as manufact_tbl
from stores_demo_rdf.inf10ma.cust_calls as cust_calls_tbl
{
create virtrdf:informix_stores_demo as graph <http://localhost:8890/informix/stores_demo/>
{
items:items_iri (items_tbl.item_num, items_tbl.order_num) a items:Items as virtrdf:items_pk ;
items:stock_num items_tbl.stock_num as virtrdf:items_stock_num ;
items:manu_code items_tbl.manu_code as virtrdf:items_manu_code ;
items:quantity items_tbl.quantity as virtrdf:items_quantity ;
items:total_price items_tbl.total_price as virtrdf:items_total_price ;
items:from_order orders:orders_iri (orders_tbl.order_num) where (^{items_tbl.}^.order_num = ^{orders_tbl.}^.order_num) as virtrdf:Item-from_order;
items:has_stock stock:stock_iri (stock_tbl.stock_num, stock_tbl.manu_code) where (^{items_tbl.}^.stock_num = ^{stock_tbl.}^.stock_num and ^{items_tbl.}^.manu_code = ^{stock_tbl.}^.manu_code) as virtrdf:Item-has_stock .
catalog:catalog_iri (catalog_tbl.catalog_num) a catalog:Catalog as virtrdf:catalog_num;
catalog:stock_num catalog_tbl.stock_num as virtrdf:catalog_stock_num ;
catalog:manu_code catalog_tbl.manu_code as virtrdf:catalog_manu_code ;
catalog:cat_descr catalog_tbl.cat_descr as virtrdf:catalog_cat_descr ;
catalog:quantity catalog_tbl.cat_picture as virtrdf:catalog_cat_picture ;
catalog:total_price catalog_tbl.cat_advert as virtrdf:catalog_cat_advert ;
catalog:has_stock stock:stock_iri (stock_tbl.stock_num, stock_tbl.manu_code) where (^{catalog_tbl.}^.stock_num = ^{stock_tbl.}^.stock_num and ^{catalog_tbl.}^.manu_code = ^{stock_tbl.}^.manu_code) as virtrdf:catalog-has_stock .
msgs:msgs_iri (msgs_tbl.lang, msgs_tbl.number, msgs_tbl.message) a msgs:Msgs as virtrdf:msgs_pk .
state:state_iri (state_tbl.code) a state:State as virtrdf:code ;
state:sname state_tbl.sname as virtrdf:state_sname .
orders:orders_iri (orders_tbl.order_num) a orders:Orders as virtrdf:order_num ;
orders:order_date orders_tbl.order_date as virtrdf:orders_order_date ;
orders:customer_num orders_tbl.customer_num as virtrdf:orders_customer_num ;
orders:ship_instruct orders_tbl.ship_instruct as virtrdf:orders_ship_instruct ;
orders:backlog orders_tbl.backlog as virtrdf:orders_backlog ;
orders:po_num orders_tbl.po_num as virtrdf:orders_po_num ;
orders:ship_date orders_tbl.ship_date as virtrdf:orders_ship_date ;
orders:ship_weight orders_tbl.ship_weight as virtrdf:orders_ship_weight ;
orders:ship_charge orders_tbl.ship_charge as virtrdf:orders_ship_charge ;
orders:paid_date orders_tbl.paid_date as virtrdf:orders_paid_date ;
orders:has_customer cust:customer_iri (customer_tbl.customer_num) where (^{orders_tbl.}^.customer_num = ^{customer_tbl.}^.customer_num) as virtrdf:Orders-has_customer .
stock:stock_iri (stock_tbl.stock_num, stock_tbl.manu_code) a stock:Stock as virtrdf:stock_pk ;
stock:description stock_tbl.description as virtrdf:stock_description ;
stock:unit_price stock_tbl.unit_price as virtrdf:stock_unit_price ;
stock:unit stock_tbl.unit as virtrdf:stock_unit ;
stock:unit_descr stock_tbl.unit_descr as virtrdf:stock_unit_descr ;
stock:has_manufacturer manuf:manufact_iri (manufact_tbl.manu_code) where (^{stock_tbl.}^.manu_code = ^{manufact_tbl.}^.manu_code) as virtrdf:Stock-has_manufacturer .
cust:customer_iri (customer_tbl.customer_num) a cust:Customer as virtrdf:customer_num ;
cust:fname customer_tbl.fname as virtrdf:customer_fname ;
cust:lname customer_tbl.lname as virtrdf:customer_lname ;
cust:company customer_tbl.company as virtrdf:customer_company ;
cust:address1 customer_tbl.address2 as virtrdf:customer_address1 ;
cust:address2 customer_tbl.address2 as virtrdf:customer_address2 ;
cust:city customer_tbl.city as virtrdf:customer_city ;
cust:state customer_tbl.state as virtrdf:customer_state ;
cust:zipcode customer_tbl.zipcode as virtrdf:customer_zipcode ;
cust:phone customer_tbl.phone as virtrdf:customer_phone .
callt:call_type_iri (call_type_tbl.call_code) a callt:Call_type as virtrdf:call_code ;
callt:code_descr call_type_tbl.code_descr as virtrdf:call_type_code_descr .
manuf:manufact_iri (manufact_tbl.manu_code) a manuf:Manufact as virtrdf:manu_code ;
manuf:manu_name manufact_tbl.manu_name as virtrdf:manufact_tbl_manu_name ;
manuf:lead_time manufact_tbl.lead_time as virtrdf:manufact_tbl_lead_time .
custc:cust_calls_iri (cust_calls_tbl.customer_num, cust_calls_tbl.call_dtime) a custc:Cust_calls as virtrdf:cust_calls_pk ;
custc:user_id cust_calls_tbl.user_id as virtrdf:cust_calls_user_id ;
custc:call_code cust_calls_tbl.call_code as virtrdf:cust_calls_call_code ;
custc:call_descr cust_calls_tbl.call_descr as virtrdf:cust_calls_call_descr ;
custc:res_dtime cust_calls_tbl.res_dtime as virtrdf:cust_calls_res_dtime ;
custc:res_descr cust_calls_tbl.res_descr as virtrdf:cust_calls_res_descr ;
custc:made_by_customer cust:customer_iri (customer_tbl.customer_num) where (^{cust_calls_tbl.}^.customer_num = ^{customer_tbl.}^.customer_num) as virtrdf:Cust_calls-made_by_customer ;
custc:is_call_type callt:call_type_iri (call_type_tbl.call_code) where (^{cust_calls_tbl.}^.call_code = ^{call_type_tbl.}^.call_code) as virtrdf:Cust_calls-is_call_type .
} .
} .
;
DB.DBA.XML_SET_NS_DECL ('items', 'http://localhost:8890/informix/schemas/items#', 2);
DB.DBA.XML_SET_NS_DECL ('catalog', 'http://localhost:8890/informix/schemas/catalog#', 2);
DB.DBA.XML_SET_NS_DECL ('stock', 'http://localhost:8890/informix/schemas/stock#', 2);
DB.DBA.XML_SET_NS_DECL ('msgs', 'http://localhost:8890/informix/schemas/msgs#', 2);
DB.DBA.XML_SET_NS_DECL ('state', 'http://localhost:8890/informix/schemas/state#', 2);
DB.DBA.XML_SET_NS_DECL ('orders', 'http://localhost:8890/informix/schemas/orders#', 2);
DB.DBA.XML_SET_NS_DECL ('manuf', 'http://localhost:8890/informix/schemas/manufact#', 2);
DB.DBA.XML_SET_NS_DECL ('cust', 'http://localhost:8890/informix/schemas/customer#', 2);
DB.DBA.XML_SET_NS_DECL ('callt', 'http://localhost:8890/informix/schemas/call_type#', 2);
DB.DBA.XML_SET_NS_DECL ('custc', 'http://localhost:8890/informix/schemas/cust_calls#', 2);
You are here: