Reply posted on July 7, 2016 by KRISHNAVAMSIG
How to add a new column to an existing database table? I am using version 7.
Collaborate with developers, support engineers, and experts who build and work with Pega products and services. Join us to get fast answers to your questions, and participate in our Ask the Expert sessions!
Congratulations to Al Wells from Monster Pixel on being this week's Participant of the Week! Last week Al posted a few questions and not only did he find the answers, he updated the thread as such to help others in the PSC! Congrats again!
Thanks for approach you mentioned. Only issue with above approach is when we have large number of records in a spreadsheet, Pega is loading all of them onto clipboard causing issues. Is there a way for us to mention how many records can be loaded to...
Hi Sumanth, Please look into this url https://pdn.pega.com/integration/how-to-map-an-external-database-table-to-a-class
pr_other table is a last resort for instances to get stored if it does not have any Data-Admin-DB-Table mapping (https://pdn.pega.com/sites/pdn.pega.com/files/help_v718/procomhelpmain.htm#database/database2/databasetablesbasics.htm?Highlight=pr_other)...
Thanks for the reply. It turns out the issue was with an Obj-Browse being incorrectly defined, not the external table itself. Once the Obj-Browse was corrected the data could be viewed.
Try this in your SQL Query 1- TIMESTAMP_FORMAT (TO_CHAR(INS_UPDATE_TMS,'MMDDYYYY HH24:MI:SS:FF'),'MMDDYYYY HH24:MI:SS:FF') AS UPDATETMS
Please wait while we search for PDN content that suits your question.