如果希望创建一个全局变量表示最高级安全级别,使用下面的语句。
If you want to create a global variable that indicates the maximum security level, use this statement.
这与down函数使用了相同的方式,因此可以使用下面的语句选择第三个单元格。
This works in the same way as the down function, so to select the third cell, you would use.
为了使用这个存储过程,必须用下面的sql语句将该过程注册到数据库中。
In order to use the procedure, it must be registered in the database with the following SQL statement.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
请使用下面的SQL 语句来注册这个示例存储过程。
Use the following SQL to register the example stored procedure.
下面的语句创建了将在报告部分使用的TAX1120VIEW。
The statement below creates the TAX1120VIEW that you will use in the reporting section.
为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATETABLE和INSERT语句定义示例表和数据。
To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.
现在,我们已经获得了中介的框架类,接下来可以开始对其填充代码了,请首先添加我们将稍后使用的包和一些导入语句(请参见下面的清单1)。
Now that we have a skeleton class for our mediation we can begin to populate it with code, starting with a package and some import statements that we will make use of later (see Listing 1 below).
下面的语句创建本文使用的FPMLADMIN. CREDITV视图。
The statement below creates the FPMLADMIN.CREDITV view that is used in this article.
同样,下面的计划展示了由于对SQL 语句的有效使用,这个事务变得多么地紧凑
Again the plan below shows how dense this transaction has become thanks to the efficient usage of SQL
现在可以使用下面的命令将这个传统复制转换成主复制(也可以在select语句中指定要被复制的列的列表)。
Now you can change this classic replicate to a master replicate using the following command (you could have specified the list of columns in the SELECT statement to be replicated).
现在可以使用下面的命令将这个传统复制转换成主复制(也可以在select语句中指定要被复制的列的列表)。
Now you can change this classic replicate to a master replicate using the following command (you could have specified the list of columns in the SELECT statement to be replicated).
应用推荐