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

Functions

Functions

Use the following types of function in an XPath query predicate:
  • String.
    Use string functions to test substring values, concatenate strings, or translate strings into other strings. The following XPath query predicate determines if an employee’s full name is equal to the concatenation of last name and first name:
    EMPLOYEE[./FULLNAME=concat(./ENAME/LASTNAME,./ENAME/FIRSTNAME)]
  • Numeric.
    Use numeric functions with element and attribute values. Numeric functions operate on numbers and return integers. For example, the following XPath query predicate rounds discount and tests if the result is greater than 15:
    ORDER_ITEMS[round(./DISCOUNT > 15]
  • Boolean.
    Boolean functions return either true or false. Use them to test elements, check the language attribute, or force a true or false result. For example, a string is true if the string value is greater than zero:
    boolean(string)

0 COMMENTS

We’d like to hear from you!