Through this parameter, you can turn off the logging by all the stored procedure at run time.
利用这个参数,可以在运行时关闭所有存储过程的日志。
Persist parameter information provides the list of parameters for which the values can be entered for each procedure or function, and these values are persisted.
持久化参数信息,提供了一个参数列表,可以为每一个过程或函数输入参数值,并且持久化保存这些值。
This procedure requires the name of the log file as an input parameter.
这个过程需要使用日志文件名作为输入参数。
Please note that this procedure has one input and one output parameter.
请注意,这个存储过程有一个输入参数和一个输出参数。
This next example shows how to call a stored procedure that needs a parameter value.
下一个例子将展示如何调用需要一个参数值的存储过程。
The use of this stored procedure required only the parameter value and the name of the stored procedure itself to be sent from the client application to the database server.
要使用存储过程,仅需从客户机应用程序向数据库服务器发送参数值和存储过程本身的名称即可。
It is identified by an index name that is a parameter to the stored procedure.
它由索引名称标识,索引名称是存储过程的一个参数。
The procedure takes the fully-qualified name of a table as input parameter and sets up the necessary data structures that are passed to the API function.
该过程以一个表的全限定名称作为输入参数,并设置必要的数据结构,以便将这些数据结构传递给api函数。
At runtime, we're not happy with just seeing the result of the stored procedure with the default parameter value.
在运行时,仅仅看到有默认参数值的存储过程结果是无法令人满意的。
You can also specify parameter definitions, including the parameter name, mode, data type, and other extended properties, for the procedure.
您还可以为过程指定参数定义,包括参数名、模式、数据类型及其他扩展属性。
Parameter data types are pre-filled based on the DB2 platform for the procedure for easy selection.
可以根据过程的DB 2平台预先填写参数数据类型,以便于选择。
Using the DB2 database project properties, you can specify the compilation data connection as well as the startup stored procedure and parameter values.
通过DB 2数据库项目属性,您可以指定编译数据连接,以及启动存储过程和参数值。
The return value becomes the first parameter of the federated procedure.
返回值变成联邦过程的第一个参数。
For parameter passing and stored procedure invocation you have to make a final adjustment.
要想完成参数的传递及存储过程的调用,必须要做最后一个调整。
When you choose to run the same procedure or function again, the parameter values are pre-filled with values from the previous run of that particular procedure or function.
当您再次选择运行相同过程或函数时,系统将使用从上一次运行该特定过程或函数中得到的值预填充参数值。
Named parameter makes the application robust so that you don't need to change the application even if the sequence of the parameter in the stored procedure changes.
命名参数使应用程序更加健壮,所以,即使存储过程中参数的顺序发生了改变,也不必修改应用程序。
The CLOSE_LOG procedure requires the logging handle as the input parameter.
CLOSE_LOG过程需要使用日志句柄作为输入参数。
In most cases you will want to use an application to invoke the stored procedure dynamically, using parameter markers and so on.
在大多数情况下,希望让应用程序使用参数标志等动态地调用存储过程。
There is a new CONNECT_PROC database configuration parameter that you can set to the name of a stored procedure.
有一个新的CONNECT _ PROC数据库配置参数,可以把它设置为存储过程的名称。
SYSCAT.ROUTINEPARMOPTIONS -- Contains information about federated procedure parameter options values such as the remote parameter name and the remote parameter type name.
ROUTINEPARMOPTIONS ——包含关于联邦过程参数选项值的信息,比如远程参数名和远程参数类型名。
A procedure with a table parameter can only be invoked from the triggered action of a trigger.
带有表参数的过程只能从触发器的触发操作调用。
The number of parameters and the size of the parameters in the stored procedure could definitely have an impact with this configuration parameter.
存储过程中的参数数量和参数大小明确地影响这个配置参数。
A point to note here is that if this approach is followed, the calls to the original UDF will have to be modified so that they now execute the stored procedure, and supply an extra OUT parameter.
这里要注意一点:如果采用这种方法,就必须修改对原udf的调用,改为执行存储过程并提供一个额外的OUT参数。
A BLOB variable is declared for the procedure output parameter.
将过程输出参数声明为blob变量。
In Listing 24, the procedure proc is coded to return an OUT parameter value, which is denoted by the parameter marker (?), and was not coded to accept an input value.
在清单24中,过程被编码为返回一个OUT参数值,使用参数标记(?)表示,并且不能接受输入值。
To set this parameter, use the stored procedure DB2.UPDATE_SP_CONFIG, which is used for logging administration.
要设置这个参数,可以使用存储过程DB 2 . UPDATE_SP_CONFIG,该过程用来实现日志管理的工作。
Therefore, the next time you choose to run the same procedure or function, the parameter values are pre-filled with values from the previous run of that particular procedure or function.
因此,在下一次运行相同过程或函数时,这些值将被预填充为上次运行这些过程或函数的值。
Federated procedure parameter and result set data types.
联邦过程参数和结果集的数据类型。
Ability to set extended properties for a parameter in the Procedure properties.
能够在Procedure properties中设置参数的扩展属性。
Based on the AccessIntent parameter, the stored procedure can determine how to handle the SELECT statement to avoid a deadlock or otherwise improve the performance.
以accessintent参数为基础,存储过程能决定如何处理select语句,从而避免死锁或提高性能。
应用推荐