Scenario:
Rename many customer names.Solution:
If the table has many relations, it will take a long time to rename through the record information one by one. We can use the table method renamePrimaryKey() in a batch class and run in batch mode.CustTable custTable;
ttsBegin;
select firstOnly custTable
where custTable.AccountNum == 'XXXX-WC-00002';
if (custTable)
{
custTable.AccountNum = 'XXXX-WC-00001';
custTable.renamePrimaryKey();
}
ttsCommit;
Authentic content..very knowledgeable.. thanks for this post.
ReplyDeleteTally on Cloud Server
Tally on AWS
Thanks for this blog keep sharing your thoughts like this...
ReplyDeleteMVC Training in Chennai
React JS Training in Chennai
Thanks for your excellent content, keep sharing.
ReplyDeletePHP Training in Chennai
PHP Certification Online
PHP Training in Bangalore