tsd:nodeSQL

Purpose This element carries the mapping information for a node in the XML sub-tree that is mapped to a single SQL column. To be used to specify mapping for logical child nodes of a logical node mapped via tsd:subTreeSQL.
Parent element tsd:map
Child elements None
Attributes column
Attributes
Name Type Description
column xs:string This attribute specifies the column in an SQL database to which an element or attribute in the Tamino database is mapped.

Example

The following code fragment of a Tamino schema definition shows the code necessary to define a mapping of an element to an SQL column "Last Name" via X-Node:

<xs:element name = "lastname" type = "xs:string">
  <xs:annotation>
    <xs:appinfo>
      <tsd:elementInfo>
        <tsd:logical>
          .
          .
          .
        </tsd:logical>
        <tsd:physical>
          <tsd:map>
            <tsd:nodeSQL column = "Last Name"></tsd:nodeSQL>
          </tsd:map>
        </tsd:physical>
      </tsd:elementInfo
    </xs:appinfo>
  </xs:annotation>
</xs:element>