IBM DB2 Daily Maintenance Summary (8)

The db2 tutorial we are watching is: IBM DB2 daily maintenance summary (8). ()
Returns a connection of two strings.
SELECTCONCAT(EMP_NO,EMP_NAM)FROMBSEMPMS;

()
Returns the year part of the value.
SELECTYEAR('2003/01/02')FROMBSEMPMS;

()
Returns a variable-length string representation of a string, date type, and graphic string.
SELECTVARCHAR(EMP_NAM,50)FROMBSEMPMS;

()ORUPPER()
Returns the uppercase of the string.
SELECTUCASE(EMP_NAM)FROMBSEMPMS;
SELECTUPPER(EMP_NO)FROMBSEMPMS;

()ORTRUNC()
Start truncating from the right of the decimal point of the expression and return the value.
SELECTTRUNCATE(345.6789,2)FROMBSEMPMS;

()
Returns the time in a numeric value.
SELECTTIME('2001-03-19.12.30.123456')FROMBSEMPMS;

(EXP1,EXP2)
Returns the substring from EXP1 string starting from EXP2.
SELECTSUBSTR('CDNJFDJFJD',5)FROMBSEMPMS;
SELECTSUBSTR('CDNJFDJFJD',5,2)FROMBSEMPMS;

()
Returns the square root of this parameter.
SELECTSQRT(36)FROMBSEMPMS;

()
Returns a string with a length specified by the parameter, including spaces.
SELECTSPACE(10)FROMBSEMPMS;

()
Returns the second part of a value.
SELECTSECOND('18:34:32')FROMBSEMPMS;

()
Delete the space at the end of the string.
SELECTRTRIM('COMMENT')FROMBSEMPMS;

(EXP1,EXP2)
Returns the rounding value starting at the EXP2 position to the right of the decimal point of EXP1.
SELECTROUND(2345.6789,2)FROMBSEMPMS;

(EXP1,EXP2,EXP3)
Replace all EXP2 in EXP1 with EXP3
SELECTCHAR(REPLACE('ROMANDD','NDD','CCB'),10)FROMBSEMPMS;