Its function is to get and execute the next command statement.
其功能是获得和执行下一个命令语句。
You can turn proctrace on for a specified procedure by using the ADMIN COMMAND statement: ADMIN COMMAND 'proctrace {on | off} user username procedure procedure_name'.
要针对指定的过程启用proctrace,可以使用ADMINcommand语句:admin COMMAND' proctrace {on |off}userusername procedure procedure_name '。
The first example is the notation I am using in this demonstration, the second example is the abbreviated notation, and the third example gives the full command statement without any abbreviations.
第一个示例是本文中使用的表示法,第二个示例是缩写表示法,第三个示例是不使用任何缩写的完整命令语句。
You can execute the statement to create this view in a DB2 command line or other query tool.
您可以使用DB 2命令行或其他查询工具执行这些语句来创建视图。
Let's add a WHERE clause to that SELECT statement by invoking the EDIT command and specifying statement number 2 in the sequence.
我们将调用EDIT命令,并在顺序中指定语句序号2,通过这些操作给上面的select语句添加where子句。
This dynamically prepared statement can be executed using the SQL command execute.
可以使用SQL命令EXECUTE来执行这个动态预备语句。
I downloaded the tool and ran the statement in Listing 1 from the command line.
我下载了该工具,并从命令行运行清单1所示的语句。
To verify that the update is successful, launched the DB2 command line window and issue a SELECT statement.
为了验证更新成功,需要启动DB2命令行窗口,并发出SELECT语句。
In these cases, it strongly recommend that the reader USES the native CLRPFM command rather than the SQL DELETE statement.
这种情况下,强烈建议读者使用原生的CLRPFM命令,而不是SQLdelete语句。
Instead the cursor definition is implicitly done by providing the corresponding SELECT statement within the LOAD command.
在LOAD命令中提供相应的select语句,就会隐式地定义游标。
You need to include the go command between SQL statement to receive results from each one.
您需要在sql语句之间包含go命令,以接受每一条语句的结果。
Statement 6 chains two commands with the or operator: the second command (echo) executes only if the first command fails.
语句6用or操作符连接两个命令:第二个命令(echo)只在第一个命令失败的情况下执行。
You can begin typing in (or paste text into) the Command Input window, making sure that each command or SQL statement ends with a statement termination character.
然后可以开始将文本输入(或将文本粘贴到)CommandInput窗口中,确保每个命令或SQL语句以语句分隔符号结束。
In this mode, each command or SQL statement must be prefixed by db2.
在这种模式下,每个命令或sql语句必须添加前缀db2。
Here you use the get scroll insensitive cursor command, once again specifying an SQL statement for the data to include.
在这里您可以使用getscroll insensitive游标命令,并再一次为要包括的数据指定sql语句。
Here you use the get cursor command to create a cursor, feeding it an SQL statement that represents the data you want to include.
在此处您可以使用getcursor命令创建一个游标,并馈送它一个sql语句,表示您要包含的数据。
Auto remastering (CDR remaster command) only works when the replicate SELECT statement column names and table names match across all the replicate participants.
自动remastering (cdrremaster命令)只有在复制select语句中的列名和表名所有复制参与者匹配时才适用。
You can also define the shape of your select command, be it an SQL statement or stored procedure call, by either discovering the result set or manually defining the one or more returned result sets.
您还可以通过发现结果集或手工定义一个或多个返回结果集,来定义select命令的形式是一条sql语句还是存储过程调用。
To stop the HSQLDB server, all that's needed is a SHUTDOWN command as an SQL statement.
要停止HSQLDB服务器,所需要的只是一个作为sql语句的SHUTDOWN命令。
The rewritten query known as "Optimized SQL" is visible when you explain the statement with the db2exfmt command.
重写后的查询也称为“OptimizedSQL”,它将在使用db2exfmt命令解释语句时出现。
There are several ways to do this, but usually it consists of building a custom SQL command to be used as an update statement for the EMPLOYEE table.
有多种方法可完成该工作,但通常都包含构建一个定制的SQL命令,作为update语句用于EMPLOYEE表。
The statement from the COBOL documentation that explains the command displays on the Help feature.
COBOL文档中解释该命令的语句将显示在Help功能上。
From the BSD command line, log into mySQL and execute the statement in Listing 5 to create a database.
在BSD命令行中,登录到mySQL并执行清单5的语句来创建数据库。
ADMIN_CMD Procedure Executes DB2 command line processor (CLP) administrative commands using the SQL CALL statement.
ADMIN_CMD过程使用SQLcall语句执行db2命令行处理器(CLP)管理命令。
The CDR remaster command accepts only one SELECT statement.
cdrremaster命令只接受一个SELECT语句。
Run the following SQL statement in a DB2 command prompt
在DB2命令提示中运行以下SQL语句
Each 'using' statement in the plot command is separated by a comma.
plot命令中的每个‘using’语句由逗号分隔。
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语句将在每个表中创建这些列。
Again, you can verify that by issuing a SELECT statement in the DB2 Command Line window.
同样,可以通过在DB 2命令行窗口中发出select语句来对此进行验证。
Again, you can verify that by issuing a SELECT statement in the DB2 Command Line window.
同样,可以通过在DB 2命令行窗口中发出select语句来对此进行验证。
应用推荐