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的内部原理真正感兴趣的读者,可以在本文参考资料一节中给出的参考资料中发现更详细的信息。
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中适当的异常处理要求每个过程有一个错误处理程序,这个错误处理程序应该可以很容易地告诉我们出错的过程。
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 存储过程中使用这些更改,那么应该如何使用这个日志程序呢?
Instead, take a look at a simple example that illustrates arrays in SQL pl.
相反,看一个对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注册表变量来覆盖。
SQL pl has became very popular for the development of stored procedures for DB2 on different platforms.
用SQL PL在不同平台上开发DB 2存储过程已经变得非常流行。
The following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
In the context of inline SQL PL UNIONs are used to drive statements in a sequential fashion.
在内联sQL PL的上下文中,UNION用于以一种连续的方式派生出语句。
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阵列可用作辅助数据结构。
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中的阵列数据类型的支持,以便帮助解决类似上面所述的那些应用程序开发问题。
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语句提供的对应函数。
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支持。
These procedures can be external stored procedures using embedded SQL or written entirely in SQL PL.
这些过程可以是使用嵌入式SQL编写的外部存储过程,也可以完全以SQL 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开发人员工具箱中的一个流行工具。
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或任何其他外部存储过程中使用。
Arrays in SQL PL are allocated and reallocated dynamically.
动态分配并重新分配SQL PL中的阵列。
To address the first issue, DB2 supports the concept of inline SQL PL.
为了解决第一个问题,DB 2支持内联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的一个小子集。
The examples so far demonstrate arrays in SQL pl.
到目前为止的示例演示了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浏览器来访问,也可以将之作为单独的应用程序安装。
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过程跟踪来发现性能和逻辑问题。
Supports before row triggers, after row and statement triggers, instead of triggers and triggers with SQL PL compound statements.
支持行前触发器、行后和语句触发器、insteadof触发器和包含SQL PL复合语句的触发器。
The following looping statements are supported 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和数据更改操作。
There are many syntax differences pertaining to PL/SQL objects like Procedures, functions, and triggers in Oracle and DB2.
在Oracle和DB2 之间存在与PL/SQL 对象(比如过程、函数和触发器)有关的许多语法差异。
Using the logging framework through SQL-PL stored procedures
通过 SQL-PL存储过程来使用这个日志框架
应用推荐