quadbase.reportdesigner.lang

Class NumericObject

java.lang.Object

quadbase.reportdesigner.lang.NumericObject

All Implemented Interfaces:

IObject, IFunctionConstants

public class NumericObject
extends java.lang.Object
implements IObject, IFunctionConstants

This class is used to implement formulas for columns contain numeric data

Field Summary

Fields inherited from interface quadbase.util.IFunctionConstants

ABS, ACOS, ADD, ADDTIME, AM_PM, AND, ASIN, ATAN, ATAN2, AVERAGE, B_COL, BOOL, BOOL_FUNC, BOOL_NAME, CALENDAR_CONST, CEIL, COL, COS, COUNT, CURRDATE, CURRDATETIME, CURRTIME, D_COL, DATE, DATE_FUNC, DATE_NAME, DATETIME, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_WEEK_IN_MONTH, DAY_OF_YEAR, DAYDIFF, DAYOFWEEK, DECL, DIVIDE, E, EQUALS, ERA, EXP, FACTORIAL, FALSE, FLOOR, GETAMPM, GETERA, GETMONTH, GREATER, GREATEREQUAL, HOUR, HOUR_OF_DAY, ID, IEEEREMAINDER, IFELSE_B, IFELSE_D, IFELSE_N, IFELSE_S, INDEXOF, INSERT, LASTINDEXOF, LESS, LESSEQUAL, LOG, MAX, MAXLENGTH, MEDIAN, MILLISECOND, MIN, MINUTE, MOD, MONTH, MULTIPLY, N_COL, NAND, NEW_DATE_NAME, NEW_NUM_NAME, NEW_STR_NAME, NOR, NOT, NUM, NUM_FUNC, NUM_NAME, OR, OTHER_FUNC_NAME, PAGE, PARAM, PI, POW, PRINTDATE, PRINTDATETIME, PRINTTIME, RANDOM, REPLACE, RINT, ROLLTIME, S_COL, SECOND, SIN, SQRT, STDDEV, STR, STR_FUNC, STR_NAME, STRCAT, STRLEN, SUBSTRING, SUBTRACT, SUMSQUARE, TAN, TD_FUNC_NAME, THIS, TODATE, TODEGREES, TOLOWERCASE, TONUMERIC, TORADIANS, TOSTRING, TOTALPAGES, TOTALSECTIONS, TOUPPERCASE, TRUE, VARIANCE, WEEK_OF_MONTH, WEEK_OF_YEAR, WITHIN, XNOR, XOR, YEAR

Constructor Summary

Constructors

Modifier	Constructor and Description
	NumericObject(byte val) Create a new NumericObject using specified byte
	NumericObject(double number) Create a new NumericObject using specified double
	NumericObject(float number) Create a new NumericObject using specified float
	NumericObject(int number) Create a new NumericObject using specified int
	NumericObject(long number) Create a new NumericObject using specified long
	NumericObject(short number) Create a new NumericObject using specified short
protected	NumericObject(java.lang.String formula, int sqlType) Create a new NumericObject using specified formula and SQL type

Method Summary

