Question

4
Replies
2477
Views
John Talbot (TALBJ)
PEGA
Sr. System Architect
Pegasystems Inc.
JP
TALBJ Member since 2010 19 posts
PEGA
Posted: November 29, 2016
Last activity: November 30, 2016
Posted: 29 Nov 2016 2:22 EST
Last activity: 30 Nov 2016 22:14 EST
Closed
Solved

Do Connect-SQL rules have any access to the blob contents

We found the following content in the PRPC help files, and it sort-of implies that RDB methods do not have access to the blob contents.  Can anyone categorically confirm this for us. 


 



RDB-List method

Methods and instructions by function

Use this method to retrieve rows from an external relational database and place the results as embedded pages in a specified step page of class Code-Pega-List.


This method references a Connect SQL rule instance, and executes SQL statements stored in the Browse tab of that rule instance. The search can do anything you can specify in a SQL statement, such as a SELECT WHERE statement. Any constraints on the returned data are in the SQL.

We found the following content in the PRPC help files, and it sort-of implies that RDB methods do not have access to the blob contents.  Can anyone categorically confirm this for us. 

 

RDB-List method

Methods and instructions by function

Use this method to retrieve rows from an external relational database and place the results as embedded pages in a specified step page of class Code-Pega-List.

This method references a Connect SQL rule instance, and executes SQL statements stored in the Browse tab of that rule instance. The search can do anything you can specify in a SQL statement, such as a SELECT WHERE statement. Any constraints on the returned data are in the SQL.

On the Browse tab of the Connect SQL rule, use the special data syntax described in Connect SQL rules — Data mapping.

In all but rare cases, use Connect SQL rules only with an external database. Do not use Connect SQL rules or RDB methods for the PegaRULES database(s). Because not all properties in the PegaRULES 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.

 

 

Low-Code App Development Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.