Extended Systems OneBridge 4.1 Guía de usuario descargar pdf (Pagina 144)

ulsDescending

130 Sybase IQ ETL 4.1

string format(optional)

The format of the input date.

Note Omitting the format parameter can slow down the function execution

time.

Examples To check for a valid date value:

uIsDate(“2004-02-29”) // returns 1

uIsDate(“2003-02-29”) // returns 0, because 2003 was not

a leap year

ulsDescending

Description Returns 1 if every parameter is equal to or lower than its predecessor.

Syntax number uIsDescending(params, ...)

Parameters

params

A list of expressions or values of any datatype.

Examples To check multiple values for a decending order:

uIsDescending("C", "B", "A") // returns 1

uIsDescending("C", "C", "A") // returns 1

uIsDescending("A", "C", "B") // returns 0

uIsDescending("3", "2", "1") // returns 1

uIsDescending("3", "2", "3") // returns 0

uIsDescending("2004-03-20", "2004-03-15", "2004-03-

07") // returns 1

uIsDescending("2004-03-20", "2004-03-07", "2004-03-

15") // returns 0

ulsInteger

Description Returns 1 if the parameter can be interpreted as an integer value.

Syntax number uIsInteger(param)

1 2 ... 139 140 141 142 143 144 145 146 147 148 149 ... 221 222

Sin comentarios

Extended Systems OneBridge 4.1 Guía de usuario Pagina 144