The CREATE statement has one slightly nonstandard bit of SQL syntax.
CREATE语句稍微有一些不符合标准的SQL语法。
Therefore, you need to create a table before running this code. Here is the create statement
因此,您需要先创建一张表,然后再运行这段代码。
The CREATE statement can also take advantage of the NAMESPACE variable type in its new NAMESPACE clause.
CREATE语句还可以利用其新的NAMESPACE子句中的 NAMESPACE变量类型。
So, although it should be unique, we can add any value we like, as shown in the INSERT statements that follow the CREATE statement.
所以,尽管它应该是惟一的,我们还是可以添加任何值,如CREATE语句后面的几个 INSERT语句中所示。
The maximum size of such LDS VSAM datasets would depend indirectly upon the type of table space you create and the parameters you specify on the create statement.
这种LDSVSAM数据集的最大尺寸将间接取决于您创建的表空间的类型和您在create语句上指定的参数。
Logical page size (for example, in the CREATE INDEX statement above, PAGESIZE was required).
逻辑页面尺寸(例如,在上面的CREATEindex语句中,需要PAGESIZE)。
For example, you can create a statement that only affects the current developer (see Listing 9).
例如,您可以创建仅影响当前开发人员的语句(参见清单9)。
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
对CREATEindex语句的扩展使管理员能够创建全文索引,从而帮助改进这种搜索的性能。
The first tracks the connections used to create a statement.
第一个图跟踪用来创建语句的连接。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
您可以使用PASSTHRU会话直接将CREATEtable语句发送到数据源,并为这个新表创建一个昵称。
Running such a create table statement — by a user at the command line or by a custom application — creates these columns within each table.
用户在命令行上或通过定制应用程序运行这样的CREATEtable语句将在每个表中创建这些列。
Listing 9 contains a code example of the SQL CREATE procedure statement used to register an RPG program as an external stored procedure.
清单9包含一个用于将一个R PG程序注册为一个外部存储过程的SQLCREATEPROCEDURE语句的代码示例。
Typically, you create a SELECT statement, perhaps JOINing many tables together to yield a row.
通常,将创建select子句,可能需要把许多表join在一起才能得到行。
Use the create type statement to create a structured type, and use the DROP statement to delete a structured type.
可以使用CREATEtype语句创建一个结构化类型,并使用drop语句删除结构化类型。
These definitions are determined in the CREATE PROCEDURE statement of the federated procedure, not on the data source.
这些定义在联邦过程的CREATEPROCEDURE语句中决定,而不是数据源上。
Create a mission statement that promotes who you are and who you are becoming.
创建一份可提升你的身份和潜力的目标宣言。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中,我们选择修改CREATEprocedure语句而不是修改源代码。
A partitioning key is defined on a table with the CREATE table statement.
分区键是在一个表上用CREATEtable语句定义的。
Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATEindex语句为我的本地索引指定表空间?
First look at the CREATE procedure statement to confirm what parameters each of the stored procedures expects.
先看一下CREATEPROCEDURE语句,确定每个存储过程所需要的参数。
The creation of the schema is implicit because you don't issue a CREATE schema statement.
模式的创建所以是隐式的,是因为没有发出CREATEschema语句。
The CREATE transform statement enables an existing function to be used as a transform function.
CREATETRANSFORM允许将现有的函数用作转换函数。
The CREATE table statement now provides three ways to group data in a database table.
CREATEtable语句现在提供了三种方式来组织数据库表中的数据。
Once a role is added, the script generated will contain a create role statement.
一旦添加了角色,生成的脚本将包含一个createrole语句。
In this example, you see that the "Create table" statement failed to propagate on target servers.
在本例中,您将看到“Createtable”语句未能广播到目标服务器。
DB2 USES the create trusted context statement to create trusted context objects.
DB 2使用CREATETRUSTEDcontext语句创建可信上下文对象。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATEtable语句决定,而不是由CREATEindex语句决定。
Now the CREATE procedure statement succeeds, and the stored procedure runs successfully.
现在,CREATEprocedure语句成功了,存储过程成功运行。
CREATE procedure statement was not issued to define a procedure at the current server.
没有通过发出CREATEPROCEDURE语句在当前服务器上定义过程。
Create UpdateBook update statement.
创建UpdateBook更新语句。
应用推荐