Question
Morgan Stanley
IN
Last activity: 1 Aug 2018 13:55 EDT
How to execute DDL in Pega 7.3.1
Hi
I have a requirement to create a view from PRPC.
I tried using Connect SQL rule, but i get an error message " Issued a DDL statement through executeRDB - DDL changes should not use this method!"
while executing the RDB-Save in activity.
Is there any other method that can be used to execute DDL
***Updated by moderator: Lochan to add Categories***
JPMorgan Chase & Company
US
Morgan Stanley
IN
Thanks Sudhakar.
Yes, I'm trying to execute DDL through Connect-SQL.
Can we create a stored procedure through a RAP?
My requirement is to just create a view.. Can you provide some insight into how schema modification can be used for the same purpose?
JPMorgan Chase & Company
US
Hi,
You can create stored procedure and write script to create view. Call stored proc from Connect-SQL.
Accenture
US
As suggested by Sudhakar, you can go for the Stored Proc. You may try RDB-List and mentioning the query in Browse tab of Connect-SQL.
However, I would recommend the Stored Proc method.
Wartsila Corporation
FI
Hi,
I am also facing the same issue, I don't have access to DB, hence i can't create SP as well. What would be the next step?
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.
Wartsila Corporation
FI
Below is the link for new post that i created.
https://collaborate.pega.com/question/ddl-execution-using-rdb
Pegasystems Inc.
US
Thanks Krishna!
Hi,
Connect-SQL is used for complex Structured Query Language statements such as joins or stored procedures to update or extract information from an external database.
As you trying to execute DDL statements, please go with the Schema modification using the Modify Schema wizard or write DDL statements in stored procedure.