In this article we demonstrated how you can easily make almost any DB2 command available for any application by wrapping it into a stored procedure.
在本文中,我们演示了如何将DB 2命令封装在存储过程中,使得几乎任何应用程序都可以访问任何DB 2命令。
If desired, you can develop and deploy an equivalent SQL stored procedure using DB2's command line processor.
如果需要,您可以使用DB2的命令行处理器开发和部署一个等价的SQL存储过程。
If you start two separate interactive CLP sessions, each session's command history is stored in a separate cache.
如果启动两个单独的交互clp会话,每个会话的命令历史记录都存储在单独的缓存中。
We have used this command to check that the file is indeed stored in the specified pool.
我们使用该命令来检查文件是否确实存储到了特定池中。
Generally, you will execute this stored procedure either from command line using CLP or DB2 command editor to update the logging parameters.
通常,我们会在命令行中使用clp或db2命令编辑器来执行这个存储过程,以实现对日志参数的更新。
DB2 has a "CALL" command that you can use to invoke any stored procedure.
DB2有一个“CALL”命令,可以使用它调用任何存储过程。
The command creates a script that is run automatically and stored in the directory from which the command was issued.
该命令创建一个脚本,该脚本将自动运行,并存储在发出该命令的目录中。
A statistics profile is registered or stored in the table descriptor and system catalogs when the command parameter "SET profile" is added to the RUNSTATS command.
当将命令参数“SETPROFILE”添加到RUNSTATS命令时,将在表描述符和系统目录中注册或存储统计信息配置文件。
To use the backup images stored on your NIM server to recover your VIO server, you need to issue the following command on the HMC (see Listing 7).
要使用NIM服务器中存储的备份镜像来恢复您的VIO服务器,您需要在HMC中执行下列命令(请参见清单7)。
This command can only be used in cases where the change to the schema is backward-compatible, and the updated schema is automatically applied to all XML documents that are stored in the database.
只有以下情况才能使用该命令:模式的改变是向后兼容的;已更新模式被自动应用到所有存储在数据库的XML文档。
The SQL stored procedure that executes the ADD CHUNK command reads these results.
执行addCHUNK命令的SQL存储过程将读取这些结果。
DB2 V8.2.2 is the first release where the invocation of a CLP command can be handled by a stored procedure.
DB 2V8.2.2是第一个可以通过存储过程处理CLP命令调用的版本。
In addition, you can run simple queries from a DB2 Command Window to test how the form data was stored.
另外,可以从DB 2CommandWindow运行简单查询来测试表单数据是如何存储的。
However, the DB2 command line processor (CLP) can invoke stored procedures using the following syntax.
然而,DB 2命令行处理程序(CLP)可以使用以下语法调用存储过程。
The following command encodes the text from Figure 1 when stored as regular text in the acmesrc.txt file and stores it in an image file called acmeqr.png.
如下的命令编码作为常规文本存储于acmesrc. txt文件内的来自图1的文本,并将其存储在一个名为acmeqr . png的图像文件。
Figure 5 shows you how to use the Command Editor to call this stored procedure, using a quota value of 25.
图5显示了如何使用CommandEditor调用这个存储过程,使用的配额值为25。
This command exports the public key for the personal certificate stored in jmskeystore to a file called jmsclient.key.
该命令将用于个人证书(存储在jmskeystore下)的公钥导出到名为jmsclient . key的文件中。
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语句还是存储过程调用。
Open a Windows command prompt and navigate to the COBOL stored procedure samples folder.
打开一个Windows命令提示,进入COBOL存储过程的samples文件夹。
By default for a newly created database, none of the database object statistics is collected and stored in SYSSTAT catalog views until the runstats command is performed.
默认情况下,对于新创建的数据库,直到执行了runstats命令之后,才会收集数据库对象统计数据并将之存储在SYSSTAT目录视图中。
Example 22: Register a statistics profile and execute the RUNSTATS command options of the stored statistics profile to collect catalog statistics.
示例22:注册一个统计信息配置文件,并执行所存储统计信息配置文件的RUNSTATS命令选项来收集目录统计信息。
DB2Command - The command object allows for executing any supported SQL statement or stored procedure using a data connection object.
DB 2 Command-该命令对象支持使用数据连接对象执行任何受支持的sql语句或存储过程。
Your home directory is stored in the variable $HOME. That means that the cd command without parameters is equivalent to typing cd $HOME (see Listing 12).
主目录保存在变量 $HOME 中,这意味着不带参数的cd命令相当于运行 cd $HOME(参见清单 12)。
While testing stored procedures during development from the command line, you may need to create dummy XML documents to send as input parameters. Listing 4 provides a simple technique to do that.
尽管在开发期间可以从命令行测试存储过程,但是可能需要创建虚构的XML文档,它们将作为输入参数发送。
Note that whenever an item is put into Subversion using the import command, a whole new copy of the item is stored, with no attempt made to save it as deltas.
注意,每当使用import命令将一项内容存入Subversion中,就是存储该项的整个副本,而不会尝试以增量形式存储它。
Be aware that the -dn entry in the command defines the root for the distinguished names of the objects to be stored in the database repository.
请注意,命令中的- dn项定义要存储在数据库存储库中的对象的专有名称的根。
For stored procedures, you can map the input and output parameters of the stored procedure to the data set source columns as defined in the select command.
对于存储过程,您可以将该存储过程的的输入和输出参数映射到select命令中所定义的数据集源列。
With this file stored in a file called weattherreq.xml, the command line in Listing 3 sends its contents to the SOAP endpoint URL specified on the same XMethods Web page where I got the sample XML.
这个文件存储在名为weattherreq .xml的文件中,清单3中的命令行将它的内容发送到我获得样本xml的同一个XMethodsWeb页面上指定的soap端点url。
Based on the value of CommandType, the CommandText property is interpreted differently: it's either considered to be the name of a table, a SQL command, or the name of a stored procedure.
根据CommandType的值,将以不同的方式解释commandtext属性:可将之视为表、SQL命令或存储过程的名称。
The histfile variable lets the user specify the name of the file where the command execution history should be stored; the default is $HOME/.history.
histfile变量用来指定存储命令执行历史的文件;默认设置是 $HOME/.history。
应用推荐