Caché Agenda InterSystems Caché 2009.1.NET Gateway (2009.1) Truncate Caché Databases ( ( Studio Caché ObjectScript SQL Object Security
InterSystems (200x.1, 200x.2) 5.2 : 2006/6 2007.1 : 2007/6 2008.1 : 2008/3 2008.2 : 2008/10 2009.1 : 2009/7 2010.1 : 2009 / Caché/Ensemble Caché
Caché 2009.1.NET Gateway Ensemble Java Gateway XML Informix Zen.NET Gateway Active X Gateway Active X Gateway = Caché Active X X.NET Caché.NET.NET Gateway Server
.NET Gateway Caché Namespace Caché Session.NET CLR.NET Gateway Server.NET Gateway Worker Thread Assembly DLL Caché Class A.NET Class A Caché Class B.NET Class B Java Gateway Ensemble EnsLib.JavaGateway.Service Production
Best Approach for.net/java Gateway.NET/Java Function A Function B Function C Function D Function E Function F.NET/Java Function B Function E Caché Function B Function E CACHE.DAT SMP : ^DATABASE 12) Return unused space for a database 8K (2K ) 2009.1 Windows, Unix #1 #2 #3 #4 #5 #6 #7 #8 #9 #10 #11 #12
Caché 2009.1.NET/ Java Gateway XML XML Parser 2008.2 24 24 2009.1 20 Informix Zen Informix ISQL Stored Procedure ISQL Trigger Caché Informix ISQL ISQL Cach Caché ISQL ISQL http://intersystems.co.jp/casestudies/cache/belgian.html
Zen Report Class XML Report Content Caché XHTML PDF PDF ZEN ZEN XML Report Display SQL HTML XML PDF Agenda InterSystems 2009.1 New Feature.NET Gateway / Java Gateway (2009.1) Studio Caché ObjectScript SQL Object Security
Caché ObjectScript ObjectScript Try/Catch $REPLACE $LISTVALID $PREFETCHON/$PREFETCHOFF $DECIMAL/($DOUBLE)/$ISVALIDDOUBLE $W *** ($WExtract ) ) JIS2004/ $Sconvert/$Nconvert SQL (2007.1) JDBC SQL Unix/Linux ODBC JDBC ) T-SQL SQL-Server/Sybase Server/Sybase Caché (COS ) SQL
Caché 5.2 2007.1 N-Gram Gram ^User.TextSampleI("AddressIndex"," ",chunk)=bit ^User.TextSampleI("AddressIndex"," ",chunk)=bit %CONTAINS (5.2) select * from TextSample where Address %CONTAINS(' ') %CONTAINSTERM (2007.1) NGRAMLEN %Text NGRAMLEN 100 100
SQL (5.2) List FOR SOME %ELEMENT select * from listsample where for some %element(favoritecolors) (%value='blue') Index ColorIndex On FavoriteColors(ELEMENTS) [ Type = bitmap ]; SQL (2007.1) Array Key/Element Key/Element Index VisitInfoIndex On (VisitInfo(ELEMENTS), VisitInfo(KEYS)); select ArraySample->Name,* from arraysample_visitinfo where visitinfo = ' ' '
SQL LEFT,RIGHT FULL (2008.1) = ON Cach Caché SQL Table1 full join Table2 right join Table3 on Table3.x < Table2.y on Table1.x > Table3.x RDBMS C/C++ Light C++ (2007.1) Object-C 2007.1 2007.1 Mac Object-C / (2007.1)
Jalapeno Java IDE Eclipse * NetBeans,IntelliJ IDEA ( ( ) http://www.intersystems.co.jp/java/index.html LDAP (2007.1) LDAP Cache (2007.1) (2008.2)
SSL/TLS (2008.2) %SuperServer SSL/TLS Telnet JDBC WS Security 1.1 (2008.2) X509 Reports SECURITYIN cache.cer, cache.crl %SYS.X509Credentials http://localhost:57772/csp/docbook/docbook.ui.page.cls?key=gsop_wss
Try - Catch $CASE $HALT Halt HALT $ZSTRIP $ZCONVERT $FNUMBER, $INUMBER, $NUMBER, $NORMALIZE $BIT
#Define - #Def1Arg - #Include Defining and Including Macros with & without arguments. #If - #EndIf - #ElseIf - #Else Conditional Pre-Processor Processor conditional text command #IfDef - #IfNDef - #UnDef Conditional code dependent on Macro Definition #; - #Show - #NoShow Macro Comment control ##Continue - ##Expression - ##Function - ##SQL - ##Unique Other Macro control directives? / : InterSystems packages %occinclude, %occstatus, etc.
? : $Job $Job : >LOCK +^data(id)#"s" ( )
$ZSTRIP The $ZSTRIP $ZCONERT $ZCONVERT(string,mode,trantable,handle) Modes = (U,L,T,W,S,I,O) Translation tables = (Raw, Same, HTML, JS, URL, UTF8, XML,SJIS) $FNUMBER(inumber,format,decimal) $INUMBER(inumber,format,decimal) ($FNUMBER ) $NUMBER(num,format,min,max) ; $NORMALIZE(num,scale) ;
$BIT,$BITCOUNT, $BITFIND, $BITLOGIC $BIT $BIT $ORDER/$QUERY 3 $SORTBEGIN/$SORTEND $LIST LIST
$ORDER/$QUERY 3 $ORDER(^GlobalData(ref),1,dataRow) 500,000 : = 1.20 = 0.65-2! Set x=$sortbegin(^patienti) Do ##class(patient).insertdata() Set x=$sortend(^patienti,1) $SORTEND Caché 0
$LIST $Piece $Piece LIST Count() Count() Set obj=##class(package.class).%openid(n) Set count=obj.names.count() For I=1:1:count { set name=obj.names.getat(i) } GetNext() Set obj=##class(package.class).%openid(n) Set key= Do { set name=obj.names.getnext(.key).. } while key = ==> 20%
$SYSTEM.Event.* Caché API
... %List