RDB-Open method
|
|
Use this method to retrieve a single row (record) of data from an external relational database and add the retrieved data into a specified clipboard page as property names and values. does it lock the row?
Use this method in conjunction with a Connect SQL rule that contains
SQL SELECT or EXECUTE statements in the
Open tab. Define the SQL statements so that
the database returns exactly one row. (To search the external database
with criteria that may sometimes find no rows, or find more than one row,
use the RDB-Browse method, not the RDB-Open method.)
On the Open tab of the Connect SQL rule, use the special data syntax described in Connect SQL rules — Data mapping. B-19856 REECR
Except in rare cases, identify in the
Step Page field the name of the page to be created by
this method. If the Step Page field of the step is
blank, this method clears the primary page of the current activity
and may change its class. Typically, this is not desirable. BERRB
11/1/06
Use Connect SQL rules and the RDB-Open method
only with an external database. Do not use Connect SQL rules or
RDB methods to updated the PegaRULES database(s). Because not all
properties in the Process Commander databases are distinct database
columns, use the Obj-Open and Obj-Save methods, not the RDB- methods,
with the PegaRULES database to prevent loss of data.
This method has four parameters. Three required parameters together identify a Connect SQL rule. The final parameter controls a processing option.
Parameter |
Description |
| OpenClass |
Enter the Applies To key part of the Connect SQL rule that defines the open SQL. This must match the class of the step page. B-17337 requiredB-21488 BUG-1115 required
|
| RequestType |
Enter the third key part — Request Type — of the Connect SQL rule containing the open operation. B-17337 requiredB-21488 BUG-1115 required |
| Access |
Enter the second key part — Package
Name — of the Connect SQL rule (by convention
|
| RunInParallel |
C-505 Select if you want processing for the connector to continue in a separate requestor, in parallel with the current requestor. When selected, use the Connect-Wait method later in the current or a later activity to access results from the connector. Clear if you want processing in the current requestor session to wait until the connector processing completes. |
This method uses the three required parameters and rule resolution to retrieve a Connect SQL rule.
Next, the system processes the SQL text on the Open tab of the Connect RDB rule, performing any keyword evaluations and clipboard substitutions. It then sends the resulting SQL text to the external database. When Process Commander receives the results from the external database, it places the results into the single clipboard page identified in the Step Page column of the step.
The system chooses the class of the results from the value of the pxObjClass property, if any returned from the database. In the common case that the RDB-Open method is used with an external database (rather than the PegaRULES database), the opened instance has no pxObjClass property: the system then determines a concrete class for its results from either:
Identify the exact class of
the rule. The system does not use class inheritance to find the
Rule-Connect-SQL rule instance. GENTJ 10/18/02
11/28/06CLASS instructions within the SQL statement. If the
SQL statement contains more than one CLASS directive, the most
specific concrete class is used. VAGUE GENTJ 11/28/06If the step page exists, the system changes the class of the step page to the class determined by the above algorithm. GENTJ 11/28/06 If the step page does not exist, the system creates a new page with a that class. GENTJ 11/28/06 SDAS/OLSOK 12/05/05 and SR-210 and B-15556 rejected
If the external database request returns no rows, or more than one row, the step page is not updated and the method returns a fail status. TURBT 10/21/02
When the RunInParallel box is selected, the SQL operation occurs in a new requestor session. This temporary requestor has the same access group and clipboard as the original. At most 10 such child requestor sessions can be active at once.GAJNJ 4/13/04
Each RDB-Open, RDB-Save, and RDB-Delete method
involves an SQL database commit operation. You cannot implement SQL
transaction commit operations spanning two or more Connect SQL rules.
TURBT 7/9/03
You can use the DB Trace feature of the Performance tool to view in depth the SQL operations of a Connect SQL rule. TURBT 4/7/05
This method updates the pxMethodStatus property. See How to test method results using a transition.
When a {SQLPage:pagename} directive appears as the first line of the SQL code on the Open tab, a top-level page named pagename is created. If errors occur, properties on that page contain additional error details. (When RunInParallel is selected, this page is not available to the original requestor.)
B-11491 This method cannot be used in a step that involves iteration. R-9291 7/2/03 LACOD REMOVED
|
About Connect
SQL rules Connect-Wait method Connect SQL form — Data Mapping About the Performance tool |