It USES the DROP procedure command on the DB2 logging stored procedures, and if they do not yet exist in the database, you will see the error message above.
它对DB 2日志存储过程执行dropPROCEDURE命令,如果在数据库中不存在日志存储过程,就会看到上面的错误。
While accounting is common across many UNIX variants, the procedure for setting it up, especially with respect to the command and data directories, might be different.
尽管在许多UNIX变体中,记帐功能比较常见,但是其设置过程,尤其是对于具体的命令和数据目录,可能有所不同。
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存储过程。
This article looks at a procedure to assign disks from storage to host using DS Command Line Interface with improved performance.
本文将介绍一种操作步骤,它可以使用DS命令行接口,以更高的效率将存储系统的磁盘分配给主机。
Generally, you will execute this stored procedure either from command line using CLP or DB2 command editor to update the logging parameters.
通常,我们会在命令行中使用clp或db2命令编辑器来执行这个存储过程,以实现对日志参数的更新。
When we run this procedure from DB2 command line processor (CLP), it returns the location NEW YORK for department 10.
当我们在DB2的命令行处理器(CLP)中运行这个过程时,它对部门10会返回位置NEWYORK。
DB2 has a "CALL" command that you can use to invoke any stored procedure.
DB2有一个“CALL”命令,可以使用它调用任何存储过程。
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命令调用的版本。
ADMIN_CMD Procedure Executes DB2 command line processor (CLP) administrative commands using the SQL CALL statement.
ADMIN_CMD过程使用SQLcall语句执行db2命令行处理器(CLP)管理命令。
The drpcidl command also generates a class for each complex data type used in a procedure, such as structures and unions, with methods to get and set each field in the structure.
drpcidl命令也为过程中使用的每个复合数据类型(例如结构(structures)和联合(unions))生成了一个类,使用该方法可以获取并设置结构中的每个字段。
Figure 5 shows you how to use the Command Editor to call this stored procedure, using a quota value of 25.
图5显示了如何使用CommandEditor调用这个存储过程,使用的配额值为25。
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命令中所定义的数据集源列。
'idssetport' command substitutes the above procedure.
“idssetport”命令取代上面的过程。
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文件夹。
Can the RUNSTATS command be issued from within an SQL routine (procedure, UDF, method)?
可以在SQL例程(过程、UDF和方法)中发出RUNSTATS命令吗?
DB2Command - The command object allows for executing any supported SQL statement or stored procedure using a data connection object.
DB 2 Command-该命令对象支持使用数据连接对象执行任何受支持的sql语句或存储过程。
Next, run through the same procedure to create the client key pair and keystore, this time using this command line (entered as a single line).
接下来,再次运行这个程序来生成客户机密匙对和keystore,这一次使用以下的命令(以单行形式输入)。
This procedure is cumbersome, as the same print command has to be run several times to display each node at a time.
这个过程非常麻烦,必须多次运行print命令,每次显示一个节点。
You can evaluate your clients to see if there was blockage with the nfsstat -rc command, which shows client Remote Procedure Call (RPC) statistics.
可以用nfsstat -rc命令评估客户机,了解是否有阻塞的现象,这个命令显示客户机远程过程调用(RPC)统计数据。
The "create existing table" command in Sybase ase allows you to map the proxy table to a table, view, or procedure at a remote location.
Sybasease中的“createexistingtable ”命令允许将代理表映射到在远程位置的一个表、视图或者过程。
The db2look command with the -ct option generates the procedure TEST.SP2 before TEST.SP1.
附带-ct选项的db2look命令生成的 TEST.SP2 过程比 TEST.SP1 早。
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命令或存储过程的名称。
When the Sybase "create existing table" command is executed for a stored procedure, Sybase does not validate the attributes of the columns of the stored procedure's result set.
当为一个存储过程执行sybase “createexistingtable ”命令时,Sybase并不验证存储过程结果集的各列的属性。
Without the GUI, Linux (or any operating system) requires users to type commands in a procedure that is known as the command Line Interface (CLI).
如果没有GUI,Linux(或其它任何操作系统)会要求用户依次输入各种命令,也就是命令行模式(CLI)。
For some browsing applications to parse the CREATE PROCEDURE statement itself, you need the command delimiter to be something other than a semicolon.
对于要分析CREATEPROCEDURE语句本身的某些浏览应用程序而言,需要采用不是分号的其它命令分隔符。
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 '。
You can turn the output on or off by using the command ADMIN command 'usertrace {on | off} user username procedure procedure _name'.
可以通过下面的命令开启或关闭输出:adminCOMMAND'usertrace {on |off}userusername procedure procedure _ name'。
应用推荐