The db2 tutorial is: Daily maintenance Summary of IBM DB2 (8 ). 154. CONCAT ()
Returns the connection of two strings.
SELECTCONCAT (EMP_NO, EMP_NAM) FROMBSEMPMS;
155. YEAR ()
Returns the year of the value.
SELECTYEAR ('2014/1/02 ') FROMBSEMPMS;
156. VARCHAR ()
Returns the string, date type, and variable-length string representation of the graphic string.
SELECTVARCHAR (EMP_NAM, 50) FROMBSEMPMS;
157. UCASE () ORUPPER ()
Returns the string in uppercase.
SELECTUCASE (EMP_NAM) FROMBSEMPMS;
SELECTUPPER (EMP_NO) FROMBSEMPMS;
158. TRUNCATE () ORTRUNC ()
This value is truncated from the right of the decimal point in the expression and returned.
SELECTTRUNCATE (345.6789, 2) FROMBSEMPMS;
159. TIME ()
Returns the time in a value.
SELECTTIME ('2017-03-19.12.30.123456 ') FROMBSEMPMS;
160. SUBSTR (EXP1, EXP2)
Returns the substring of the EXP1 string starting with EXP2.
SELECTSUBSTR ('cdnjfdjfjd ', 5) FROMBSEMPMS;
SELECTSUBSTR ('cdnjfdjfjd ', 5, 2) FROMBSEMPMS;
161. SQRT ()
Returns the square root of the parameter.
SELECTSQRT (36) FROMBSEMPMS;
162. SPACE ()
Returns a string of the specified length, including spaces.
SELECTSPACE (10) FROMBSEMPMS;
163. SECOND ()
Returns the second of a value.
SELECTSECOND ('18: 34: 32') FROMBSEMPMS;
164. RTRIM ()
Removes spaces at the end of a string.
SELECTRTRIM ('comment') FROMBSEMPMS;
165. ROUND (EXP1, EXP2)
Returns the rounded value starting at the position EXP2 on the right of the EXP1 decimal point.
SELECTROUND (2345.6789, 2) FROMBSEMPMS;
166. REPLACE (EXP1, EXP2, EXP3)
Use EXP3 to replace all EXP2 in EXP1
SELECTCHAR (REPLACE ('romandd', 'ndd', 'ccb'), 10) FROMBSEMPMS;
<