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.
注意,SQLPL中适当的异常处理要求每个过程有一个错误处理程序,这个错误处理程序应该可以很容易地告诉我们出错的过程。
Like arrays in other programming languages, DB2 arrays can be used as an auxiliary data structure when coding algorithms in SQL PL.
像其他编程语言中的阵列一样,在SQLPL中对算法编码,DB 2阵列可用作辅助数据结构。
The purpose of the pl and the details of creation for the example cluster are described in the Producing and installing the portability layer section.
PL的作用和为示例集群创建它的过程将在生成并安装可移植层一节中详述。
There are many syntax differences pertaining to PL/SQL objects like Procedures, functions, and triggers in Oracle and DB2.
在Oracle和DB2 之间存在与PL/SQL 对象(比如过程、函数和触发器)有关的许多语法差异。
There are four logging stored procedures that you can use in your SQL-PL stored procedures to log messages.
在SQL - PL存储过程中可以使用4个日志存储过程来记录消息。
The examples so far demonstrate arrays in SQL pl.
到目前为止的示例演示了SQL PL中的阵列。
Without their work in Starburst, inline SQL PL and data-change-operations in the FROM clause could not exist.
如果没有他们在Starburst的工作,就不存在from子句中的内联sQL PL和数据更改操作。
The script 2.pl has the UTF-8 encoded data directly embedded in the script.
script 2 .pl在脚本中就直接嵌入了UTF - 8编码的数据。
The following looping statements are supported in SQL pl.
SQLPL中支持以下循环语句。
Script 7.pl matches Unicode characters in regular expressions (7_out.txt shows a sample run of 7.pl).
脚本 Script7.pl 就可以匹配正则表达式中的Unicode字符(7_out.txt 给出了运行 7.pl 的样例输出)。
Listing 3 (full source is in words2.pl) USES the original idea but employs approximate matching through the String: : approx module (which you may have to install).
清单3(在words2 . pl中有完整的代码)采用了前一篇文章中的原始思想,但通过String:Approx模块(您可能必须要安装它)进行近似匹配。
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'tfindstringterminator \343anywherebeforeEOFat ./4.plline7.” (其中 \343是一个无关字符)。
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的内部原理真正感兴趣的读者,可以在本文参考资料一节中给出的参考资料中发现更详细的信息。
In the context of inline SQL PL UNIONs are used to drive statements in a sequential fashion.
在内联sQL 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引入了对SQLPL中的阵列数据类型的支持,以便帮助解决类似上面所述的那些应用程序开发问题。
These procedures can be external stored procedures using embedded SQL or written entirely in SQL PL.
这些过程可以是使用嵌入式SQL编写的外部存储过程,也可以完全以SQLPL编写。
Instead, take a look at a simple example that illustrates arrays in SQL pl.
相反,看一个对SQL PL中的阵列进行说明的简单示例。
The SQL procedural language (SQL PL) is a popular tool in many DB2 developers' toolboxes.
SQL过程语言(SQLPL)是许多DB 2开发人员工具箱中的一个流行工具。
Arrays in SQL PL are allocated and reallocated dynamically.
动态分配并重新分配SQLPL中的阵列。
Script 8.pl will properly match all the words in the input text.
脚本8 .pl可以正确匹配输入文本中的所有单词。
The study reveals that PL a major role in the beginning stages of SLA .
此项研究证明,预制语块在第二语言习得中的开始阶段具有重要的作用。
In previous articles, I have described how to find performance using the SQL PL Profiler and logic problems using SQL Procedure Tracing.
在前面的文章中,我曾描述了分别利用SQLPLProfiler和SQL过程跟踪来发现性能和逻辑问题。
Many Oracle users employ PL/SQL to add custom logic to their data processing in a variety of ways.
很多Oracle用户以各种方式采用PL/SQL为数据处理添加定制的逻辑。
Executing part1.pl yields the output shown in Listing 5.
执行part1. pl会产生清单5所示的输出。
XML::Simple generally has sensible defaults, so that for example if you specify no input file name, a Perl program named part1.pl (as in Listing 4) will read a file called part1.xml.
Simple有一些合理的默认设置,例如如果没有指定输入文件名,那么Perl程序part1.pl(清单4)将读取文件part1.xml。
Run 5.pl with any number of codes (in decimal, for example 500 or 1000) from the command line. The results of a sample run are included in 5_out.txt.
在命令行中使用任何编码(例如十进制的500或1000)来运行5 .pl,结果如5_out . txt所示。
Pl program is detailed in "Create geographical plots of your data using Perl, GD, and plot-latlong."
“使用Perl、GD和plot - latlong创建数据的地理标绘”这篇文章详细描述了worldCompositeMap . pl程序。
Pl program is detailed in "Create geographical plots of your data using Perl, GD, and plot-latlong."
“使用Perl、GD和plot - latlong创建数据的地理标绘”这篇文章详细描述了worldCompositeMap . pl程序。
应用推荐