12345678910111213141516171819202122 |
- #IBM Confidential
- #
- #OCO Source Materials
- #
- #BI and PM: rdbmscert
- #
- #(C) Copyright IBM Corp. 2009,2016
- #
- #The source code for this program is not published or otherwise divested of its trade secrets,
- #irrespective of what has been deposited with the U.S. Copyright Office
- #
- #
- # Numeric scalar functions
- #
- functions.Round[double,any]=CASE WHEN (%1$s) < 0 THEN (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) - 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) ELSE (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) + 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) END
- functions.Round[float,any]=CASE WHEN (%1$s) < 0 THEN (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) - 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) ELSE (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) + 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) END
- #
- #olsp functions
- #
- olap.FirstValue[any]=
- olap.LastValue[any]=
|