The following looping statements are supported in SQL pl.
SQL PL中支持以下循环语句。
Arrays in SQL PL are allocated and reallocated dynamically.
动态分配并重新分配SQL PL中的阵列。
The UNNEST operator in SQL PL makes such an operation possible.
SQL PL中的 UNNEST运算符使此类操作成为可能。
Triggers and user-defined functions (UDFs) now have enhanced SQL PL support.
触发器和用户定义函数（UDF）增加了SQL PL支持。
The SQL procedural language (SQL PL) is a popular tool in many DB2 developers' toolboxes.
SQL过程语言(SQL PL)是许多DB 2开发人员工具箱中的一个流行工具。
Previous to DB2 9.7, they only supported inline SQL PL, which is a small subset of SQL PL.
在DB2 9.7之前，它们仅支持内联SQL PL，这只是 SQL PL的一个小子集。
These procedures can be external stored procedures using embedded SQL or written entirely in SQL PL.
这些过程可以是使用嵌入式SQL编写的外部存储过程，也可以完全以SQL PL编写。
DB2 9.5 introduces support for array data types in SQL pl to help with application development issues like those described above.
DB 2 9.5引入了对SQL PL中的阵列数据类型的支持，以便帮助解决类似上面所述的那些应用程序开发问题。
Supports before row triggers, after row and statement triggers, instead of triggers and triggers with SQL PL compound statements.
支持行前触发器、行后和语句触发器、insteadof触发器和包含SQL PL复合语句的触发器。
Like arrays in other programming languages, DB2 arrays can be used as an auxiliary data structure when coding algorithms in SQL PL.
像其他编程语言中的阵列一样，在SQL PL中对算法编码，DB 2阵列可用作辅助数据结构。
In previous articles, I have described how to find performance using the SQL PL Profiler and logic problems using SQL Procedure Tracing.
在前面的文章中，我曾描述了分别利用SQL PLProfiler和SQL过程跟踪来发现性能和逻辑问题。
Note that the IBM Data Studio Developer tool offers a debugger and an SQL profiler component that can be used to analyze execution of SQL PL procedures.
注意，IBMDataStudioDeveloper工具提供了一个调试器和一个SQL分析器组件，可以用于分析SQL PL过程的执行。
Note that proper exception handling in SQL PL dictates that each procedure has an error handler that could easily enough have told us the failing procedure.
注意，SQL PL中适当的异常处理要求每个过程有一个错误处理程序，这个错误处理程序应该可以很容易地告诉我们出错的过程。
If your business logic requires simple, concise stored procedures, then consider the SQL procedure Language (SQL pl), as your choice for stored procedure development.
如果业务逻辑只需要简单的存储过程，那么可以考虑用SQLProcedureLanguage (SQL PL)进行存储过程开发。
The SQL Procedure Profiler (or simply SQL pl Profiler) tool can be set up as an applet accessible through a Web browser, or it can be set up as a standalone application.
既可以将SQLProcedureProfiler(或简称为SQL pl Profiler)工具作为applet安装，并通过Web浏览器来访问，也可以将之作为单独的应用程序安装。
Using the logging framework through SQL-PL stored procedures
通过 SQL-PL存储过程来使用这个日志框架
The following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
Question: How do I use this logger when I am also making modifications to the framework and using it from my SQL-PL stored procedures?
问题：如果我对这个框架进行了一些更改，并且将在自己的 SQL-PL 存储过程中使用这些更改，那么应该如何使用这个日志程序呢？
The second part is the logging stored procedures that are used from within the body of SQL-PL or any other external stored procedures.
第二个部分是日志存储过程，可以在SQL -PL或任何其他外部存储过程中使用。
There are four logging stored procedures that you can use in your SQL-PL stored procedures to log messages.
在SQL - PL存储过程中可以使用4个日志存储过程来记录消息。
There are four logging stored procedures that you can use in your SQL-PL stored procedures to log messages.
在SQL - PL存储过程中可以使用4个日志存储过程来记录消息。
应用推荐