element <sql>
Namespace:
http://www.lumis.com.br/lumisportal/xsd/component-install-script
Type:
embedded (extension of xsd:string)
Content:
simple, 1 attribute
Defined:
locally at 1 location
Includes:
definition of 1 attribute
XML Representation Summary
<sql
   
 database-type
 = 
("oracle" | "sqlserver" | "mysql")
   
>
   
Content: 
{ xsd:string }
</sql>
May be included in elements (1):
run-sql (type lum_runSqlStep)
Usage / Definition Locations
Annotation
Provides an SQL command to be ran. Although more than one "sql" element can be added, only one will be ran. The possibility of adding more than one "sql" element is to make it possible to have different versions of the same SQL to be executed in different database engines.
Embedded Type Detail
Type Derivation Tree
xsd:string
  complexType
Derivation:
extension of xsd:string
XML Source
<xsd:element maxOccurs="unbounded" name="sql">
<xsd:annotation>
<xsd:documentation>
Provides an SQL command to be ran. Although more than one "sql" element can be added, only one will be ran. The possibility of adding more than one "sql" element is to make it possible to have different versions of the same SQL to be executed in different database engines.
</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:simpleContent>
<xsd:extension base="xsd:string">
<xsd:attribute name="database-type">
<xsd:annotation>
<xsd:documentation>
<![CDATA[
Restricts this SQL execution to the given database.<br />
<ul>
<li>oracle: for Oracle database.</li>
<li>sqlserver: for Microsoft SQL Server database.</li>
<li>mysql: for MySQL database.</li>
</ul>
]]>
</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="oracle"/>
<xsd:enumeration value="sqlserver"/>
<xsd:enumeration value="mysql"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
</xsd:element>
Attribute Detail
database-type
Restricts this SQL execution to the given database.<br /> <ul> <li>oracle: for Oracle database.</li> <li>sqlserver: for Microsoft SQL Server database.</li> <li>mysql: for MySQL database.</li> </ul>
Type:
embedded
Use:
optional
Defined:
locally, within this element
XML Source
<xsd:attribute name="database-type">
<xsd:annotation>
<xsd:documentation>
<![CDATA[
Restricts this SQL execution to the given database.<br />
<ul>
<li>oracle: for Oracle database.</li>
<li>sqlserver: for Microsoft SQL Server database.</li>
<li>mysql: for MySQL database.</li>
</ul>
]]>
</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="oracle"/>
<xsd:enumeration value="sqlserver"/>
<xsd:enumeration value="mysql"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
Embedded Type
Derivation:
restriction of xsd:string
Facets:
enumeration:
"oracle", "sqlserver", "mysql"
XML Schema documentation generated with DocFlex/XML (Kit) v1.6.2
DocFlex/XML is a powerful template-driven documentation and report generator from any data stored in XML files. Based on an innovative technology developed by FILIGRIS WORKS, this new tool offers virtuoso data querying and formatting capabilities not found in anything else!
Need to convert your XML data into a clear nice-looking documentation or reports? Web-ready hypertext HTML or printable MS Word / OpenOffice.org friendly RTF? DocFlex/XML may be a cheap, quick and effective solution exactly for this task!
Have questions? Not sure how to use it? Just send us e-mail to contact@filigris.com and we are always happy to help you! See also our services at www.filigris.com

Lumisportal  10.2.0.170730 - Copyright © 2006–2017 Lumis EIP Tecnologia da Informação LTDA. All Rights Reserved.