Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. Appendix A: XML Datatype Reference
  10. Appendix B: XPath Query Functions Reference

XML Guide

XML Guide

XPath Query Predicate Rules and Guidelines

XPath Query Predicate Rules and Guidelines

Use the following rules and guidelines when you create an XPath query predicate:
  • You can configure an XPath query predicate for any element in a view row.
    For example, if a view row is Company/Dept, you can create the following XPath query predicate:
    COMPANY[./DEPT=100]
  • You can match content.
  • You can add an XPath query predicate to a column if the column occurs below the view row in the view XML hierarchy and the column XPath includes the view row.
    For example, if the view row is Product/Toys[1], you can create the following XPath query predicate:
    Product/Toys[1][./Sales > 100]
    The following example shows an invalid XPath query predicate for the Product/Toys[1] view row:
    Product/Toys[2][./Sales > 100]
    Product/Toys[1] is the view row. You cannot use Product/Toys[2].
  • Use a single-occurring element or attribute. You cannot create an XPath query predicate on a multiple-occurring element.
  • You cannot create an XPath predicate query on an enclosure element because an enclosure element contains no values.

0 COMMENTS

We’d like to hear from you!