Question

4
Replies
220
Views
MARKO929 Member since 2011 11 posts
Cahaba Gba
Posted: 4 years ago
Last activity: 4 years 1 month ago
Closed
Solved

PEGA DB2 SQL View

I have an instance of PEGA 7.1.6 and the view 'PWBV4_RULE_LOCKING' is differnet in our Development region from our QA and Production region. Does anyone have the correct SQL script that this view uses? I need to sync up our database regions. Below are the 2 definitions pof the view that we have. Thanks for the help.

 

From Development:

 

create view PROD.pwbv4_rule_locking

AS

SELECT

   pxCreateDateTime,

            'Data-Rule-Locking' AS pxObjClass,

            pxInsName,

            pyClass,

            pyClassName,

            pxUpdateDateTime,

            pxUpdateOpName,

            pxUpdateOperator,

            pyLabel,

            pyRuleName,

            pyRuleSet,

            pyRuleSetVersion,

            pyCircumstanceProp,

            pxInstanceLockedBy,

            pzInsKey,

            pyCircumstanceVal, 

            pyRuleAvailable

FROM PROD.pr4_rule_vw WHERE pyClass != 'Rule-Obj-Class';

 

From QA

--------------------------------------------------

-- Create View PROD.PWBV4_RULE_LOCKING

--------------------------------------------------

CREATE VIEW pwbv4_rule_locking AS SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_rule WHERE pxObjClass LIKE 'Rule-%' UNION SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_rule_file WHERE pxObjClass LIKE 'Rule-%' UNION SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_fieldvalue WHERE pxObjClass LIKE 'Rule-%' UNION SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_rule_flow WHERE pxObjClass LIKE 'Rule-%' UNION SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_rule_property WHERE pxObjClass LIKE 'Rule-%' UNION SELECT 'Data-Rule-Locking' AS pxObjClass,pxInsName,pxObjClass AS pyClass,pxUpdateDateTime,pxUpdateOpName,pxUpdateOperator,pyLabel,pyRuleSet,pyRuleSetVersion,pyCircumstanceProp,pxInstanceLockedBy,pzInsKey FROM pr4_rule_sysgen WHERE pxObjClass LIKE 'Rule-%';

***Updated by Moderator: Marissa to update categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn