PARTS AND CHAPTERS	1
TABLE OF CONTENTS	5
CHAPTER 1 OVERVIEW	11
CHAPTER 2 INTRODUCTION TO CACHÉ	14
CHAPTER 3 CACHÉ SOFTWARE INSTALLATION	18
CHAPTER 4 INTERSYSTEM'S SUPPORT	20
CHAPTER 5 INTERSYSTEMS ONLINE DOCUMENTATION	22
CHAPTER 6 READING THE DOCUMENTATION	29
CHAPTER 7 INTERSYSTEMS' WEBSITE	34
CHAPTER 8 HISTORY OF MUMPS AND CACHÉ	39
CHAPTER 9 INTRODUCTION TO COMPANIES & REVIEWS	46
CHAPTER 10 INTERSYSTEM'S PRODUCTS	50
CHAPTER 11 INTERSYSTEMS' MULTIVALUE	57
CHAPTER 12 GEORGEJAMES SOFTWARE	63
CHAPTER 13 HENRY ELLIOTT & COMPANY	68
CHAPTER 14 ENSPLUS – VISUAL STUDIO PLUG–IN	72
CHAPTER 15 GT.M	76
CHAPTER 16 WEB BASED ENHANCEMENTS	89
CHAPTER 17 ROBERT MORRIS UNIVERSITY	92
CHAPTER 18 NOSQL – NOT ONLY SQL	94
CHAPTER 19 INTERSYSTEM'S SEMAPHORES	96
CHAPTER 20 GLOBALSDB	97
CHAPTER 21 CACHÉ DEVELOPER'S RESOURCES	99
CHAPTER 22 LINKEDIN GROUPS RESOURCES	103
CHAPTER 23 INTERSYSTEMS INC. RESOURCES	106
CHAPTER 24 MISCELLANEOUS RESOURCES	124
CHAPTER 25 INTRODUCTION TO GLOBALS	126
CHAPTER 26 MULTIDIMENSIONAL GLOBALS	129
CHAPTER 27 GLOBALS – ARRAYS – VARIABLES	132
CHAPTER 28 CREATE AND ACCESS A GLOBAL WITH $ORDER	135
CHAPTER 29 CREATING A GLOBAL DATABASE	139
CHAPTER 30 TEMPORARY GLOBALS	142
CHAPTER 31 MERGE COMMAND	145
CHAPTER 32 LOCK COMMAND	147
CHAPTER 33 GLOBAL IMPORT, EXPORT, AND COPY	150
CHAPTER 34 INTRODUCTION TO CLASSES	151
CHAPTER 35 REPORTING DATA USING SQL	160
CHAPTER 36 METHODS	163
CHAPTER 37 DATA POPULATION	168
CHAPTER 38 CLASS MEMBERS	170
CHAPTER 39 INHERITANCE	180
CHAPTER 40 RELATIONSHIPS – PARENT TO CHILD	184
CHAPTER 41 INTRODUCTION TO SQL/QUERY	196
CHAPTER 42 SQL SHELL	199
CHAPTER 43 SYSTEM EXPLORER SQL	202
CHAPTER 44 EMBEDDED SQL	204
CHAPTER 45 DYNAMIC SQL	206
CHAPTER 46 BASIC CLASS QUERY	207
CHAPTER 47 CUSTOM CLASS QUERY	211
CHAPTER 48 TUNED TABLES	216
CHAPTER 49 BITMAP QUERIES	217
CHAPTER 50 SYSTEM LIBRARY OF CLASSES	219
CHAPTER 51 CHEAT SHEET INTRODUCTION	223
CHAPTER 52 CHEAT SHEET QUESTIONS	232
CHAPTER 53 CHEAT SHEET NAMESPACES	235
CHAPTER 54 CHEAT SHEET OREFS AND LISTS	237
CHAPTER 55 CHEAT SHEET DATE/TIME FUNCTIONS	242
CHAPTER 56 CHEAT SHEET CALLING FORMATS	245
CHAPTER 57 CALLS TO SYSTEM METHODS & QUERIES	246
CHAPTER 58 SYSTEM COMPILE CALLS	258
CHAPTER 59 SYSTEM SHOW CALLS	262
CHAPTER 60 SYSTEM VALIDATES CALLS	264
CHAPTER 61 SYSTEM ERRORS CALLS	267
CHAPTER 62 SYSTEM DELETES CALLS	269
CHAPTER 63 SYSTEM EXPORTS & LOADS CALLS	271
CHAPTER 64 SYSTEM ISUPTODATE & UPGRADE CALLS	283
CHAPTER 65 INTRODUCTION TO ROUTINE ELEMENTS	285
CHAPTER 66 TERMINAL EMULATION & NAMESPACES	288
CHAPTER 67 VARIABLES	292
CHAPTER 68 IF, ELSEIF, AND ELSE COMMANDS	297
CHAPTER 69 PLUS SIGN	300
CHAPTER 70 KILL COMMAND	303
CHAPTER 71 CONCATENATION	306
CHAPTER 72 HOW CACHÉ DOES MATH	308
CHAPTER 73 HALT COMMAND	310
CHAPTER 74 FOR LOOP COMMAND	312
CHAPTER 75 TRUE AND FALSE	315
CHAPTER 76 EQUAL SIGN	317
CHAPTER 77 NOT OPERATOR	319
CHAPTER 78 COMPARISON OPERATORS	321
CHAPTER 79 AND & OR OPERATORS	324
CHAPTER 80 CONTAINS, FOLLOWS, AND SORTS AFTER	327
CHAPTER 81 $LENGTH, $EXTRACT, AND $FIND FUNCTIONS	331
CHAPTER 82 $REPLACE, AND $TRANSLATE FUNCTIONS	335
CHAPTER 83 $ZCONVERT, AND $ZSTRIP FUNCTIONS	337
CHAPTER 84 $DATA AND $GET FUNCTIONS	341
CHAPTER 85 $FNUMBER AND $JUSTIFY FUNCTIONS	345
CHAPTER 86 $ASCII & $CHAR	348
CHAPTER 87 $CASE & $TEST FUNCTIONS	351
CHAPTER 88 $INCREMENT FUNCTION	354
CHAPTER 89 LIST FUNCTIONS	355
CHAPTER 90 PATTERN MATCHING	369
CHAPTER 91 CACHÉ IDE EDITORS	375
CHAPTER 92 CACHÉ STUDIO	376
CHAPTER 93 STUDIO SHORTCUTS	387
CHAPTER 94 ATELIER	388
CHAPTER 95 INTRODUCTION TO ROUTINE STRUCTURES	389
CHAPTER 96 CREATING A ROUTINE	390
CHAPTER 97 CONTROLLING PROCESS FLOW	392
CHAPTER 98 PARAMETER PASSING	395
CHAPTER 99 PROCEDURES VERSES NON–PROCEDURES	398
CHAPTER 100 SCOPING AND THE NEW COMMAND	402
CHAPTER 101 STRUCTURED CODE & THE CONTINUE COMMAND	404
CHAPTER 102 WHILE & DO WHILE CONSTRUCTS	409
CHAPTER 103 CACHÉ FILE NAME EXTENSIONS	411
CHAPTER 104 VARIABLE NUMBER OF PARAMETERS	413
CHAPTER 105 ERROR PROCESSING	415
CHAPTER 106 DOCUMENTATION	417
CHAPTER 107 TESTING & DEBUGGING	419
CHAPTER 108 HOST FILE PROCESSING	422
CHAPTER 109 ROUTINE IMPORT, EXPORT, COPY & COMPARE	425
CHAPTER 110 STUDIO DEBUGGER	427
CHAPTER 111 DATE AND TIME	433
APPENDIX A – ACCESSING SYSTEM CLASSES	439
APPENDIX B – FLAGS AND QUALIFIERS	441
APPENDIX C – EXPORT / LOAD SYSTEM CALLS	454
APPENDIX D – CONCURRENCY	458
APPENDIX E – WRITE (W) & ZWRITE (ZW)	462
APPENDIX F – PARAMETERS	464
APPENDIX G – COMMENTS	466
APPENDIX H – MUMPS OR CACHÉ?	467
APPENDIX J – $ZUTIL OR $ZU	468
APPENDIX K – LEXICON	469
APPENDIX L – ANSWERS	471
GLOSSARY	472
INDEX	488
BIOGRAPHIES	509