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

ceiling

ceiling

Rounds a number to the smallest integer that is greater than or equal to the passed number.

Syntax

ceiling (
number
)
The following table describes the argument for this function:
Argument
Description
number
Numeric value. The number you want to round.

Return Value

Integer.

Example

The following expression returns the price rounded to the smallest integer:
ceiling ( PRICE )
The following table contains example arguments and return values:
PRICE
RETURN VALUE
39.79
40
125.12
126
74.24
75
NULL
NULL
-100.99
-100
100
100

0 COMMENTS

We’d like to hear from you!