Listing 5. Output from part1.pl.

清单5 . part1 . pl的输出。

The examples so far demonstrate arrays in SQL pl.

到目前为止的示例演示了SQL PL中的阵列。

The following looping statements are supported in SQL pl.

SQL PL中支持以下循环语句。

To address the first issue, DB2 supports the concept of inline SQL PL.

为了解决第一个问题，DB 2支持内联s QL PL的概念。

Instead, take a look at a simple example that illustrates arrays in SQL pl.

相反，看一个对SQL PL中的阵列进行说明的简单示例。

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编写。

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阵列可用作辅助数据结构。

pl -mt "TALB=Best" *.mp3

autotag.pl -mt "TALB=Best" *.mp3

Script 7.pl matches Unicode characters in regular expressions (7_out.txt shows a sample run of 7.pl).

脚本 Script 7.pl 就可以匹配正则表达式中的 Unicode 字符（7_out.txt 给出了运行 7.pl 的样例输出）。

Thus, script 4.pl gave me the error "Can't find string terminator \343 anywhere before EOF at ./4.pl line 7." (in which \343 was an unrelated character).

因此，script 4.pl 会报告一个错误“Can't find string terminator \343 anywhere before EOF at ./4.pl line 7.” （其中 \343 是一个无关字符）。

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中适当的异常处理要求每个过程有一个错误处理程序，这个错误处理程序应该可以很容易地告诉我们出错的过程。

All instruments required that B-criteria co-occur with the mood episode, except KSADS-PL, which considered five out of the seven symptoms.

所有诊断工具都需要B-标准和心境发作一同出现，但除了KSADS-PL只是要求七项症状中的五项。

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 存储过程中使用这些更改，那么应该如何使用这个日志程序呢？

SQL pl has became very popular for the development of stored procedures for DB2 on different platforms.

用SQL PL在不同平台上开发DB 2存储过程已经变得非常流行。

In the context of inline SQL PL UNIONs are used to drive statements in a sequential fashion.

在内联s QL PL的上下文中，UNION用于以一种连续的方式派生出语句。

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中的阵列数据类型的支持，以便帮助解决类似上面所述的那些应用程序开发问题。

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 代码引用其中的逻辑。

SQL PL developers should use the corresponding function provided by the DB2 native compound SQL statements.

SQL PL开发人员应该使用DB 2原生复合sql语句提供的对应函数。

The GPFS portability layer (PL) is kernel-specific, and it must be created separately for each operating system level within your cluster.

GPFS 可移植层（PL）是内核特有的，必须为集群中的每个操作系统级别单独创建。

SQL PL stored procedures are easy to create and have good performance.

SQL PL存储过程很容易创建，它们的性能很好。

Triggers and user-defined functions (UDFs) now have enhanced SQL PL support.

触发器和用户定义函数（UDF）增加了 SQL PL 支持。

It is licensed under the standard terms of the Microsoft Public license (Ms-PL).

它基于微软公共许可协议的标准条款发布。

Do you wish you could reuse your PL/SQL knowledge and code on another database platform?

希望在另一种数据库平台上重用 PL/SQL 知识和代码吗？

The SQL procedural language (SQL PL) is a popular tool in many DB2 developers' toolboxes.

SQL过程语言(SQL PL)是许多DB 2开发人员工具箱中的一个流行工具。

KSADS-PL used clinical judgment without a manual scoring sheet.

KSADS - PL只使用临床判断，而不用记分表手册。

Arrays in SQL PL are allocated and reallocated dynamically.

动态分配并重新分配SQL PL中的阵列。

This can be done for batch, CICS, COBOL or PL/1, DB2 stored procedures, debug-called subroutines, and so on.

这可以针对批处理、CICS、COBOL（或 PL/1）、DB2 存储过程、调试调用的子例程等进行执行。

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或任何其他外部存储过程中使用。