Question Mike Kadow · Aug 9, 2017 %Library.Char The data type %Char or %Library.CharThe description says it is a fixed length character field.How do I set the fixed length?Or by just setting %Char to something, does that automatically define its length?Are the parameters MINLEN, MAXLEN involved? Or are these the way I set the fixed length?Any help with this? #Object Data Model #Caché 0 4 0 339
Question Mike Kadow · Jul 11, 2017 Relationships - iterate through all the Manys' side I am working with Caché Relationships.I know how to iterate through the One side of the relationship and for each One iterate through all the various Manys.What I have been trying to figure out, is the code (I can put into a Class) that will start at the top of the Manys, iterate down and for each of the Manys, pull the associated One.I can do this with SQL or Globals, but I want to use only Class type code.Is that clear? Any help? #Object Data Model #ObjectScript #Caché 0 6 0 629
Discussion Mike Kadow · Jul 3, 2017 Way, way out of my price range I know this may sound like sour grapes, but really it is not. I hear all the exciting things about the up coming InterSystems Conference, and I am sure it is. But it is way, way out of my price range, and I am sure out of the price range of most of the Cache/MUMPS developers, without company backing. Just wondering what others think. #Global Summit 2017 #Global Summit 3 4 0 523
Article Mike Kadow · Jun 26, 2017 1m read Listing type of output Here is an idea that would make the Developer Community immensely more valuable (to me anyway)Have the capability of getting Listing output from searches or tags or groups.In addition, have people put titles on their answers and comments,And having a detailed list with all the answers and comments if neededThen being able to sort the list by date or other criteria.Something like:Sub1 . . . .-answer . . .-comment . .-answer . . .Subject2 . . .-answer . . .Subject 3 . . .-comments . . . #DC Feedback 0 1 0 284
Question Mike Kadow · Jun 24, 2017 Why are the Answers and Comments after a post all jumbled up? I just tried to read all the Answers and Comments for a post of mine.Some were 5, 8, 3, etc. days ago and others were just hours ago.They all seem jumbled up.If I wanted to read the Answers and Comments in some sort of chronological order, I would be lost.I don't understand the reasoning on whether somethings is an Answer and others are comments.But would it be possible to have the option when reading all the follow-ons to re-sort them in some sort of order? #DC Feedback 0 3 0 260
Question Mike Kadow · Jun 15, 2017 Ways and methods of Accessing Relationships with SQL I am experimenting with Relationships, both Parent to Child and One to Many.I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?Thank you in advance for any help provided. #Caché #SQL 1 25 0 2.1K
Question Mike Kadow · Jun 12, 2017 Is Caché SQL essential to Caché Objects? I would like to start a discussion regarding Caché Objects and Caché SQL.It is my understanding that the creators of Caché Objects see Caché SQL as the reporting arm of Objects and as such SQL is essential to Caché Objects.I once met a Caché Objects programmer who was writing code to $Order through the Globals because that person thought that Caché SQL was too slow and inefficient. I attempted to convince the person otherwise.So, what say you? Is SQL essential to Caché Objects?Or #Caché #SQL 0 29 0 855
Question Mike Kadow · Apr 18, 2017 Cache/MUMPS process identify itself to either a process or system. I have a newbie question.How can a Cache/MUMPS process identify itself to either a process or system.I have an application running in two different processes and/or systems and want to make minor changes depending upon which process it is in.What is the easist way to do that.-thanks #Beginner #Caché 0 1 0 308
Question Mike Kadow · Feb 3, 2017 Analyze running Caché Routines for efficiency? Back in my COBOL days, there was a utility that would analyze running COBOL code and expose bottle necks and those modules that were inefficient or were executed multiple times. This was to help the programmer know where to concentrate streamlining efforts.Is there any such utility for Caché Routines? #Analytics #Caché 0 4 0 388
Question Mike Kadow · Oct 30, 2016 Ways to make NewBie post stand out. I create the NewBie posts.And as directed I use the Beginner tags.However, a lot of people are using the Beginner tags for other posts.Is there a way for separating the NewBie posts from the other Beginners?Failing that, can I in someway make the Newbie Index more visible?I am doing a lot of work on the NewBie Index to make it more useful. #DC Feedback 0 1 0 180
Question Mike Kadow · Oct 30, 2016 Community Feedback about saving a post but not yet releasing it I have a post I have published.Now I need to do some substantial work on it.I cannot do it all at one time, so I save it after I do some work.Trouble is, each time I save it, it is published and sent out in mail, which is not what I want.How can I save a post and not get it sent out? #Beginner #DC Feedback 0 1 0 327
Article Mike Kadow · Oct 24, 2016 3m read NewBie's Corner Session 21 Parameters Part II NewBie's Corner Session 21 Parameters Part IIWelcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.ParametersIn the previous session we saw how to call RtnB from RtnA with Parameters.We also defined Parameters as another name for Variables when used in passing data from one Routine to another, or, from one Label to another.Calling a routine from a Label, or to a Label, from within a routine is very similar to calling a routine itself. #Beginner #Caché 0 0 0 266
Article Mike Kadow · Oct 24, 2016 2m read NewBie's Corner Session 22 Parameters Part III NewBie's Corner Session 22 Parameters Part IIIWelcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.ParametersIn Sessions’ 20 and 21 on Parameters we saw how to call one routine from another with parameters as well as calling one Label from another with parameters. In these examples, the data was passed through the parameters from the calling routine or label to the called routine or label.Now suppose you wanted the called routine or label to pass data back? #Beginner #Caché 0 2 0 318
Article Mike Kadow · Sep 24, 2016 1m read NewBie's Corner Session 29 Documentation on the Caché/MUMPS Globals Structure NewBie's Corner Session 29 Documentation on the Caché/MUMPS Global Structure Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material. This post contains several links to very good documentation of the Caché Globals Structure. Like I said, "Perhaps the most difficult concept in Caché/MUMPS is its Global Structure." universalNoSQL.pdf - http://mgateway.com/docs/universalNoSQL.pdf #Beginner #Caché 0 6 0 471
Article Mike Kadow · Sep 23, 2016 5m read NewBie's Corner Session 28 Various Methods to Traverse a Global NewBie's Corner Session 28 Various Methods to Traverse a Global Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material. Judging from the number of responses to Session 27 Traversing A Global, developers are passionate about their methods. I am not here to judge the merit of the various methods. Over the next few pages I will demonstrate a number of methods to Traverse a Global. If you don't already have a favorite they may help you pick one. #Beginner #Caché 2 13 0 627
Article Mike Kadow · Sep 15, 2016 2m read NewBie's Corner Session 27 Traversing A Global with $Order Part 1 NewBie's Corner Session 27 Traversing A Global with $Order Part 1Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.Traversing A GlobalPerhaps the most difficult concept in Caché/MUMPS is its Global Structure. This session and several that follow it deals with the Global Structure. However, just presenting the material will not guarantee your understanding of it. You must experiment with the data and concepts that are presented. #Beginner #Caché #Globals 1 20 0 815
Article Mike Kadow · Sep 10, 2016 3m read NewBie's Corner Session 26 Globals and Arrays Part 2 NewBie's Corner Session 26 Globals and Arrays Part 2Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.Globals, Arrays, and Variables Part 2A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.Uniqueness of the Caché Global Structure or database #Beginner #Caché 0 0 0 362
Article Mike Kadow · Sep 7, 2016 3m read NewBie's Corner Session 25 Globals and Arrays Part 1 NewBie's Corner Session 25 Globals, Variables, and Arrays Part 1Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.Globals, Arrays, and VariablesA thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.A Global may be:Scalar (a single element), as in a Global Variable #Beginner #Caché 0 0 0 497
Question Mike Kadow · Sep 4, 2016 Create a Json extract I want to create a simple Json extract from a database in Cache. Suggestions as to classes, method, etc. are most welcome. #JSON #Caché 0 4 0 436
Article Mike Kadow · Sep 2, 2016 1m read Quickest way to backup routines I have found this one line command from the Terminal is the quickest way to backup my routines.In the Namespace the routines reside:w $SYSTEM.OBJ.Export("MYRTNS*.MAC","C:\Users\Username\Desktop\MYRTNS.BCK-9-2-2016-8AM") #Caché #Terminal #Backup 4 1 1 761