Modifier and Type	Method and Description
static NumericObject	abs(NumericObject a) Absolute of the NumericObject
static NumericObject	acos(NumericObject a) Arc cosine of specified NumericObject
static NumericObject	add(NumericObject[] f) Add every element of the NumericObject array
static NumericObject	add(NumericObject f1, NumericObject f2) Add the two NumericObjects
static NumericObject	asin(NumericObject a) Arc sine of specified NumericObject
static NumericObject	atan(NumericObject a) Arc tan of specified NumericObject
static NumericObject	atan2(NumericObject a, NumericObject b) Arc tan of specified NumericObjects.
static NumericObject	average(NumericObject[] f) Average of the elements of the NumericObject array
static NumericObject	ceil(NumericObject a) Ceiling of the NumericObject
static NumericObject	cos(NumericObject a) Cosine of specified NumericObject
static NumericObject	count(NumericObject[] f) Number of elements in the NumericObject array
static NumericObject	divide(NumericObject numerator, NumericObject denominator) Divide numerator by denominator
static NumericObject	e() Base of natural log
static NumericObject	exp(NumericObject a) Exponential raised to the power of the NumericObject
static NumericObject	factorial(NumericObject a) Factorial of the specified NumericObject
static NumericObject	floor(NumericObject a) Floor of the NumericObject
static NumericObject	getColumnValue(int colInfoIndex) Returns the column value of the specific column
static NumericObject	getColumnValue(int colInfoIndex, int sqlType) Returns the column value of the specified column
static NumericObject	getColumnValue(int colInfoIndex, short aggregation) Returns the Column value of specified column after doing the specified aggregation.
static NumericObject	getColumnValue(int colInfoIndex, short aggregation, int sqlType) Returns the Column value of specified column after doing the specified aggregation.
static NumericObject	getColumnValue(NumericObject colInfoIndex, int sqlType) Returns the column value of the specified column
static NumericObject	getColumnValue(NumericObject colInfoIndex, short aggregation, int sqlType) Returns the Column value of specified column after doing the specified aggregation.
java.lang.String	getFormula() Returns the formula
int	getSQLType() Returns the SQL type
static NumericObject	IEEERemainder(NumericObject dividend, NumericObject divisor) Computes the remainder operator on two arguments based on the IEEE754 standard
static NumericObject	log(NumericObject a) Natural log of the NumericObject
static NumericObject	max(NumericObject[] f) Returns maximum from the elements of the NumericObject array
static NumericObject	max(NumericObject a, NumericObject b) Returns maximum from the two NumericObjects
static NumericObject	min(NumericObject[] f) Returns manimum from the elements of the NumericObject array
static NumericObject	min(NumericObject a, NumericObject b) Returns manimum from the two NumericObjects
static NumericObject	mod(NumericObject numerator, NumericObject denominator) Returns the remainder after dividing denominator from numerator
static NumericObject	multiply(NumericObject[] f) Multiply every element of the NumericObject array
static NumericObject	multiply(NumericObject f1, NumericObject f2) Multiply the two NumericObjects
static NumericObject	pi() Pi value
static NumericObject	pow(NumericObject a, NumericObject b) Computers b raised to a
static NumericObject	random() Random number generator
static NumericObject	rint(NumericObject a) Double value closest to a and equal to a integer
static NumericObject	sin(NumericObject a) Sine of specified NumericObject
static NumericObject	sqrt(NumericObject a) Square root of the NumericObject
static NumericObject	standardDeviation(NumericObject[] f) Standard Deviation of the elements of the NumericObject array
static NumericObject	subtract(NumericObject[] f) Subtract the rest elements of NumbericObject array from the first element
static NumericObject	subtract(NumericObject f1, NumericObject f2) Subtract NumericObject f2 from NumericObject f1
static NumericObject	sumSquare(NumericObject[] f) Adds the squares of the elements of the NumericObject array
static NumericObject	tan(NumericObject a) Tan of specified NumericObject
static NumericObject	toDegrees(NumericObject angrad) Converts angle in radians to degrees
static NumericObject	toRadians(NumericObject angdeg) Converts angle in degrees to radians
static StringObject	toString(NumericObject a) Convert NumericObject to string
static StringObject	toString(NumericObject a, NumericObject dp) Convert NumericObject to string with specified round up decimal point
static StringObject	toString(NumericObject a, NumericObject dp, BooleanObject rup) Convert NumericObject to string with specified decimal point
static NumericObject	variance(NumericObject[] f) Variance of the elements of the NumericObject array

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

NumericObject

public NumericObject(short number)

Create a new NumericObject using specified short

NumericObject

public NumericObject(int number)

Create a new NumericObject using specified int

NumericObject

public NumericObject(long number)

Create a new NumericObject using specified long

NumericObject

public NumericObject(float number)

Create a new NumericObject using specified float

NumericObject

public NumericObject(double number)

Create a new NumericObject using specified double

NumericObject

public NumericObject(byte val)

Create a new NumericObject using specified byte

NumericObject

protected NumericObject(java.lang.String formula,
                        int sqlType)

Create a new NumericObject using specified formula and SQL type

Method Detail

getFormula

public java.lang.String getFormula()

Returns the formula

Specified by:

getFormula in interface IObject

getSQLType

public int getSQLType()

Returns the SQL type

Specified by:

getSQLType in interface IObject

getColumnValue

public static NumericObject getColumnValue(int colInfoIndex)

Returns the column value of the specific column

getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           int sqlType)

Returns the column value of the specified column

getColumnValue

public static NumericObject getColumnValue(NumericObject colInfoIndex,
                                           int sqlType)

Returns the column value of the specified column

getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           short aggregation)

Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants

getColumnValue

public static NumericObject getColumnValue(int colInfoIndex,
                                           short aggregation,
                                           int sqlType)

Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants

getColumnValue

public static NumericObject getColumnValue(NumericObject colInfoIndex,
                                           short aggregation,
                                           int sqlType)

