The DB2 tutorial you are looking at is: IBM DB2 Daily Maintenance Summary (ix). 167.REPEAT (EXP1,EXP2)
Returns the string that EXP1 repeats EXP2 times.
Selectchar (REPEAT (' REPEAT ', 3), Frombsempms;
168.REAL ()
Returns a single-precision floating-point number representation of a numeric value.
Selectreal (FROMBSEMPMS);
169.RAND ()
Returns the number of random floating-point numbers between 0 and 1.
Selectrand () Frombsempms;
170.POWER (EXP1,EXP2)
Returns the EXP2 power of the EXP1.
Selectpower (2,5) Frombsempms;
171.POSSTR (EXP1,EXP2)
Returns the position of the EXP2 in EXP1.
SELECT (' abcdefgh ', ' D ') Frombsempms;
172.NULLIF (EXP1,EXP2)
Null if EXP1=EXP2, otherwise EXP1
173.NODENUMBER ()
Returns the partition number of the row.
Selectnodenumber (emp_no) Frombsempms;
174.MONTH ()
Returns the month portion of a numeric value.
Selectmonth (' 2003/10/20 ') Frombsempms;
175.MOD (EXP1,EXP2)
Returns the remainder of the EXP1 divided by EXP2.
Selectmod (20,8) Frombsempms;
176.MINUTE ()
Returns the minute portion of a numeric value.
Selectminute (' 18:34:23 ') Frombsempms;
177.LTRIM ()
Deletes the space before the string.
Selectltrim (' cddd ') Frombsempms;
178.HOUR ()
Returns the hour portion of a value.
Selecthour (' 18:34:23 ') Frombsempms;
179.DOUBLE ()
If the argument is a numeric expression, returns the floating-point number corresponding to it, and returns the string expression of the string if the argument is a literal.
Selectdouble (' 5678 ') Frombsempms;
180.EXP ()
Returns the exponential function of a parameter.
Selectexp (2) Frombsempms;
181.FLOAT ()
Returns a floating-point representation of a number.
Selectfloat (789) Frombsempms;
182.FLOOR ()
Returns the largest integer less than or equal to a parameter.
Slectfloor (88.93) Frombsempms;
183.HEX ()
Returns a 16-binary representation of a value represented as a string.
Selecthex (FROMBSEMPMS);
<
