untitled

Size: px

Start display at page:

Download "untitled"

あきひさなかきむら
5 years ago
Views:

Caché Agenda InterSystems Caché 2009.1.NET Gateway (2009.

1 Caché Agenda InterSystems Caché NET Gateway (2009.1) Truncate Caché Databases ( ( Studio Caché ObjectScript SQL Object Security

2 InterSystems (200x.1, 200x.2) 5.2 : 2006/ : 2007/ : 2008/ : 2008/ : 2009/ : 2009 / Caché/Ensemble Caché

3 Caché 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

4 .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

5 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 ) 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.

6 Caché NET/ Java Gateway XML XML Parser Informix Zen Informix ISQL Stored Procedure ISQL Trigger Caché Informix ISQL ISQL Cach Caché ISQL ISQL

7 Zen Report Class XML Report Content Caché XHTML PDF PDF ZEN ZEN XML Report Display SQL HTML XML PDF Agenda InterSystems New Feature.NET Gateway / Java Gateway (2009.1) Studio Caché ObjectScript SQL Object Security

8 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

9 Caché 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

10 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 = ' ' '

11 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 Mac Object-C / (2007.1)

12 Jalapeno Java IDE Eclipse * NetBeans,IntelliJ IDEA ( ( ) LDAP (2007.1) LDAP Cache (2007.1) (2008.2)

13 SSL/TLS (2008.2) %SuperServer SSL/TLS Telnet JDBC WS Security 1.1 (2008.2) X509 Reports SECURITYIN cache.cer, cache.crl %SYS.X509Credentials

14 Try - Catch $CASE $HALT Halt HALT $ZSTRIP $ZCONVERT $FNUMBER, $INUMBER, $NUMBER, $NORMALIZE $BIT

15 #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.

16 ? : $Job $Job : >LOCK +^data(id)#"s" ( )

17 $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) ;

18 $BIT,$BITCOUNT, $BITFIND, $BITLOGIC $BIT $BIT $ORDER/$QUERY 3 $SORTBEGIN/$SORTEND $LIST LIST

19 $ORDER/$QUERY 3 $ORDER(^GlobalData(ref),1,dataRow) 500,000 : = 1.20 = ! Set x=$sortbegin(^patienti) Do ##class(patient).insertdata() Set x=$sortend(^patienti,1) $SORTEND Caché 0

20 $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%

21 $SYSTEM.Event.* Caché API

22 ... %List

C3印刷用.PDF

C3印刷用.PDF [ C-3 ] Oracle8i On Windows Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow Windows Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i