relmdVendorRules.xsd 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!--
  3. Licensed Materials - Property of IBM
  4. IBM Cognos Products: relmd
  5. (C) Copyright IBM Corp. 2008, 2015
  6. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  7. -->
  8. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" targetNamespace="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" elementFormDefault="qualified" attributeFormDefault="qualified">
  9. <xs:include schemaLocation="../../../webcontent/relmd/metadata/import_/relmdMetadataImportRules.xsd"/>
  10. <xs:include schemaLocation="../../../webcontent/relmd/metadata/browse/relmdMetadataBrowseRules.xsd"/>
  11. <!--
  12. Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  13. Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  14. Relational metadata database extraction rules.
  15. -->
  16. <xs:element name="vendorRules">
  17. <xs:complexType>
  18. <xs:sequence>
  19. <xs:group ref="sessionQueryRules"/>
  20. <xs:group ref="metadataImportRules"/>
  21. <xs:group ref="metadataBrowseRules"/>
  22. <xs:element name="driverClass" maxOccurs="unbounded">
  23. <xs:complexType>
  24. <xs:attribute name="className" type="xs:string" use="required"/>
  25. </xs:complexType>
  26. </xs:element>
  27. </xs:sequence>
  28. </xs:complexType>
  29. </xs:element>
  30. <xs:group name="sessionQueryRules">
  31. <xs:sequence>
  32. <xs:element name="caseSensitivityRules">
  33. <xs:complexType>
  34. <xs:attribute name="storage" use="required">
  35. <xs:simpleType>
  36. <xs:restriction base="xs:NMTOKEN">
  37. <xs:enumeration value="none"/>
  38. <xs:enumeration value="upper"/>
  39. <xs:enumeration value="lower"/>
  40. </xs:restriction>
  41. </xs:simpleType>
  42. </xs:attribute>
  43. <xs:attribute name="conversionType" default="sql">
  44. <xs:simpleType>
  45. <xs:restriction base="xs:NMTOKEN">
  46. <xs:enumeration value="sql"/>
  47. <xs:enumeration value="java"/>
  48. </xs:restriction>
  49. </xs:simpleType>
  50. </xs:attribute>
  51. </xs:complexType>
  52. </xs:element>
  53. <xs:element name="codePageRules" minOccurs="0">
  54. <xs:complexType>
  55. <xs:attribute name="value">
  56. <xs:simpleType>
  57. <xs:restriction base="xs:NMTOKEN">
  58. <xs:enumeration value="unicode"/>
  59. <xs:enumeration value="nonUnicode"/>
  60. </xs:restriction>
  61. </xs:simpleType>
  62. </xs:attribute>
  63. </xs:complexType>
  64. </xs:element>
  65. <xs:element name="defaultCatalogSchemaQueryRules" minOccurs="0">
  66. <xs:complexType>
  67. <xs:sequence>
  68. <xs:group ref="sql">
  69. <xs:annotation>
  70. <xs:documentation>sql that operates on a "per database" level.</xs:documentation>
  71. </xs:annotation>
  72. </xs:group>
  73. </xs:sequence>
  74. </xs:complexType>
  75. </xs:element>
  76. <xs:element name="catalogGranularityRules" minOccurs="0">
  77. <xs:complexType>
  78. <xs:sequence>
  79. <xs:group ref="currentCatalogSetupRules"/>
  80. <xs:element name="accessibleCatalogsQueryRules">
  81. <xs:complexType>
  82. <xs:choice>
  83. <xs:group ref="javaFunction"/>
  84. <xs:group ref="sql">
  85. <xs:annotation>
  86. <xs:documentation>sql that operates on a "per database" level.</xs:documentation>
  87. </xs:annotation>
  88. </xs:group>
  89. </xs:choice>
  90. </xs:complexType>
  91. </xs:element>
  92. </xs:sequence>
  93. </xs:complexType>
  94. </xs:element>
  95. </xs:sequence>
  96. </xs:group>
  97. <xs:group name="datatypeMappingRulesSequenceGroup">
  98. <xs:choice>
  99. <xs:element name="dataTypeMapping">
  100. <xs:complexType>
  101. <xs:sequence>
  102. <xs:element name="nativeType" maxOccurs="unbounded">
  103. <xs:complexType>
  104. <xs:sequence minOccurs="0">
  105. <xs:element name="precision" minOccurs="0">
  106. <xs:complexType>
  107. <xs:attributeGroup ref="numericRange"/>
  108. </xs:complexType>
  109. </xs:element>
  110. <xs:element name="length" minOccurs="0">
  111. <xs:complexType>
  112. <xs:attributeGroup ref="numericRange"/>
  113. </xs:complexType>
  114. </xs:element>
  115. <xs:element name="scale" minOccurs="0">
  116. <xs:complexType>
  117. <xs:attributeGroup ref="numericRange"/>
  118. </xs:complexType>
  119. </xs:element>
  120. </xs:sequence>
  121. <xs:attribute name="value" use="required"/>
  122. <xs:attribute name="comparison" default="equals">
  123. <xs:simpleType>
  124. <xs:restriction base="xs:NMTOKEN">
  125. <xs:enumeration value="equals"/>
  126. <xs:enumeration value="matches"/>
  127. </xs:restriction>
  128. </xs:simpleType>
  129. </xs:attribute>
  130. </xs:complexType>
  131. </xs:element>
  132. </xs:sequence>
  133. <xs:attribute name="cclType" type="cclDataTypes" use="required"/>
  134. <xs:attribute name="fmType" type="fmDataTypes" use="required"/>
  135. </xs:complexType>
  136. </xs:element>
  137. </xs:choice>
  138. </xs:group>
  139. <xs:simpleType name="cclDataTypes">
  140. <xs:restriction base="xs:NMTOKEN">
  141. <xs:enumeration value="unknown"/>
  142. <xs:enumeration value="string"/>
  143. <xs:enumeration value="int8"/>
  144. <xs:enumeration value="uint8"/>
  145. <xs:enumeration value="int16"/>
  146. <xs:enumeration value="uint16"/>
  147. <xs:enumeration value="int32"/>
  148. <xs:enumeration value="uint32"/>
  149. <xs:enumeration value="int64"/>
  150. <xs:enumeration value="uint64"/>
  151. <xs:enumeration value="float_"/>
  152. <xs:enumeration value="double_"/>
  153. <xs:enumeration value="decimal"/>
  154. <xs:enumeration value="date"/>
  155. <xs:enumeration value="time"/>
  156. <xs:enumeration value="dateTime"/>
  157. <xs:enumeration value="timeStamp"/>
  158. <xs:enumeration value="dtInterval"/>
  159. <xs:enumeration value="ymInterval"/>
  160. <xs:enumeration value="blob"/>
  161. <xs:enumeration value="rowIterator"/>
  162. <xs:enumeration value="dimIterator"/>
  163. <xs:enumeration value="masterDataset"/>
  164. <xs:enumeration value="variant"/>
  165. <xs:enumeration value="binary"/>
  166. <xs:enumeration value="varBinary"/>
  167. <xs:enumeration value="memberUniqueName"/>
  168. <xs:enumeration value="memberCaption"/>
  169. <xs:enumeration value="dimensionUniqueName"/>
  170. <xs:enumeration value="parentUniqueName"/>
  171. <xs:enumeration value="description"/>
  172. <xs:enumeration value="hierarchyUniqueName"/>
  173. <xs:enumeration value="parentLevel"/>
  174. <xs:enumeration value="levelUniqueName"/>
  175. <xs:enumeration value="levelNumber"/>
  176. <xs:enumeration value="levelLabel"/>
  177. <xs:enumeration value="formattedValue"/>
  178. <xs:enumeration value="font"/>
  179. <xs:enumeration value="foreColor"/>
  180. <xs:enumeration value="backColor"/>
  181. <xs:enumeration value="fontFlags"/>
  182. <xs:enumeration value="ordinal"/>
  183. <xs:enumeration value="nestedDim"/>
  184. <xs:enumeration value="numberOfParents"/>
  185. <xs:enumeration value="memberType"/>
  186. <xs:enumeration value="hasChildren"/>
  187. <xs:enumeration value="externalBuffer"/>
  188. <xs:enumeration value="textBlob"/>
  189. <xs:enumeration value="mime"/>
  190. <xs:enumeration value="url"/>
  191. <xs:enumeration value="currency"/>
  192. <xs:enumeration value="measureItem"/>
  193. <xs:enumeration value="boolean_"/>
  194. <xs:enumeration value="timeTZ"/>
  195. <xs:enumeration value="timeStampTZ"/>
  196. <xs:enumeration value="numeric"/>
  197. <xs:enumeration value="nChar"/>
  198. <xs:enumeration value="nVarChar"/>
  199. <xs:enumeration value="date2"/>
  200. <xs:enumeration value="time2"/>
  201. <xs:enumeration value="timestamp2"/>
  202. <xs:enumeration value="interval2"/>
  203. <xs:enumeration value="xml"/>
  204. <xs:enumeration value="row"/>
  205. <xs:enumeration value="array"/>
  206. <xs:enumeration value="multiset"/>
  207. </xs:restriction>
  208. </xs:simpleType>
  209. <xs:simpleType name="fmDataTypes">
  210. <xs:restriction base="xs:NMTOKEN">
  211. <xs:enumeration value="unknown"/>
  212. <xs:enumeration value="unsupported"/>
  213. <xs:enumeration value="int16"/>
  214. <xs:enumeration value="int32"/>
  215. <xs:enumeration value="int64"/>
  216. <xs:enumeration value="decimal"/>
  217. <xs:enumeration value="numeric"/>
  218. <xs:enumeration value="float_"/>
  219. <xs:enumeration value="float32"/>
  220. <xs:enumeration value="float64"/>
  221. <xs:enumeration value="binary"/>
  222. <xs:enumeration value="binaryLength16"/>
  223. <xs:enumeration value="date"/>
  224. <xs:enumeration value="time"/>
  225. <xs:enumeration value="dateTime"/>
  226. <xs:enumeration value="timeInterval"/>
  227. <xs:enumeration value="character"/>
  228. <xs:enumeration value="characterLength16"/>
  229. <xs:enumeration value="characterLength32"/>
  230. <xs:enumeration value="blob"/>
  231. <xs:enumeration value="textBlob"/>
  232. <xs:enumeration value="blobArray"/>
  233. <xs:enumeration value="databaseKey"/>
  234. <xs:enumeration value="varBit"/>
  235. <xs:enumeration value="bit"/>
  236. <xs:enumeration value="boolean_"/>
  237. <xs:enumeration value="timeTZ"/>
  238. <xs:enumeration value="timeStampTZ"/>
  239. <xs:enumeration value="intervalYM"/>
  240. <xs:enumeration value="nChar"/>
  241. <xs:enumeration value="nVarChar"/>
  242. </xs:restriction>
  243. </xs:simpleType>
  244. <xs:attributeGroup name="numericRange">
  245. <xs:attribute name="min" use="required"/>
  246. <xs:attribute name="max" use="required"/>
  247. </xs:attributeGroup>
  248. <xs:group name="currentCatalogSetupRules">
  249. <xs:sequence>
  250. <xs:element name="currentCatalogGetRules">
  251. <xs:complexType>
  252. <xs:sequence>
  253. <xs:group ref="sql">
  254. <xs:annotation>
  255. <xs:documentation>sql that operates on a "per database" level.</xs:documentation>
  256. </xs:annotation>
  257. </xs:group>
  258. </xs:sequence>
  259. </xs:complexType>
  260. </xs:element>
  261. <xs:element name="currentCatalogSetRules">
  262. <xs:complexType>
  263. <xs:sequence>
  264. <xs:group ref="catalogGrainSql">
  265. <xs:annotation>
  266. <xs:documentation>sql that operates on a "per catalog" level.</xs:documentation>
  267. </xs:annotation>
  268. </xs:group>
  269. </xs:sequence>
  270. </xs:complexType>
  271. </xs:element>
  272. </xs:sequence>
  273. </xs:group>
  274. </xs:schema>