Discussion

2
Replies
392
Views
CHIRANJEEVI-2 Member since 2010 4 posts
Virtusa
Posted: 4 years ago
Last activity: 4 years 5 months ago
Closed

Connect-SQL Schema

Hi Team,

We have created one data table in PEGA schema and using connect-SQL i tried to connect to the table to perform Create/Delete/Update operations. In the connect SQL i did not mention any schema before table name, i called this SQL on the page where the class of this page is mapped to the table using Data base table rule. I am able to connect this table in E1 dev environment. At run time schema name will be getting from the data base table urle.

But when it moves to E2-UAT environment, it is not working. But if i hard code the schema name before the table in the connect-SQL rule it is working properly.

Could you please suggest why it is behaving differently in higher environments.

Thanks,

Chiranjeevi M

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn