O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required