In this show you'll learn about DB2's built-in data types, divided into numeric, string, and chronological categories. You'll also learn the most commonly used scalar functions. (There are well over a hundred of them, so we only scratch the surface here.) Scalar functions are often used to transform data types, from the input tables (over which you may have no control) to the output result set (over which you always have complete control).