I would appreciate!

With %CELL you should be always aware when you add any dimension, measure or property in MDX if you need to change %CELL expression too due to new columns rows or because of deletions of rows and cols.

I agree with you. As mentioned it is an option if you need to use %Status as a method result. 

And what about e.Log() - do you use it to log errors or use something else? 

OK. But how do you call methods which return %Status?

Do you raise Error? Or you check Error status with if? Or do you ignore status at all?

Timothy! Thanks for sharing this!

It' can be a standalone post as "Error and resource handling in large Caché ObjectScript project".

Thank you!

Hi, Nic!

Thank you for your answer!

Would you please put it on Stackoverflow too? http://stackoverflow.com/questions/36400699/how-to-avoid-writing-duplic…
Thank you in advance!

Thank you Kenneth!

But what if you need a part of data? Say the records only from current year or from particular customer?

And what if you need not all the classes, but part of them - what globals should I choose to export?

I believe in this cases we should use SQL to gather data. The question is how to export/import it.

If so, create a new database on instance A and then use GBLOCKCOPY to copy from the existing database to the new one.   Then just move the new database to instance B.

That can help sometimes. Thank you. Just move - you mean unmount and download cache.dat file?

Is this a one-time migration of data from instance A to instance B?

My question is a request for general  approaches.  But my task now is to extract some part of consistent data from the large database to use it as test data in my local database for development purposes.

Thank you, Ed. And I can import the result on Instance B with class .... ?

This is MUMPS-Enigma code)