Hi all, as part of our PCI policy we are planning to delete any aged credit card data from the Transcend database periodically. Does any of you have any SQL script for this purpose that you can share? We could not find any built-in report in Transcend client to do this job. So before start digging into the Transcend database to write a new script thought I would first check if any of you have anything like this which we can use.
Advanced thanks for any help. Any suggestion, comment will be highly appreciated.
Mo
Mohiuddin,You can contact Transcend support and they will send code you can run to purge transactions based on criteria you specify (date/time).For the record, when I asked about this, I was told Transcend keeps transactions for 18 months by default.Best of luck.Thanks.Dan
Thanks Dan. We got the code from Intrix. If anyone else is interested to know, there is a procedure P_ARCHIVE_TPAU_DATA for removing transactions. Anyway, Intrix sent us few other procedures and suggested we update them before we run this SP.
"For the record, when I asked about this, I was told Transcend keeps transactions for 18 months by default." - Good to know this. Thanks!