用户可以使用CREATETYPEMAPPING语句覆盖过程参数的默认类型映射。
The user can use the CREATE TYPE MAPPING statement to override the default type mapping for procedure parameters.
先看一下CREATEPROCEDURE语句,确定每个存储过程所需要的参数。
First look at the CREATE procedure statement to confirm what parameters each of the stored procedures expects.
如果存储过程不包含任何OUT参数,那么还可以在执行动态sql语句的工具(例如ij工具)中使用CALL来调用它。
If the stored procedure does not include any OUT parameters, it can also be invoked using CALL in a tool that executes dynamic SQL statements, such as the ij tool.
以accessintent参数为基础,存储过程能决定如何处理select语句,从而避免死锁或提高性能。
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.
这个键(或多个键)用于替代这个参数标记(或多个标记),参数标记被定义为在RPG handle_open子过程中创建的sql语句字符串的一部分。
The key (or keys) are used to replace the parameter marker (or markers) which were defined as part of the SQL statement string created in the RPG HANDLE_OPEN sub-procedure.
如果您的JDBC程序使用已经准备好的语句和参数标志,并且如果在数据库语句缓存中找到了它们的话,查询过程将处理地更快。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
procedure视图允许您定义过程属性、参数及参数属性、存储过程的实际SQL 语句以及过程的返回类型。
The procedure view allows you to define procedure attribute, parameters, and its properties, the actual SQL body of the stored procedure, as well as the return types for the procedure.
如果两个或更多的数据源过程具有相同的模式和过程名,但是参数数量不同,那么可以在CREATEprocedure语句中指定NUMBEROFPARAMETERS。
If two or more data source procedures have identical schema and procedure names, but different Numbers of parameters, then the number of parameters can be specified in the CREATE procedure statement.
这些语句也规定程序员可以选择的变量与参数种类,以及当一个表达式使用过程或函数时代码将返回的值的类型。
These statements also define the kinds of variables and parameters the programmer can choose and the type of value that the code will return when an expression accesses the procedure or function.
在编目或流内过程中使用的一种作业控制语句,可用来对包含在过程中的符号参数赋予系统设定值。
A job control statement used in cataloged or in-stream procedures. It can be used to assign default values for symbolic parameters contained in a procedure.
天赋论学者预测,语序获得是一个迅速的过程,中心语参数一旦设定儿童将不会使用非母语语序来理解和产出语句。
The nativist scholar would predict rapid acquisition of word order, and a reluctance to adopt non-target word orders at an early age;
天赋论学者预测,语序获得是一个迅速的过程,中心语参数一旦设定儿童将不会使用非母语语序来理解和产出语句。
The nativist scholar would predict rapid acquisition of word order, and a reluctance to adopt non-target word orders at an early age;
应用推荐