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 Kannan Raveendran Nair for achieving the title of Participant of the Week! Kannan believes in sharing knowledge. He proved to be an amazing participant by writing a knowledge share article on a topic that will be informative to the diverse audience in the community. Read his article here. Keep up the great work!
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.