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

round

round

Rounds a number to the nearest integer. If the number is between two integers, round returns the higher number.

Syntax

round (
number
)
The following table describes the argument for this function:
Argument
Description
number
Numeric value. Passes a numeric datatype or an expression that results in a number.

Return Value

Integer.

Example

The following expression rounds BANK_BALANCE:
round( BANK_BALANCE )
The following table contains example arguments and return values:
BANK_BALANCE
RETURN VALUE
12.34
12
12.50
13
-18.99
-19
NULL
NULL

0 COMMENTS

We’d like to hear from you!