If you only select DDL, an additional genddl script will be generated.
如果只选择ddl,那么会生成额外的genddl脚本。
For DDL, you will use generated db2ddl script to create table definitions.
对于ddl,使用生成的db2ddl脚本创建表定义。
Generate DDL from the compare output.
从对比输出生成ddl。
Listing 4. DDL for the dw_books table.
清单4 . dw_books表的ddl。
Execute the DDL against the target server.
在目标服务器上执行该DDL。
Run unload script to generate DDL and DATA.
运行unload脚本生成DDL和数据。
DDL for tables used by the stored procedures.
存储过程使用的表的ddl。
Gather statistics and DDL for a database subset.
收集数据库子集的统计数据和ddl。
E: Extract DDL file needed to duplicate database.
e:提取复制数据库所需的DDL文件。
Create an external table using the following DDL.
使用以下ddl创建一个外部表。
The complete DDL commands are listed as noted below.
下面列出了完整的DDL命令。
This option generates a script containing DDL statements.
该选项生成包含了ddl语句的脚本。
The SQL DDL which is used to create the database is as follows.
用来创建数据库的SQLDDL如下所示。
the MQTs DDL statements are saved in the file 'my_rec_mqts.sql'.
MQTDDL语句保存在文件 'my_rec_mqts.sql' 中。
It generates the DDL needed to apply the changes on the database.
该选项生成在数据库中应用更改所需的DDL。
Oracle uses the alter user DDL statement to register proxy users.
Oracle使用alteruserDDL语句注册代理用户。
From a command line, execute the db2look command to generate the DDL.
从命令行执行db2look命令,以生成ddl。
That is, remove DDL for functions, triggers, stored procedures, etc).
也就是说,应去掉用于函数、触发器、存储过程等等的 DDL。
Generate DDL statements for tables, view, indexes, triggers, and more.
创建表、视图、索引、触发器等的ddl语句。
The DDL also contains the GRANT statements for our two database users.
DDL同样也包含了我们的两个数据库用户使用的grant语句。
You may choose to do a reverse engineering based on a DDL file as well.
还可以选择根据一个DDL文件进行反向工程。
Run the DDL script included in the download file by issuing this command
通过发出如下命令来运行下载文件中包括的DDL脚本
Specify the working directory where DDL and data are to be extracted to.
指定DDL和数据要提取到的工作目录。
The procedure will only populate the DDLLOG table with the DDL statements.
这个过程只用ddl语句填充ddllog表。
This is followed by the DDL statements for distinct types and then tables.
后面是不同类型的ddl语句,然后是表的ddl语句。
Note: the data preservation commands are interleaved with the DDL commands.
注意:数据保留命令中穿插有ddl命令。
Based on the target database capabilities, the DDL can also be rolled back.
DDL还可以回滚,但这取决于目标数据库的功能。
Connect to the DB2 database and issue the DDL using the following commands.
使用下列命令连接到DB 2数据库进而发出该DDL。
'DDL' : Create empty copies of all supported objects from the source schema.
'DDL ':创建源模式中支持的所有对象的空副本。
The script files may contain any supported DDL, DML, and DCL SQL statements.
脚本文件可以包含任何所支持的DDL、DML和DCLSQL语句。
应用推荐