use set_routine_opts procedure call before the creation of sql pl procedures creation to associate the profile name with the specific sql pl for db2 v8 fp13+, or db2 v9 fp1+.
在创建sql pl过程之前，使用 set_routine_opts过程调用将概要文件的名称与db2v8fp13+或db2v9fp1+ 中特定的sql pl 相关联。
the unnest operator in sql pl makes such an operation possible.
sql pl中的unnest 运算符使此类操作成为可能。
sql pl is supported throughout the entire db2 family of database servers from linux, unix, windows, iseries, and z/os.
iseries和z/os 上的所有db2数据库服务器都支持sql pl。
in the context of inline sql pl unions are used to drive statements in a sequential fashion.
在内联sql pl的上下文中，union用于以一种连续的方式派生出语句。
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中适当的异常处理要求每个过程有一个错误处理程序，这个错误处理程序应该可以很容易地告诉我们出错的过程。
arrays in sql pl are allocated and reallocated dynamically.
动态分配并重新分配sql pl中的阵列。
now let's use inline sql pl to achieve the same effect
现在，让我们使用内联sql pl来取得相同的效果
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注册表变量来覆盖。
there are two types of conditional statements supported in sql pl procedures: case and if.
sql pl过程支持两种类型的条件语句：case和if。
sql pl has became very popular for the development of stored procedures for db2 on different platforms.
用 sql pl在不同平台上开发db2存储过程已经变得非常流行。
for more detailed analysis of what goes on within sql procedures, i recommend taking a look at the sql pl profiler, which can be downloaded from developerworks/db2 as well.
关于sql过程内部情况的更详细的分析，我建议您看一下sql plprofiler，这也可以从developerworks/db2下载。
without their work in starburst, inline sql pl and data-change-operations in the from clause could not exist.
如果没有他们在starburst 的工作，就不存在from 子句中的内联sql pl和数据更改操作。
for sql pl stored procedures and udfs, you can specify default parameter values and assign them by name.
对于sql pl存储过程和udf，可以指定默认参数值并按名称分配参数值。
sql pl developers should use the corresponding function provided by the db2 native compound sql statements.
sql pl开发人员应该使用db2原生复合sql语句提供的对应函数。
supports before row triggers, after row and statement triggers, instead of triggers and triggers with sql pl compound statements.
支持行前触发器、行后和语句触发器、insteadof触发器和包含sql pl复合语句的触发器。
sql pl has evolved as the only ansi sql standards-based stored procedure language.
sql pl已经发展成惟一的基于ansisql标準的存储过程语言。
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 plprofiler）工具作为applet安装，并通过web浏览器来访问，也可以将之作为单独的应用程序安装。
db2 9.5 introduces support for array data types in sql pl to help with application development issues like those described above.
db29.5引入了对sql pl中的阵列数据类型的支持，以便帮助解决类似上面所述的那些应用程序开发问题。
sql pl stored procedures are easy to create and have good performance.
sql pl存储过程很容易创建，它们的性能很好。