For these examples, we will use the CLP as the application.
对于这些例子,我们将使用CLP作为应用程序。
CLP options can generally be specified in any sequence and combination.
CLP选项通常可以以任何顺序和组合来指定。
The CLP includes both a front-end process (representing the user interface) and a back-end process to maintain a database connection.
CLP包括前端进程(表示用户界面)和后端进程,可以用它们来维护数据库连接。
You can now customize the prompt that appears when you use the CLP in interactive mode.
现在可以对在交互模式下使用CLP时出现的提示符进行定制。
You can even use temporary tables from the DB2 Command Line Processor (CLP), as you will soon see.
下面很快就能看到,您甚至可以通过DB 2命令行处理器(CLP)使用临时表。
To do an online table space and database level backup via CLP command prompt, follow the steps below.
要通过CLP命令行提示执行联机表空间级和数据库级备份,请执行下面这些步骤。
You can use the backslash character (\) as the line continuation character in CLP command mode or interactive input mode.
在CLP命令模式或交互输入模式下,可以将反斜线字符(\)用作行连续字符。
More importantly you can see the section number, and where the query was issued from (QUERYTAG: CLP).
更重要的是,您可以看到区域编号以及从何处发出的查询(QUERYTAG:CLP)。
The customized CLP prompt can show the current user, instance attachment, or database connection.
定制的CLP提示符可以显示当前用户、实例连接或数据库连接。
For example, there is no DB2 command line processor (DB2 CLP) or tools.
例如,它不提供DB 2命令行处理程序(DB 2CLP)或工具。
By default, the command cache holds up to twenty commands that were run during the current interactive CLP session.
默认情况下,命令缓存最多存放当前交互clp会话过程中运行的二十个命令。
We will execute two CLP scripts, one from each of two DB2 command windows (sessions).
我们将分别从两个DB2命令窗口(会话)执行两个CLP脚本。
If you start two separate interactive CLP sessions, each session's command history is stored in a separate cache.
如果启动两个单独的交互clp会话,每个会话的命令历史记录都存储在单独的缓存中。
When we run this procedure from DB2 command line processor (CLP), it returns the location NEW YORK for department 10.
当我们在DB2的命令行处理器(CLP)中运行这个过程时,它对部门10会返回位置NEWYORK。
When you use the "-a" option of the CLP to display the SQLCA information, the code pages of the source application (in this case the CLP), and the target database are shown.
当您使用CLP的“-a”选项来显示SQLCA信息时,将展示源应用程序(本例中,CLP)和目标数据库的代码页。
Please see DB2 documentation for complete syntax for the DB2 CLP commands shown below.
关于下面展示的DB 2CLP命令的完整语法,请参阅DB 2文档。
The DB2 UDB command line processor (CLP) represents an interface through which you can conveniently access DB2 UDB functions.
DB 2UD b命令行处理器(CLP)是一个接口,通过这个接口可以方便地访问DB 2udb函数。
The DB2 CLP can be invoked from the DB2 command line, through command scripts, and even through a graphical user interface.
DB2CLP可以从 DB2命令行调用、通过命令脚本调用,甚至通过图形用户界面来调用。
To do an offline backup using the command CLP is simple.
使用命令CLP进行离线备份是很简单的。
The CLP interprets any text string that is prefixed by a double hyphen (--) as a comment.
CLP 将前缀为两个连字符的所有文本字符串都解释为注释。
In DB2 EEE, issuing a simple command from the DB2 command Line Processor (CLP) prompt creates the database.
在DB 2EEE中,可从DB 2命令行处理器(CLP)提示符发出一个简单命令来创建数据库。
A health snapshot can also be captured using the command line processor (CLP).
健康快照还可以通过命令行处理器(CLP)获取。
When the CLP encounters the line continuation character, it reads the next line and concatenates both lines.
CLP遇到行连续符时,它会读取下一行并将两行连接起来。
In the CLP, you will issue the following commands to do a restore and roll forward a full database.
在CLP中,您将发出下面的命令来执行恢复,并前滚整个数据库。
To run the script, you simply establish the CLP connection and then execute the appropriate script.
要想运行此脚本,只需建立CLP连接,然后执行脚本。
DB2 UDB provides sample CLP scripts that you can run against the sample database that comes with DB2.
DB 2UDB提供了示例clp脚本,可以对随db2提供的SAMPLE数据库运行这些脚本。
Close the CLP and open it again, for the operation to take effect.
关闭CLP并重新打开它,以使操作生效。
The CLP accepts commands or SQL statements from a DB2 command line.
CLP接受来自DB 2命令行的命令或sql语句。
This cannot be done from the CLP.
这不能从CLP中完成。
Your DB2 CLP window should look similar to Figure 5.
DB 2CLP窗口应与图5类似。
应用推荐