The examples so far demonstrate arrays in SQL pl.
到目前为止的示例演示了SQL PL中的阵列。
Now let's use inline SQL PL to achieve the same effect.
现在，让我们使用内联sQL PL来取得相同的效果。
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运算符使此类操作成为可能。
SQL PL stored procedures are easy to create and have good performance.
SQL PL存储过程很容易创建，它们的性能很好。
To address the first issue, DB2 supports the concept of inline SQL PL.
为了解决第一个问题，DB 2支持内联sQL PL的概念。
Instead, take a look at a simple example that illustrates arrays in SQL pl.
相反，看一个对SQL PL中的阵列进行说明的简单示例。
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的一个小子集。
In the context of inline SQL PL UNIONs are used to drive statements in a sequential fashion.
在内联sQL PL的上下文中，UNION用于以一种连续的方式派生出语句。
These procedures can be external stored procedures using embedded SQL or written entirely in SQL PL.
这些过程可以是使用嵌入式SQL编写的外部存储过程，也可以完全以SQL PL编写。
SQL pl has became very popular for the development of stored procedures for DB2 on different platforms.
用SQL PL在不同平台上开发DB 2存储过程已经变得非常流行。
SQL PL developers should use the corresponding function provided by the DB2 native compound SQL statements.
SQL PL开发人员应该使用DB 2原生复合sql语句提供的对应函数。
Without their work in Starburst, inline SQL PL and data-change-operations in the FROM clause could not exist.
如果没有他们在Starburst的工作，就不存在from子句中的内联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中适当的异常处理要求每个过程有一个错误处理程序，这个错误处理程序应该可以很容易地告诉我们出错的过程。
For those truly interested in the internal workings of inline SQL PL, more details can be found in the patents referenced in the resources section of this article.
对于那些对内联s QLPL的内部原理真正感兴趣的读者，可以在本文参考资料一节中给出的参考资料中发现更详细的信息。
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浏览器来访问，也可以将之作为单独的应用程序安装。
SQL PL procedures contain SQL statements that have execution attributes, such as the isolation level or the optimization level that can only be overridden by DB2_SQLROUTINE_PREOPTS registry variable.
SQL PL过程包含的sql语句具有一些执行属性，例如隔离级别或优化级别，这些属性只能通过DB2_SQLROUTINE _ PREOPTS注册表变量来覆盖。
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 following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
These both embody a set of PL/SQL statements and attach a name to that set, allowing the logic to be easily referenced by other PL/SQL and SQL code.
它们都是包含一组PL/SQL语句，并为这组语句关联一个名称，以便其他 PL/SQL和 SQL代码引用其中的逻辑。
Do you wish you could reuse your PL/SQL knowledge and code on another database platform?
希望在另一种数据库平台上重用PL/SQL知识和代码吗？
应用推荐