Chapter 3. Overview of SQL PL Language Elements

In this chapter, you will learn

  • DB2 data types and the range of their values

  • How to work with large objects

  • How to choose proper data types

  • How to work with user-defined data types (UDTs)

  • How to manipulate date, time, and string data

  • How to use generated columns

  • How to work with SEQUENCE objects and IDENTITY columns

Now that you have learned the basic DB2 SQL procedure structure, it is time for an overview of the DB2 SQL PL language elements and their usage before discussing any of the more advanced features of the language. Many decisions on the topics covered in this chapter—such as the choices of the proper data types and the usages of SEQUENCE objects, IDENTITY columns, and generated columns—are generally ...

Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.