The CREATE statement has one slightly nonstandard bit of SQL syntax.
CREATE语句稍微有一些不符合标准的SQL语法。
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语句上指定的参数。
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语句的代码示例。
If you do decide to drop an index, you should first save its create index statement so that you can easily recreate it if necessary.
如果您决定删除索引,那么首先要保存它的CREATEindex语句,以便在需要时轻松地重新创建它。
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语句中决定,而不是数据源上。
When you create a database using the create database statement, the code page for the database will be derived from the operating system locale setting.
在使用CREATEdatabase语句创建数据库时,将从操作系统的地区设置推导出数据库的编码页。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中,我们选择修改CREATEprocedure语句而不是修改源代码。
Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATEindex语句为我的本地索引指定表空间?
The user can use the CREATE TYPE MAPPING statement to override the default type mapping for procedure parameters.
用户可以使用CREATETYPEMAPPING语句覆盖过程参数的默认类型映射。
In a DPF environment, each table row is distributed to a database partition according to the distribution key specified in the CREATE table statement.
在DPF环境中,根据CREATE table语句中指定的分区键,表中的每个行被分布到一个分区上。
Solution: Check the CREATE PROCEDURE statement and make sure you are passing the correct number of input and output parameters with proper data types.
解决方案:检查CREATEPROCEDURE语句,确保传递的输入和输出参数的数量和数据类型都正确。
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语句。
If a primary key is specified in the CREATE TABLE statement, the first column of the primary key is used as the distribution key.
如果在CREATEtable语句中指定了一个主键,那么主键的首列会被用作分配键。
Once you have determined the MQT definitions, the MQTs can be created with the use of a " CREATE TABLE" statement.
一旦确定了MQT定义,就可以使用 "CREATETABLE"语句创建MQT 了。
The CREATE transform statement enables an existing function to be used as a transform function.
CREATETRANSFORM允许将现有的函数用作转换函数。
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语句决定。
The dimensions are defined in the CREATE table statement and storage is reserved for each combination of values.
在CREATEtable语句中定义维的时候,就为每种值的组合预留了存储空间。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
要避免这种情况,使用CREATEPROCEDURE语句的returns子句来将数据返回给调用者。
应用推荐