Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1583#discussion_r191635290
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -2284,27 +2289,27 @@ contains a `java.sql.resultset[]` object. If the
method contains a result set ob
The actual number of result sets returned by the SPJ method can be fewer
than or equal to this number. If you do not specify
this option, then the default value is 0 (zero), meaning that the SPJ does
not return result sets.
-* `transaction required | no transaction required`
+* `TRANSACTION REQUIRED | NO TRANSACTION REQUIRED`
+
-determines whether the SPJ must run in a transaction inherited from the
calling application (`transaction required`, the default
-option) or whether the SPJ runs without inheriting the calling
applicationâs transaction (`no transaction required`). Typically,
+determines whether the SPJ must run in a transaction inherited from the
calling application (`TRANSACTION REQUIRED`, the default
+option) or whether the SPJ runs without inheriting the calling
applicationâs transaction (`NO TRANSACTION REQUIRED`). Typically,
you want the stored procedure to inherit the transaction from the calling
application. However, if the SPJ method does
not access the database or if you want the stored procedure to manage its
own transactions, then you should set the stored
-procedureâs transaction attribute to no transaction required. For more
information, see
+procedureâs transaction attribute to `NO TRANSACTION REQUIRED`. For more
information, see
<<effects_of_the_transaction_attribute_on_spjs,effects of the transaction
attribute on SPJs>>.
<<<
-* `deterministic | not deterministic`
+* `DETERMINISTRIC | NOT DETERMINISTRIC`
+
specifies whether the SPJ always returns the same values for out and inout
parameters for a given set of argument values
-(`deterministic`) or does not return the same values (`not deterministic`,
the default option). If you specify `deterministic`,
+(`DETERMINISTRIC`) or does not return the same values (`NOT
DETERMINISTRIC`, the default option). If you specify `DETERMINISTRIC`,
--- End diff --
Oops :stuck_out_tongue_closed_eyes: thanks for your reminding, I've fixed
:blush:
---
