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. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

not

not

Returns the inverse of a Boolean condition. The function returns TRUE if a condition is false, and returns FALSE if a condition is true.

Syntax

not (
condition
)
The following table describes the argument for this function:
Argument
Description
condition
Boolean expression or value.

Return Value

Boolean.
NULL if the condition is NULL.

Example

The following expression returns the inverse of a Boolean condition:
not ( EMPLOYEE = concat ( FIRSTNAME, LASTNAME ))
The following table contains example arguments and return values:
EMPLOYEE
FIRSTNAME
LASTNAME
RETURN
Fullname
Full
Name
FALSE
Lastname
Lastname
First
TRUE

0 COMMENTS

We’d like to hear from you!