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.
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.
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.)
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.
This method has four parameters. Three required parameters together identify a Connect SQL rule. The final parameter controls a processing option.
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.
Enter the third key part — Request Type — of the Connect SQL rule containing the open operation.
Enter the second key part — Package Name — of the Connect SQL rule (by convention MSSQL, Oracle, DB2, UDB, or Sybase, but you are not restricted to these values).
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.