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

Appendix B. Inline SQL PL for DB2 UDB for Linux, UNIX, and Windows

From the very first chapter of this book, you have been learning the basics as well as the advanced elements of the SQL Procedural Language. Because this book is the Essential Guide to SQL PL, you will learn everything about SQL PL, including inline SQL PL.

Inline SQL PL is a procedural language that supports a subset of the SQL PL elements. The language is employed by dynamic compound SQL statements that are used in triggers, SQL user-defined functions (UDFs), SQL methods, and stand-alone code. Stand-alone code is also sometimes referred to as SQL PL scripting.

The concept of inline SQL PL is only supported in DB2 LUW for Linux, UNIX, and Windows. In DB2 LUW for iSeries and zSeries, ...

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