go to post Bhaskar Bandyop... · Jan 22, 2018 oh.. yes .. Auditing and temporal are two different use cases
go to post Bhaskar Bandyop... · Jan 22, 2018 is this for the the purpose of auditing datachange ? then why not using the built in auditing function by turning on the audit database for the appropriate events ? Now the SQL Auditing is also available to monitor even data access.
go to post Bhaskar Bandyop... · Jul 26, 2017 what ODBC driver you are using ? Crystal's or InterSystems? Try using a later/est compatible InterSystems ODBC driver.
go to post Bhaskar Bandyop... · May 3, 2017 Have you tried Interface Explorer from http://www.laconic-designs.com/ ? It used to be a good tool when I tried it sometime back.
go to post Bhaskar Bandyop... · Apr 28, 2017 Common SQL tools like WinSQL can do that, since Cache is a supported database in WinSQL
go to post Bhaskar Bandyop... · Nov 21, 2016 Also, using classqueries if possible, can significantly impact your execution time and maintenance overhead.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...All the Best!Bhaskar
go to post Bhaskar Bandyop... · Aug 19, 2016 Adding to Ed's comment ( but possibly jumping forward a bit ) , some of the system variables which are often 'NEW'ed and examples can be found herehttp://docs.intersystems.com/cache201513/csp/docbook/DocBook.UI.Page.cls...
go to post Bhaskar Bandyop... · Aug 15, 2016 you may find some books in Amazon too ..possibly good to get you started as an additional resourcehttps://www.amazon.com/Cach%C3%A9-ObjectScript-MUMPS-Technical-Learning/...
go to post Bhaskar Bandyop... · Aug 15, 2016 Apart from a runaway process, one other activity that often increases the journal by leaps and bounds are bulk data loads, often in an data warehouse/datamart environment. I am sure Tani would cover this use case in his future address about minimizing it.
go to post Bhaskar Bandyop... · Jun 27, 2016 Ensemble SQL Adaptors are pretty good in syncing. Can that code be used here ?
