Question

1
Replies
69
Views
MarkH960 Member since 2012 46 posts
Ameriprise Financial
Posted: 3 years ago
Last activity: 3 years 10 months ago
Closed

CS Framework issue

When we ran the sql created by the CS Framework install one of the commands failed as you can't alter a table with values in it.

ALTER TABLE SSWMD01.pc_data_workattach MODIFY “PXATTACHKEY” DATE

This is problematic for us as the table in production has over 66 million rows. What is the Pega recommendation (this is an oracle database) for the most efficient way of getting this table's column changed from varchar to date?

**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