IBM DB2 routine maintenance Summary (9)

The db2 tutorial is: Daily maintenance Summary of IBM DB2 (9 ). 167. REPEAT (EXP1, EXP2)
Returns the string that EXP1 repeats EXP2.
SELECTCHAR (REPEAT ('repeat', 3), 21) FROMBSEMPMS;
　　
168. REAL ()
Returns the single-precision floating-point representation of a value.
SELECTREAL (10) FROMBSEMPMS;
　　
169. RAND ()
Returns a random floating point number between 0 and 1.
SELECTRAND () FROMBSEMPMS;
　　
170. POWER (EXP1, EXP2)
Returns the EXP2 power of EXP1.
SELECTPOWER (2, 5) FROMBSEMPMS;
　　
171. POSSTR (EXP1, EXP2)
Returns the position of EXP2 in EXP1.
SELECT ('abcdefgh', 'D') FROMBSEMPMS;
　　
172. NULLIF (EXP1, EXP2)
If EXP1 = EXP2, It is NULL; otherwise, it is EXP1.

173. NODENUMBER ()
Returns the Partition Number of the row.
SELECTNODENUMBER (EMP_NO) FROMBSEMPMS;
　　
174. MONTH ()
Returns the month of a value.
SELECTMONTH ('2014/1/20') FROMBSEMPMS;
　　
175. MOD (EXP1, EXP2)
Returns the remainder of EXP1 divided by EXP2.
SELECTMOD (20, 8) FROMBSEMPMS;
　　
176. MINUTE ()
Returns the minute of a value.
SELECTMINUTE ('18: 34: 23') FROMBSEMPMS;
　　
177. LTRIM ()
Removes spaces before a string.
SELECTLTRIM ('cddd') FROMBSEMPMS;
　　
178. HOUR ()
Returns the hour of a value.
SELECTHOUR ('18: 34: 23') FROMBSEMPMS;
　　
179. DOUBLE ()
If the parameter is a numeric expression, return the corresponding floating point number. If the parameter is a string expression, return the string expression of the number.
SELECTDOUBLE ('200') FROMBSEMPMS;
　　
180. EXP ()
Returns the exponential function of the parameter.
SELECTEXP (2) FROMBSEMPMS;
　　
181. FLOAT ()
Returns the floating point representation of a number.
SELECTFLOAT (789) FROMBSEMPMS;
　　
182. FLOOR ()
Returns the maximum integer that is less than or equal to the parameter.
SLECTFLOOR (88.93) FROMBSEMPMS;
　　
183. HEX ()
Returns a hexadecimal representation of the string value.
SELECTHEX (16) FROMBSEMPMS;