Question
Accenture
SG
Last activity: 7 Sep 2017 14:43 EDT
Problem using obj open by handle to open external table(non pega table)
How do I use a the method obj open by handle in the activity to open a record in the external table (non pega table) with a primary key ie. ID?
***Updated by moderator: Lochan to add Categories***
Cognizant Technology Solution
US
You can only use Obj-Open-By-Handle if you have a column named pzInsKey on that table. Otherwise you have to go for Obj-Open. Before making an Obj-Open call make sure that in the class rule which is mapped to the table, the columns are shown properly mapped in External Mapping tab.
Pegasystems Inc.
IN
You can use RDB-Open method or RDB-List (to fetch more than one result) instead of Obj-Open or Obj-Open-By-Handle method.
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.
You can use RDB-Open method or RDB-List (to fetch more than one result) instead of Obj-Open or Obj-Open-By-Handle method.
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.
Use this method in conjunction with a Connect SQL rule that contains SQL SELECT or EXECUTEstatements 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.
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.
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 Pega 7 Platform 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.
Parameters
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. Identify the exact class of the rule. The system does not use class inheritance to find the Rule-Connect-SQL rule instance. |
| RequestType |
Enter the third key part — Request Type — of the Connect SQL rule containing the open operation. |
| Access |
Enter the second key part — Package Name — of the Connect SQL rule (by convention |
| RunInParallel |
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. |