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, stored procedures, functions, and triggers coded in SQL PL are all compiled into embedded C programs and bound into DB2 as packages.



    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net