Returns the Column value of specified column after doing the specified aggregation. The different values for aggregation are available under quadbase.reportdesigner.util.IAggregateConstants

add

public static NumericObject add(NumericObject f1,
                                NumericObject f2)

Add the two NumericObjects

add

public static NumericObject add(NumericObject[] f)

Add every element of the NumericObject array

subtract

public static NumericObject subtract(NumericObject f1,
                                     NumericObject f2)

Subtract NumericObject f2 from NumericObject f1

subtract

public static NumericObject subtract(NumericObject[] f)

Subtract the rest elements of NumbericObject array from the first element

multiply

public static NumericObject multiply(NumericObject f1,
                                     NumericObject f2)

Multiply the two NumericObjects

multiply

public static NumericObject multiply(NumericObject[] f)

Multiply every element of the NumericObject array

divide

public static NumericObject divide(NumericObject numerator,
                                   NumericObject denominator)

Divide numerator by denominator

mod

public static NumericObject mod(NumericObject numerator,
                                NumericObject denominator)

Returns the remainder after dividing denominator from numerator

IEEERemainder

public static NumericObject IEEERemainder(NumericObject dividend,
                                          NumericObject divisor)

Computes the remainder operator on two arguments based on the IEEE754 standard

acos

public static NumericObject acos(NumericObject a)

Arc cosine of specified NumericObject

cos

public static NumericObject cos(NumericObject a)

Cosine of specified NumericObject

asin

public static NumericObject asin(NumericObject a)

Arc sine of specified NumericObject

sin

public static NumericObject sin(NumericObject a)

Sine of specified NumericObject

atan

public static NumericObject atan(NumericObject a)

Arc tan of specified NumericObject

atan2

public static NumericObject atan2(NumericObject a,
                                  NumericObject b)

Arc tan of specified NumericObjects. Converts rectangular coordinates (a, b) to polar (r, thetha)

tan

public static NumericObject tan(NumericObject a)

Tan of specified NumericObject

ceil

public static NumericObject ceil(NumericObject a)

Ceiling of the NumericObject

exp

public static NumericObject exp(NumericObject a)

Exponential raised to the power of the NumericObject

floor

public static NumericObject floor(NumericObject a)

Floor of the NumericObject

log

public static NumericObject log(NumericObject a)

Natural log of the NumericObject

toDegrees

public static NumericObject toDegrees(NumericObject angrad)

Converts angle in radians to degrees

toRadians

public static NumericObject toRadians(NumericObject angdeg)

Converts angle in degrees to radians

pow

public static NumericObject pow(NumericObject a,
                                NumericObject b)

Computers b raised to a

random

public static NumericObject random()

Random number generator

rint

public static NumericObject rint(NumericObject a)

Double value closest to a and equal to a integer

sqrt

public static NumericObject sqrt(NumericObject a)

Square root of the NumericObject

abs

public static NumericObject abs(NumericObject a)

Absolute of the NumericObject

max

public static NumericObject max(NumericObject a,
                                NumericObject b)

Returns maximum from the two NumericObjects

max

public static NumericObject max(NumericObject[] f)

Returns maximum from the elements of the NumericObject array

min

public static NumericObject min(NumericObject a,
                                NumericObject b)

Returns manimum from the two NumericObjects

min

public static NumericObject min(NumericObject[] f)

Returns manimum from the elements of the NumericObject array

pi

public static NumericObject pi()

Pi value

e

public static NumericObject e()

Base of natural log

count

public static NumericObject count(NumericObject[] f)

Number of elements in the NumericObject array

sumSquare

public static NumericObject sumSquare(NumericObject[] f)

Adds the squares of the elements of the NumericObject array

average

public static NumericObject average(NumericObject[] f)

Average of the elements of the NumericObject array

variance

public static NumericObject variance(NumericObject[] f)

Variance of the elements of the NumericObject array

standardDeviation

public static NumericObject standardDeviation(NumericObject[] f)

Standard Deviation of the elements of the NumericObject array

factorial

public static NumericObject factorial(NumericObject a)

Factorial of the specified NumericObject

toString

public static StringObject toString(NumericObject a)

Convert NumericObject to string

toString

public static StringObject toString(NumericObject a,
                                    NumericObject dp)

Convert NumericObject to string with specified round up decimal point

toString

public static StringObject toString(NumericObject a,
                                    NumericObject dp,
                                    BooleanObject rup)

Convert NumericObject to string with specified decimal point