SQL PL
SQL Procedural Language (SQL PL) is an inline programming language that can be used inside SQL statements. It allows common programming language features such as variable assignments, looping, and conditional statements. SQL PL is useful for adding programming logic to UDFs, stored procedures, and compound SQL statements. The code is easy to use and highly portable. Stored procedures that are written in SQL PL are called SQL Stored Procedures. Users of SQL PL do not need a strong programming knowledge to take advantage of this functionality.
One of the easiest ways to learn how to use SQL PL is by using the DB2 Development Center. The Development Center wizard will prompt the user and will then generate a skeleton stored procedure or UDF ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.
