untitled - PDF Free Download

FORCS Co., LTD 1

OZ Query Designer User's Guide 2 FORCS Co., LTD

FORCS Co., LTD 3

OZ Query Designer User's Guide 4 FORCS Co., LTD

FORCS Co., LTD 5

OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS Co., LTD

...,.. /HTTP XML, CSV HTTP. FORCS Co., LTD 7

OZ Query Designer User's Guide XML XML-DTD XML-XSD. SAP SAP..... 8 FORCS Co., LTD

,. Manual Getting Started Getting Started Description.......... FORCS Co., LTD 9

OZ Query Designer User's Guide 10 FORCS Co., LTD

FORCS Co., LTD 11

OZ Query Designer User's Guide OS Windows NT(Service pack4 )/2000(Service pack2 )/XP/2003 Windows 95/98/ME Unicode. CPU Pentium 500MHz Main Memory 256MB (512MB ) HDD 50MB XGA (1024 x 768 ) 12 FORCS Co., LTD

. %OZQ_HOME% %OZQ_HOME% bin %OZQ_HOME% bin/res %OZQ_HOME% bin/soap Console.txt dbconfig.xml dbconfig.xsd OZQueryDesigner.exe OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll user.cif MultiLanguageList.xml QDJavaScriptConfig.xml qd.dll qd_error_msg.xml rm.dll rm_error_msg.xml server_error_msg.xml mssoap1.dll MSSOAP30.dll SOAPIS30.dll WHSC30.dll WISC10.dll WISC30.dll register_soap.bat unregister_soap.bat DB USL SOAP SOAP SOAP FORCS Co., LTD 13

OZ Query Designer User's Guide %OZQ_HOME% bin/soap/reso urces %OZQ_HOME% config %OZQ_HOME% doc %OZQ_HOME% lib SOAP assembly.properties launch.cfg LayoutConfig.xml OZOpenHistory.xml OZServerList.xml QDConfig.ini XMLDesignerConfig.xml xml.properties OZQueryAPI.chm activation.jar mail.jar crimson.jar dtdparser120.jar jcert.jar jnet.jar jsse.jar jsr173_api.jar log4j.jar ozsfw50.jar parser.jar xerces.jar dom4j-1.6.1.jar jaxen-1.1.6.jar xalan.jar xercesimpl.jar xml-apis.jar soap2_3_1.jar jazzlib.jar XML XML ) OZQueryAPI_ko_kr.chm XML DTD J2EE (HTTPS/SSL ) JRE 1.3.X HTTP XML Log XML XML XPath SOAP 14 FORCS Co., LTD

%OZA_HOME% license UniversalDriver js.jar ozlicense.xml classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_ cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar sqljdbc.jar mysql5.1.5.jar unisqljdbc10.jar unsqljdbc205.zip Java Script Oracle 8i, 9i JDBC Driver IBM DB2 JDBC Driver IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Driver Oracle 7i JDBC Driver Sybase ASE JDBC Driver MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC MSSQL 2008 JDBC Mysql JDBC UniSQL JDBC : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. FORCS Co., LTD 15

OZ Query Designer User's Guide [] [OZ XStudio 5.0] [OZ Query Designer 5.0] 'OZ Query Designer 5.0'.. 16 FORCS Co., LTD

. config launch.cfg. launch.cfg. CLASSPATH =.\lib\ozsfw50.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\lib\xmlapis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\lib\jazzlib.jar;.\lib\js.jar;.\lib\soap2_3_1.jar;.\lib\activation.jar;.\ lib\mail.jar;.\universaldriver\classes12.zip;.\universaldriver\db2java.zip;.\universal Driver\ifxjdbc.jar;.\UniversalDriver\jconn2.jar;.\UniversalDriver\msbase.jar;.\Univer saldriver\mssqlserver.jar;.\universaldriver\msutil.jar;.\universaldriver\mysql5.1.5.j ar;.\universaldriver\unisqljdbc10.jar;.\lib\jsr173_api.jar;.\lib\stax- 1.2.0.jar;.\lib\dom4j-1.6.1.jar;.\lib\jaxen-1.1.6.jar JRE_PATH =..\jre\bin\hotspot\jvm.dll JDBC CLASSPATH. JDBC lib JDBC launch.cfg. FORCS Co., LTD 17

OZ Query Designer User's Guide JDBC ODI. ODI. ( JDBC JDBC.) : Java Java launch.cfg Java. "-" Java, Java "-" launch.cfg. Java launch.cfg. CLASSPATH =.\lib\ozsfw50.jar;.\lib\log4j.jar;.\lib\xalan.jar;.\lib\xercesimpl.jar;.\li b\xml-apis.jar;.\lib\parser.jar;.\lib\xerces.jar;.\lib\dtdparser120.jar;.\lib\jcert.jar;.\lib\jnet.jar;.\lib\jsse.jar;.\lib\jazzlib.jar;.\lib\js.jar;.\lib\ soap2_3_1.jar;.\lib\activation.jar;.\lib\mail.jar;.\universaldriver\classe s12.zip;.\universaldriver\db2java.zip;.\universaldriver\ifxjdbc.jar;.\un iversaldriver\jconn2.jar;.\universaldriver\msbase.jar;.\universaldriver \mssqlserver.jar;.\universaldriver\msutil.jar;.\universaldriver\mysql5. 1.5.jar;.\UniversalDriver\unisqljdbc10.jar;.\lib\jsr173_api.jar;.\lib\stax -1.2.0.jar;.\lib\dom4j-1.6.1.jar;.\lib\jaxen-1.1.6.jar JRE_PATH = "C:\Program Files\Java\j2re1.4.2_03\bin\client\jvm.dll"- Djava.version=AAA -Djava.vendor=ABC -Dos.name=DEF -Dos.arch=GHI -Dos.version=JKL -Duser.name=MNO -Duser.home=PQR -Dsystem.IPs=STU -Dforcs=Forcs 18 FORCS Co., LTD

FORCS Co., LTD 19

OZ Query Designer User's Guide.. / / 20 FORCS Co., LTD

/ / ODI(OZ Data Info). (pull down),,,,,,,.,.,,,, ' ', ' ', ' '.. ODI(OZ Data Info),,..... _DEBUG(), _ERROR(), _INFO(). FORCS Co., LTD 21

OZ Query Designer User's Guide ODI(OZ Data Info).. // - V5.0 // ODI ODI ODI ODI. Untitled#. - OZProduct.odi - OZProduct.odi - 22 FORCS Co., LTD

[]. (Ctrl+N) ODI. (Ctrl+O) ODI... (Ctrl+S). FORCS Co., LTD 23

OZ Query Designer User's Guide.. SDM ODI SDM(Server Data Module). SDM.. [ ]. [ ] ' '. 24 FORCS Co., LTD

. ODI.. [ ] ODI.. [ ].,. [] ' ', ' ',. -,,.,. FORCS Co., LTD 25

OZ Query Designer User's Guide... : []. : 0 ~ 2147483647..... ' '.,. 26 FORCS Co., LTD

[]. [].. ODI. : 1 ~ 60. FORCS Co., LTD 27

OZ Query Designer User's Guide....,.. : "ForceLocal" " ",. ODI OpenType. Local. OZServer. ForceLocal. Force OZServer. 28 FORCS Co., LTD

Force OpenType ODI. -, SQL..... SQL FORCS Co., LTD 29

OZ Query Designer User's Guide SQL SQL. SQL. SQL, JDBC Driver. JDBC Driver. SQL ASCII REPLACE SUM MIN USER DUMP SYSDATE LAST_DAY NEXT_DAY (Space Tab), 4. 1, 2, 3, 4. -, 30 FORCS Co., LTD

,,. ODI 4. ODI.. (Ctrl+Z) FORCS Co., LTD 31

OZ Query Designer User's Guide. : Undo. (Ctrl+Y),. (Ctrl+X). [].. (Ctrl+C)., [ ].. (Ctrl+V).. (Ctrl+F). []. (Ctrl+H). []. (Ctrl+G) 32 FORCS Co., LTD

. []. (P) ODI. (Alt+0). (Alt+1). (Alt+2) FORCS Co., LTD 33

OZ Query Designer User's Guide. (Alt+3). (F5). (Ctrl+F5). [ ], ' ' 'True'. [ ] 2. 34 FORCS Co., LTD

- (Ctrl+W). - (Ctrl+M).,. 9.,.. FORCS Co., LTD 35

OZ Query Designer User's Guide []. /. PC. 36 FORCS Co., LTD

: PC [PC ] 'PC ' PC IP Address, Mac Address, HDD Serial. [] PC. FORCS Co., LTD 37

OZ Query Designer User's Guide,,,,,.,,,, ' ',,,., 38 FORCS Co., LTD

,,,.,,,.,,,,,, FORCS Co., LTD 39

OZ Query Designer User's Guide ODI(OZ Data Info),,. UI.. [] ' '. 40 FORCS Co., LTD

UI..,,,,,,. " " [] []. []. : DB2. DB,.,. FORCS Co., LTD 41

OZ Query Designer User's Guide., DB2 [] [ ].,.. 42 FORCS Co., LTD

. ". - - ". ODI. ". - - ". FORCS Co., LTD 43

OZ Query Designer User's Guide. : & [] [] <Ctrl + C>. (, ) 44 FORCS Co., LTD

,,. FORCS Co., LTD 45

OZ Query Designer User's Guide.... ODI. 46 FORCS Co., LTD

,...,.. :,, FORCS Co., LTD 47

OZ Query Designer User's Guide.,,. <Ctrl + Space> "" <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space>,,.,,...,...,. _DEBUG(), _ERROR(), _INFO(). 48 FORCS Co., LTD

. -. -. : [ ]. :. _DEBUG(" ") _ERROR(" ") _INFO(" ") DEBUG yyyy-mm-dd hh:mm:ss.sss ex) DEBUG 2008-05-20 20:17:45.031 ERROR yyyy-mm-dd hh:mm:ss.sss ex) ERROR 2008-05-20 20:17:45.471 INFO yyyy-mm-dd hh:mm:ss.sss ex) INFO 2008-05-20 20:17:45.765 FORCS Co., LTD 49

OZ Query Designer User's Guide 50 FORCS Co., LTD

FORCS Co., LTD 51

OZ Query Designer User's Guide.. Repository. Repository.,, C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0. C:\Program Files\FORCS\OZ Xstudio 5.0\Repository. [ ]. 52 FORCS Co., LTD

" [ ]".. "C:/Repository" "Working folder1" FORCS Co., LTD 53

OZ Query Designer User's Guide.. [ ]. 54 FORCS Co., LTD

' '. Button Description XML. XML... [ ]..... Option Description. FORCS Co., LTD 55

OZ Query Designer User's Guide. : (.). : [].. []. " ( ) [ ]". 56 FORCS Co., LTD

.,.,..,.. FORCS Co., LTD 57

OZ Query Designer User's Guide [] - [ ] ODI.,,,. <Ctrl + Space>.,,. 58 FORCS Co., LTD

,,, <Tab>.,,.. Icon Description FORCS Co., LTD 59

OZ Query Designer User's Guide ".". ".".,,.,,. <Ctrl + Space> "" <Ctrl + Space> "." <Ctrl + Space>,,.,,.. 60 FORCS Co., LTD

"." <Ctrl + Space> "." <Ctrl + Space> "." <Ctrl + Space>.,...,. ODI. ODI [ ]. FORCS Co., LTD 61

OZ Query Designer User's Guide [ ] " ".,. [ ], [ ].. [...],. [] 62 FORCS Co., LTD

.,,. ( ), ( ), ( ), ( ), ( ).. FORCS Co., LTD 63

OZ Query Designer User's Guide ODI [ ]. [ ]. ( ). 64 FORCS Co., LTD

.. ( ).,,, FORCS Co., LTD 65

OZ Query Designer User's Guide,. ODI.,. 66 FORCS Co., LTD

(db.properties, datasource.properties), HTTP/ XML, CSV. " ". ( ) " ". " " []. FORCS Co., LTD 67

OZ Query Designer User's Guide " " (ex. C:\) (ex. C:\),. 68 FORCS Co., LTD

..,... 1), : FORCS Co., LTD 69

OZ Query Designer User's Guide 2) /HTTP : XML XML, CSV CSV 3) XML : XML, DTD, XSD 4) SOAP : WSDL "C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0\bin", "C:\Program Files\Forcs\OZ XStudio 5.0\OZ Query Designer 5.0\db.properties". : ODI /, / ozserver.properties HOME. 70 FORCS Co., LTD

"/", "./../aa/../bb". (db.properties, datasource.properties) HOME. URL URL(ozp:///). URL. 1), : 2) /HTTP : XML XML, CSV CSV 3) XML : XML, DTD, XSD 4) SOAP : WSDL conf. FORCS Co., LTD 71

OZ Query Designer User's Guide : "ozp://" ODI,. 72 FORCS Co., LTD

FORCS Co., LTD 73

OZ Query Designer User's Guide,.. HTTP, XML...,. 74 FORCS Co., LTD

. (UDS) /HTTP XML SAP CLEAR QUEST JDBC ODBC SQL. (, CSV, XML) (EJB, Servlet, ASP, JSP, Stored Procedure) Java Interface., UDS. /. XML(DTD XML ), CSV. DTD/XSD XML. SAP R/3 SAP ABAP. IBM Rational Clear Quest DB.,,,.. FORCS Co., LTD 75

OZ Query Designer User's Guide 76 FORCS Co., LTD

FORCS Co., LTD 77

OZ Query Designer User's Guide,,,.,,. True ""( ), 0. 78 FORCS Co., LTD

False Null Null Data( ), "null" Null Data.. Concurrent '#'. '#' #OZParam.#. ' ' 'True' '#'.., 1byte RDB ^ DB. Byte.. : '0'. :,,.. : " " " ", " ". " Default ". ( ) OZServer Local.. FORCS Co., LTD 79

OZ Query Designer User's Guide 0 1 0. : "Numeric" "Decimal". DB Default 0. ( ) DB True 0. DB False 0.. ( :False) : 'True'. : " " " ". OpenType Local Default OZServer Local Default OZServer ODI.,,.. :.... :. 80 FORCS Co., LTD

OZServer Local Default OZServer Local.. :.. :.. ForceLocal ForceOZServer ForceOpenType.. :. ODI.,,. JDBC ODBC. [ ], [ ] [ ] []. (DB_).. JDBC.. ODBC/JDBC.. FORCS Co., LTD 81

OZ Query Designer User's Guide.. db.properties.. (Commit)... API ". RDB Store DataAction".. API ". RDB Store DataAction". //. : JDBC.. Oracle dblink DB2. DB JDBC. JDBC com.setautocommit(false) com.preparedstatement(sqlstr) =false OZ =true (SQL_).... 82 FORCS Co., LTD

DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row). : 0 ~ 2147483647.. 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ".. 'True'.. FORCS Co., LTD 83

OZ Query Designer User's Guide Concurrent Concurrent Row //. 'True' //,. : 'True' // ". // ". Byte.. : '0'. :,,.... : '0'. :,,... 'False'. : concurrent.. 'False'. : concurrent.. (DYNAMIC_) 84 FORCS Co., LTD

Concurrent Concurrent Row.. (Row). : 0 ~ 2147483647. ROW INDEX. '0' ROW INDEX 0. 0. : 0 ~ 2147483647.. 'True'.. Byte.. : '0'. :,,.... : '0'. :,,.. FORCS Co., LTD 85

OZ Query Designer User's Guide SQL ( ) ( ). 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ".. 'False'. : concurrent.. 'False'. : concurrent.. (SQL_)... 86 FORCS Co., LTD

. 'True', 'True'.. (JDBC preparedstatement.) : 'True' ". ". :,.. : 'True' ". ". (MULTISET)... ( ). Cursor,...... (UDS) FORCS Co., LTD 87

OZ Query Designer User's Guide (UDS: ) EJB,, Non-DB. UDS "API. ". (CLASS_) UDS. UDS.. (SET_) UDS. UDS UDS. DataAction.. ". // ". DataAction.. ". // ". DataAction.. ". // ".. (Row).. 'True'. 88 FORCS Co., LTD

Concurrent Concurrent Row. : 'True' ". ". Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. UDS. UDS.. FORCS Co., LTD 89

OZ Query Designer User's Guide,. -. (GROUP_).. (Shadow_) Consume Row Concurrent... Comsum Row. 'True'. 'True'. (Row).. 'True'. Byte.. : '0'. :,,. 90 FORCS Co., LTD

Concurrent Row.. : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent...... XML (FileXML_). FORCS Co., LTD 91

OZ Query Designer User's Guide Concurrent Concurrent Row. (Row). XML. XML.. 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. CSV (FileCSV_) 92 FORCS Co., LTD

.. (Row).. ( : Concurrent Concurrent Row LINEFEED). "LINEFEED" (\n). ODI CSV "LINEFEED".... 'True'. Byte.. : '0'. :,,... : '0'. :,,,. FORCS Co., LTD 93

OZ Query Designer User's Guide. 'False'. : concurrent.. 'False'. : concurrent.. : PGP CSV UDS.... HTTP. HTTP XML (HTTPXML_) Http.. (Row). XML. XML.. 'True'. 94 FORCS Co., LTD

Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. HTTP CSV (HTTPCSV_) Http.. (Row). FORCS Co., LTD 95

OZ Query Designer User's Guide Concurrent Concurrent Row. ( : LINEFEED). "LINEFEED" (\n). ODI CSV "LINEFEED".... 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent. 96 FORCS Co., LTD

.... SOAP. SOAP (SOAPStore_) SOAP. SOAP (SOAPSet_) Concurrent SOAP... 'True'. Byte.. : '0'. :,,. FORCS Co., LTD 97

OZ Query Designer User's Guide Concurrent Row XML.. : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent. XML.. SOAP XPath.. XPath.. XML DTD/XSD XML. XML DTD/XSD 98 FORCS Co., LTD

XML. XML DTD/XSD (DTDSet_, XSDSet_) Concurrent Concurrent Row XML... 'True'. Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent.. FORCS Co., LTD 99

OZ Query Designer User's Guide. (Full Name). XML. XML... SAP SAP R/3 RFC(Remote Function Call). SAP ().. SAP. SAP. SAP SAP. SAP SAP.. 100 FORCS Co., LTD

Concurrent Concurrent Row Byte.. : '0'. :,,... : '0'. :,,,.. 'False'. : concurrent.. 'False'. : concurrent..... FORCS Co., LTD 101

OZ Query Designer User's Guide CLEAR QUEST IBM Rational Clear Quest DB. CLEAR QUEST (CQStore_ ) CLEAR QUEST. CLEAR QUEST (CQSet_) Concurrent CLEAR QUEST. CLEAR QUEST.. (Row). : 0 ~ 2147483647.. : 'True' ". ".. 'True'. Byte.. : '0'. :,,.. 102 FORCS Co., LTD

Concurrent Row.. : '0'. :,,... 'False'. : concurrent.. 'False'. : concurrent.. CLEAR QUEST...... FORCS Co., LTD 103

OZ Query Designer User's Guide.. Include ODI LocalExplorer ODI Include. Include OZURL Include. URL. ODI OZ URL [Repository Root], [LocalExplorer]. ) ozp://// 104 FORCS Co., LTD

ODBC/JDBC.. Step 1 [] [ ]. Step 2 ' '. Step 3 [] "". FORCS Co., LTD 105

OZ Query Designer User's Guide ' ', ' SQL', ' SQL'. JDBC, ODBC, OLE DB... IP, Port. ID..... 106 FORCS Co., LTD

DB db.properties DB. DB, DB DB. db.properties. / "Appendix. ". OLE DB. SQL / SQL SQL SQL. SQL SQL SQL. SQL SQL. SQL JDBC SQL SQL. ) INSERT, UPDATE, DELETE FORCS Co., LTD 107

OZ Query Designer User's Guide SQL SQL SQL. SQL. SQL. SQL. : SQL. ODBC JDBC,. ODBC ODBC ODBC MS Access, dbase, Foxpro. ODBC. ODBC. 108 FORCS Co., LTD

" " " ". " " "odbc". " " "ODBC ". " ", "". " ". JDBC JDBC JDBC MS-SQL, Oracle, Sybase. JDBC " ".. - MS-SQL FORCS Co., LTD 109

OZ Query Designer User's Guide " " " ". " " "mssql". " IP ", " ", " " IP,,. " ", "". " ". - Oracle 110 FORCS Co., LTD

" " " ". " " "oracle". " IP ", " ", " " IP,, SID. " ", "". " ". - Sybase FORCS Co., LTD 111

OZ Query Designer User's Guide " " " ". " " "sysbase". " " Sybase JDBC jconnect 'Tds'. Tds(Tabular Data Stream) Adative Server Sybase. " IP ", " ", " " IP,,. " ", "". " ". - Informix 112 FORCS Co., LTD

" " " ". " " "informix". " IP ", " ", " ", " " IP,,,. " ", "". " ". - Uni-SQL FORCS Co., LTD 113

OZ Query Designer User's Guide " " " ". " " "unisql". " IP ", " ", " " IP,,,. " ", "". " ". - DB2 114 FORCS Co., LTD

" " " ". " " "db2". " IP ", " ", " " IP,,,. " ", "". " ". - User-Definded User-Definded JDBC JDBC Connection URL. FORCS Co., LTD 115

OZ Query Designer User's Guide " " " ". " " "user". " ", " URL" JDBC Connection URL. " ", "". " ". OLE DB OLE DB OLE DB MS-SQL, Oracle, Sybase. OLE DB " ".. - MSSQL-OLEDB 116 FORCS Co., LTD

" " " ". " " "MSSQL-OLEDB". " IP ", " ", " " IP,,. " ", "". " ". - ORACLE-OLEDB FORCS Co., LTD 117

OZ Query Designer User's Guide " " " ". " " "ORACLE-OLEDB". "SID" SID. - SYBASE-OLEDB 118 FORCS Co., LTD

" " " ". " " "SYBASE-OLEDB". " ". - DB2-OLEDB FORCS Co., LTD 119

OZ Query Designer User's Guide " " " ". " " "DB2-OLEDB". " ". - INFORMIX-OLEDB 120 FORCS Co., LTD

" " " ". " " "INFORMIX-OLEDB". " ".. Step 1 'Foodmart' [ ]. FORCS Co., LTD 121

OZ Query Designer User's Guide Step 2 " ". Step 3 []. Step 4 (). ". ". 122 FORCS Co., LTD

, SQL.. Step 1 IP,,,. ' ' [ ] ' '. FORCS Co., LTD 123

OZ Query Designer User's Guide.. (Default).. :.. Step 2 ' ', []. 'IP', 'PortNo', 'UserName', 'Password',. [] ''. 124 FORCS Co., LTD

Step 3. '' [ ]. Step 4. FORCS Co., LTD 125

OZ Query Designer User's Guide.,. (Alias) db.properties. [/conf] db.properties. MS_SQL, "ProductSales" db.properties. # setting for MS-SQL with Alias ProductSales ProductSales.vendor=mssql 126 FORCS Co., LTD

ProductSales.serverAddress=127.0.0.1 ProductSales.portNo=1433 ProductSales.dbName=marketing ProductSales.user=sa ProductSales.password= ProductSales.maxconns=20 ProductSales.initconns=5 ProductSales.timeout=5 ODI ( :DB_Aliase, :ProductSales).. FORCS Co., LTD 127

OZ Query Designer User's Guide : DB UI. 128 FORCS Co., LTD

FORCS Co., LTD 129

OZ Query Designer User's Guide. RDB... () / / [] [ ].. SQL., SQL. 130 FORCS Co., LTD

[] - [] - [] ( ).. Step 1 []. :,,. Step 2 [] - [ ] ( ) <F5>. []. FORCS Co., LTD 131

OZ Query Designer User's Guide :.. Step 3. 132 FORCS Co., LTD

[] - [] - [ ] (. ) [],,.. Step 1 [] &.., From. FORCS Co., LTD 133

OZ Query Designer User's Guide (. ) Step 2.,. ' '. DB Primary, Foreign Key JDBC (Oracle, MS-SQL ) : Primay, Foreign Key DB Primary, Foreign Key JDBC (ODBC ) : 134 FORCS Co., LTD

' ' [] [] ' ' [ ] []. &. [ ]. FORCS Co., LTD 135

OZ Query Designer User's Guide ' '. :,.. 9i. <Delete> [ ]. 136 FORCS Co., LTD

. Step 3 &. <Shift> <Ctrl>, FORCS Co., LTD 137

OZ Query Designer User's Guide <Delete>. Step 4. [] - [ ] [ ]. [ ].,,. ' '. Step 5,. Step 6. 138 FORCS Co., LTD

: MDB MS-SQL " ex) Car Sales [Car Sales]. ex) 9Sales [9Sales]. ex) Sales.Sales [Sales].Sales Step 7 [] - [ ] ( ) <F5>. []. FORCS Co., LTD 139

OZ Query Designer User's Guide Step 8. 140 FORCS Co., LTD

. Step 1 [ ]. Step 2 [Member]. Step 3 []. FORCS Co., LTD 141

OZ Query Designer User's Guide : ' ' ' ' ' '. 142 FORCS Co., LTD

Where. [ ] > >>,. :.. ' ' ' '. ' ' ' '. FORCS Co., LTD 143

OZ Query Designer User's Guide < ' '. << ' '., ' '. CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP. : " " True.. ','.. // [ ],. 144 FORCS Co., LTD

SQL. SQL SELECT UI.. From.. Select.. Where.. Where.. Group by, Select.. Order by. <Shift> <Ctrl>,... From. FORCS Co., LTD 145

OZ Query Designer User's Guide UI >, >> <, <<. ' '. ' '.. '',. ' ' ' ' ' '. ' ' ' '.,. 146 FORCS Co., LTD

UI > >>,,,.. [].. ' ' ' '. ' ' ' '. < ' '. << ' '., ' '... JDBC SQL (,,,, )..,., ','.. FORCS Co., LTD 147

OZ Query Designer User's Guide, &.,. " ". SQL Where. UI. 148 FORCS Co., LTD

AND / OR /NOT/IN/BETW EEN/ = /<>/( / ) /,... JDBC SQL (,,,, )..,.. SQL Group by. UI. ' '. FORCS Co., LTD 149

OZ Query Designer User's Guide ' ' ' ' >. <, << ' '. (Having). (AVG, COUNT, MAX, MIN, SUM).... - [ ].,. SQL Order by. 150 FORCS Co., LTD

UI. ' '. ' ' ' ' >, >>. <, << ' '.,. /,. ' '.. ' ' ' '. FORCS Co., LTD 151

OZ Query Designer User's Guide., UDS, XML, CSV,. Step 1 [ ]. Step 2 '' '' []. 152 FORCS Co., LTD

UI.. " ". : setfielddata(), setquerystring(),.. /.,. Functions : Mathematics, Sting opr., Database I/O, Date opr., Miscellaneous. Database :. Parameter :. FORCS Co., LTD 153

OZ Query Designer User's Guide Step 3 []. : ' '. 154 FORCS Co., LTD

ODI ODI. Include Step 1 [INCLUDE ODI] []. Step 2 ' ' ODI [], 'Include '. 'Include ' ODI. Step 3 ODI,, Include. Include,, [,, ]. FORCS Co., LTD 155

OZ Query Designer User's Guide Include Include [ODI ]. Include, [] Include,,. 156 FORCS Co., LTD

Include "Include ODI" ODI ODI. ODI ODI. ODI ODI,,. ODI., A.odi B.odi C.odi C.odi A.odi, B.odi. FORCS Co., LTD 157

OZ Query Designer User's Guide /. : (MemberGrade) : (Customer) Step 1. 158 FORCS Co., LTD

. SELECT customer.member_card FROM customer GROUP BY customer.member_card Step 2.. SELECT customer.customer_id, customer.fname, customer.lname, customer.phone1, customer.gender FROM customer WHERE customer.member_card = '#MemberGrade.member_card#' FORCS Co., LTD 159

OZ Query Designer User's Guide Step 3 (Customer) (MemberGrade). 160 FORCS Co., LTD

. MSSQL, SYBASE.. Step 1 " " " " [ ]. Step 2 ' '. FORCS Co., LTD 161

OZ Query Designer User's Guide Step 3.. SELECT * FROM sales SELECT * FROM customer Step 3 [] [ ] ( ) <F5> ' '. 162 FORCS Co., LTD

' '. ' ' " _#". ' ' " _#". Step 3 ' ' "SET_NAME",. FORCS Co., LTD 163

OZ Query Designer User's Guide Step 3 ' ' []... - 1 :. SELECT * FROM sales SELECT * FROM customer - 2 :. SELECT * FROM sales SELECT * FROM customer 164 FORCS Co., LTD

. JDBC Vendor, MSSQL, ORACLE. DB ' ' [].. FORCS Co., LTD 165

OZ Query Designer User's Guide..,.. []. 166 FORCS Co., LTD

. "#OZParam.#".... null. ( : False). "OZParam". : " " True. FORCS Co., LTD 167

OZ Query Designer User's Guide.,. : Cursor..,.... (/// ). Step 1 " " " " [ ]. 168 FORCS Co., LTD

Step 23 ' ' [] []. Step 4. FORCS Co., LTD 169

OZ Query Designer User's Guide Step 5 [] ' '. Step 6 ' ' "SET_NAME",. 170 FORCS Co., LTD

Step 7 ' ' []. Step 8 ' ' [] ' ' []. FORCS Co., LTD 171

OZ Query Designer User's Guide 172 FORCS Co., LTD

JDBC "PreparedStatement", " " "True".,.. " " " ". = "False", = "True"/"False" #OZParam.# '#OZParam.#'. - SELECT * FROM WHERE = #OZParam.# - SELECT * FROM WHERE = '#OZParam.#' SELECT * FROM WHERE LIKE '%#OZParam.#%' = "True", = "True" #OZParam.# '#OZParam.#',. - string sql; sql = "SELECT * FROM WHERE = #OZParam.#"; setquerystring(sql); FORCS Co., LTD 173

OZ Query Designer User's Guide - string sql; sql = "SELECT * FROM WHERE = '#OZParam.#' "; setquerystring(sql); string sql; sql = "SELECT * FROM WHERE LIKE '%#OZParam.#%' "; setquerystring(sql); = "True", = "False" #OZParam.# '#OZParam.#',. ex) '#OZParam.#' "'" + #OZParam.# + "'" - string sql; sql = "SELECT * FROM WHERE = " + #OZParam.#; setquerystring(sql); - string sql; sql = "SELECT * FROM WHERE = " + "'" + #OZParam.# + "'"; setquerystring(sql); string sql; sql = "SELECT * FROM WHERE LIKE " + " '%" + #OZParam. # + "%' "; setquerystring(sql); 174 FORCS Co., LTD

" // " DataAction(Insert, Delete, Update), (UDS). " // ", //. // [ ], [ ], [ ]. [ // ]. FORCS Co., LTD 175

OZ Query Designer User's Guide : // (Source Field, Source Value, Destination Field, Destination Value,, ),. - [ ] ' ' ' '. UI > >> Destination Field, Source Field,,. :.. ' ' ' '. ' ' ' '. < ' '. << ' '., ' '. 176 FORCS Co., LTD

CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP. : " " True.. ','.. // [ ],. ' ' (, ) ' ' & []. "ARG_SF", "ARG_SV", "ARG_DF", "ARG_DV". "ARG_S_", "ARG_D_". FORCS Co., LTD 177

OZ Query Designer User's Guide - " ". " ". [ ] [] //. // // " " " ". // -. -. - /,. ex) 4 #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#' - " " "False" "" "null". null. 178 FORCS Co., LTD

"null", "". "null" TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, BIT, NUMERIC, DECIMAL, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB, CLOB "null" CHAR, VARCHAR, LONGVARCHAR = "False", = "True"/"False" #@ARG_SF# '#@ARG_SF#'. - ( ) INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') ( ) INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') - ( ) DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' ( ) DELETE FROM WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#' FORCS Co., LTD 179

OZ Query Designer User's Guide... AND n = '#@ARG_D_n#' - ( / ) UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',... #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' ( / ) UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',... n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' = "True", = "True" #@ARG_SF# '#@ARG_SF#',. - ( ) string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') "; setquerystring(sql); 180 FORCS Co., LTD

( ) string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') "; setquerystring(sql); - ( ) string sql; sql = " DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); ( ) string sql; sql = " DELETE FROM WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); - ( / ) string sql; sql = " UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',..., #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); ( / ) string sql; sql = " UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',..., n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_ 2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); = "True", = "False" FORCS Co., LTD 181

OZ Query Designer User's Guide #@ARG_SF1# '#@ARG_SF1#'. :. ex) '#@ARG_SF1#' "'" + #@ARG_SF1# + "'" - ( ) string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#',..., '#@ARG_SVn#') "; setquerystring(sql); string sql; sql = " INSERT INTO (#@ARG_SF1#, #@ARG_SF2#,..., #@ARG_SFn#) VALUES (" + #@ARG_SV1# + ", " + "'" + #@ARG_SV2# + "'" + ",..., " + "'" + #@ARG_SVn# + "'" + ") "; setquerystring(sql); ( ) string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (#@ARG_S_1#, '#@ARG_S_2#',..., '#@ARG_S_n#') "; setquerystring(sql); string sql; sql = " INSERT INTO (1, 2,..., n) VALUES (" + #@ARG_S_1# + ", " + "'" + #@ARG_S_2# + "'" + ",..., " + "'" + #@ARG_S_n# + "'" + ") "; setquerystring(sql); - ( ) string sql; sql = " DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# 182 FORCS Co., LTD

AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); string sql; sql = " DELETE FROM WHERE #@ARG_DF1# = " + #@ARG_DV1# + " AND #@ARG_DF2# = " + "'" + #@ARG_DV2# + "'" + "... AND #@ARG_DFn# = " + "'" + #@ARG_DVn# + "'"; setquerystring(sql); ( ) string sql; sql = " DELETE FROM WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); string sql; sql = " DELETE FROM WHERE 1 = " + #@ARG_D_1 # + " AND 2 = " + "'" + #@ARG_D_2# + "'" + "... AND n = " + "'" + #@ARG_D_n# + "'"; setquerystring(sql); - ( / ) string sql; sql = " UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#',..., #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#'... AND #@ARG_DFn# = '#@ARG_DVn#' "; setquerystring(sql); string sql; sql = " UPDATE SET #@ARG_SF1# = " + #@ARG_SV1# + ", #@ARG_SF2# = " + "'" + #@ARG_SV2# + "'" + ",... #@ARG_SFn# = " + "'" + #@ARG_SVn# + "'" + " WHERE #@ARG_DF1# = " + #@ARG_DV1# + " AND #@ARG_DF2# = " + "'" + #@ARG_DV2# + "'" + "... AND #@ARG_DFn# = " + "'" + #@ARG_DVn# + "'"; FORCS Co., LTD 183

OZ Query Designer User's Guide setquerystring(sql); ( / ) string sql; sql = " UPDATE SET 1 = #@ARG_S_1#, 2 = '#@ARG_S_2#',..., n = '#@ARG_S_n#' WHERE 1 = #@ARG_D_1# AND 2 = '#@ARG_D_ 2#'... AND n = '#@ARG_D_n#' "; setquerystring(sql); string sql; sql = " UPDATE SET 1 = " + #@ARG_S_1# + ", _ 2 = " + "'" + #@ARG_S_2# +"'" + ",..., n = " + "'" + #@ARG_S_n# + "'" + " WHERE 1 = " + #@ARG_D_1# + " AND 2 = " + "'" + #@ARG_D_2 # + "'" + "... AND n = " + "'" + #@ARG_D_n# + "'"; setquerystring(sql); // - ODI //. #<>.<>#, '#<>.<>#'. //, / /. // = "False", = "False". //. = "False", = "True" "MDSet", "",,. - 184 FORCS Co., LTD

( ) INSERT INTO (#@ARG_SF1#, #@ARG_SF2#, #@ARG_SF3#,..., #@ARG_SFn#) VALUES (#@ARG_SV1#, '#@ARG_SV2#', '#MDSet.#'..., '#@ARG_SVn#') - ( ) DELETE FROM WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF2# = '#MDSet.#'... AND #@ARG_DFn# = '#@ARG_DVn#' - ( / ) UPDATE SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#MDSet.#',... #@ARG_SFn# = '#@ARG_SVn#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF2# = '#MDSet.#'... AND #@ARG_DFn# = '#@ARG_DVn#' // = "False", = "True"/"False" FORCS Co., LTD 185

OZ Query Designer User's Guide "Customer", // - INSERT INTO Customer (#@ARG_SF1#,#@ARG_SF2#,#@ARG_SF3#,#@ARG_SF4#,#@ARG_SF5#,#@ARG_SF6#,#@ARG_SF7#,#@ARG_SF8#) VALUES(#@ARG_SV1#,'#@ARG_SV2#','#@ARG_SV3#','#@ARG_SV4#','#@ARG_SV5#','# @ARG_SV6#','#@ARG_SV7#','#@ARG_SV8#') - DELETE FROM Customer WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' - UPDATE Customer SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#', #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' = "True", = "True" "Customer", // - string sql; sql = "INSERT INTO Customer (#@ARG_SF1#,#@ARG_SF2#,#@ARG_SF3#,#@ARG_SF4#,#@ARG_SF5#,#@ARG_SF6#,#@ARG_SF7#,#@ARG_SF8#) VALUES(#@ARG_SV1#,'#@ARG_SV2#','#@ARG_SV3#','#@ARG_SV4#','#@ARG_SV5#','# @ARG_SV6#','#@ARG_SV7#','#@ARG_SV8#')"; setquerystring(sql); - string sql; sql = "DELETE FROM Customer WHERE #@ARG_DF1# = #@ARG_DV1# AND 186 FORCS Co., LTD

#@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' "; setquerystring(sql); - string sql; sql = "UPDATE Customer SET #@ARG_SF1# = #@ARG_SV1#, #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#', #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = #@ARG_DV1# AND #@ARG_DF2# = '#@ARG_DV2#' AND #@ARG_DF3# = '#@ARG_DV3#' "; setquerystring(sql); FORCS Co., LTD 187

OZ Query Designer User's Guide 188 FORCS Co., LTD

FORCS Co., LTD 189

OZ Query Designer User's Guide /HTTP HTTP, CSV DTD XSD XML. CSV(Comma-Separated Value) CSV,. CSV, /HTTP. CSV /HTTP CSV. -,. -,. -. CSV ',' CSV. no,jumin_id,name,address INT,VARCHAR,VARCHAR,VARCHAR 1,7411231932347,kim,seoul 2,6305212983717,lee,pusan 3,7006031837261,park,daegu 4,7271722848281,song,daejeon 190 FORCS Co., LTD

XML(Extensible Markup Language) XML, The World Wide Web Consortium(W3C)., HTML UI XML. XML /HTTP XML. DTD XSD XML /HTTP, XML DTD XSD XML. XML /HTTP XML. - DTD XML. -. -. XML. <FIELDINFO> <FIELD NAME>="ID" TYPE="INT"/> <FIELD NAME>="NAME" TYPE="CHAR"/> <FIELD NAME>="ADDRESS" TYPE="VARCHAR"/>. </FIELDINFO>. XML, 'DATASET', 'RECORD' XML. <?xml version="1.0" encoding="ksc5601"?> <XMLSET> <DATASET> <FIELDINFO> <FIELD NAME="ID" TYPE="INT"/> <FIELD NAME="NAME" TYPE="CHAR"/> FORCS Co., LTD 191

OZ Query Designer User's Guide <FIELD NAME="ADDRESS" TYPE="VARCHAR"/> </FIELDINFO> <RECORD> <ID>1</ID> <NAME>Park Chan Ho</NAME> <ADDRESS>Texas</ADDRESS> </RECORD> <RECORD> <ID>2</ID> <NAME>Shin Ki Sung</NAME> <ADDRESS>Seoul</ADDRESS> </RECORD> <RECORD> <ID>3</ID> <NAME>Kim Byung Hyun</NAME> <ADDRESS>Arizona</ADDRESS> </RECORD> </DATASET> </XMLSET> 192 FORCS Co., LTD

. XML CSV. XML XML XML XML. XML. XML XML. XML. 'DATASET'. XML. 'RECORD'. FORCS Co., LTD 193

OZ Query Designer User's Guide. ". ". XML.. (, ) XML. [ ]. UTF-8. datasource.properties... XML <?xml version="1.0" encoding="ksc5601"?>  <XMLSET> <DATASET> <FIELDINFO> <FIELD NAME="ID" TYPE="INT"/> <FIELD NAME="NAME" TYPE="CHAR"/> <FIELD NAME="ADDRESS" TYPE="VARCHAR"/> </FIELDINFO> <RECORD> <ID>1</ID> <NAME>Park Chan Ho</NAME> <ADDRESS>USA</ADDRESS> </RECORD> </DATASET> </XMLSET> CSV 194 FORCS Co., LTD

CSV CSV CSV. CSV. CSV CSV.. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'VARCHAR'. NULL. FORCS Co., LTD 195

OZ Query Designer User's Guide.. 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. ". ". CSV.. (, ) CSV [ ]. " ". datasource.properties... CSV XML ' ' CSV XML. ". ". 196 FORCS Co., LTD

- - CSV CSV CSV CSV. ROW INDEX. '0' ROW INDEX 0. 0. : 0 ~ 2147483647. CSV. CSV CSV. FORCS Co., LTD 197

OZ Query Designer User's Guide. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'VARCHAR'. NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV.. "V. ". CSV.. (, ) CSV [ ]. " ". 198 FORCS Co., LTD

datasource.properties... - - XML XML XML XML (). ROW INDEX. '0' ROW INDEX 0. 0. : 0 ~ 2147483647. XML. XML XML. FORCS Co., LTD 199

OZ Query Designer User's Guide XML. 'DATASET'. XML. 'RECORD'.. ". ". XML.. (, ) XML. [ ]. UTF-8. datasource.properties... (XML/CSV/ ). XML Step 1 [ ] [XML ]. 200 FORCS Co., LTD

Step 2 ' ' 'XML ' [ ]. FORCS Co., LTD 201

OZ Query Designer User's Guide Step 3 [] [ ] XML. CSV Step 1 [ ] [CSV ]. Step 2 ' ' 'CSV ' [ ]. 202 FORCS Co., LTD

Step 3 [] [ ] CSV. FORCS Co., LTD 203

OZ Query Designer User's Guide Step 1 [ ] [ ]. Step 2 ' ' 'CSV ' ' -CSV '. Step 3 ' ' ' -CSV ' [ ]. 204 FORCS Co., LTD

Step 4 [] [ ]. FORCS Co., LTD 205

OZ Query Designer User's Guide JSP ASP HTTP. HTTP XML CSV. XML XML (URL). HTTP. 206 FORCS Co., LTD

XML URL. ODI.. HTTP ( : 5) :. Server URL. URL 'TRUE'. XML. 'DATASET'. XML. 'RECORD'. URL GET POST.. ". ". XML.. : HTTP XML.. : [ ]. (, ) XML. [ ]. UTF-8. FORCS Co., LTD 207

OZ Query Designer User's Guide datasource.properties... CSV CSV (URL). HTTP. 208 FORCS Co., LTD

CSV URL. ODI.. HTTP ( : 5) :. Server URL. URL 'TRUE'.. TAB, SPACE, SEMICOLON, COLON, COMMA.. LINEFEED., []. CSV. 'FALSE' 'VARCHAR'. (TRUE/FALSE) NULL... 'Appendix. "... CSV "ERR" "ERR" "ERR" CSV. URL GET POST. FORCS Co., LTD 209

OZ Query Designer User's Guide. ". ". CSV... : [ ]. (, ) CSV. [ ]. " ". datasource.properties... " ". HTTP HTTP HTTP (XML/CSV/ ). XML Step 1 XML (Sales.xml). 210 FORCS Co., LTD

Step 2 [HTTP ] [XML ]. Step 3 'HTTP ' 'XML ' [ ]. FORCS Co., LTD 211

OZ Query Designer User's Guide Step 4 [] [HTTP ] XML. 212 FORCS Co., LTD

CSV Step 1 HTTP CSV. http CSV. CSV. FORCS Co., LTD 213

OZ Query Designer User's Guide Step 2 [HTTP ] [CSV ]. Step 3 'HTTP ' 'CSV ' [ ]. 214 FORCS Co., LTD

FORCS Co., LTD 215

OZ Query Designer User's Guide Step 4 [] [HTTP ] CSV. " ". 216 FORCS Co., LTD

FORCS Co., LTD 217

OZ Query Designer User's Guide SOAP SOAP(Simple Object Access Protocol). SOAP XML, XML (Object). SOAP OZ WSDL(Web Service Description Language). 218 FORCS Co., LTD

SOAP. : SOAP SOAP Toolkit 3.0. MSSOAP30.dll, WHSC30.dll bin/soap/register_soap.bat. WSDL part type 1:1 n:1 WSDL part type 1:1. XML "DateTime" "VARCHAR".. SOAP. SOAP FORCS Co., LTD 219

OZ Query Designer User's Guide SOAP WSDL SOAP. WSDL. datasource.properties... 220 FORCS Co., LTD

. : "WSDL " WSDL. WDSL Prefix NameSpace URI Prefix. SOAP WSDL.. Operation. Operation SOAPaction. Operation,, XPath, OZParam OZParam "#OZParam. #". SOAP XML. "OZParam" "#OZParam.<operation name>_<name>#". SOAP SOAP. SOAP Step 1 [SOAP ] [SOAP ]. FORCS Co., LTD 221

OZ Query Designer User's Guide Step 2 'SOAP ' SOAP, WSDL [ ], [] 'SOAP '. 222 FORCS Co., LTD

Step 3 SOAP [ ]. [] SOAP. XPath FORCS Co., LTD 223

OZ Query Designer User's Guide SOAP... 1, 1 ( ) 0, 0, 1 1, XPath XPath. XPath [ ] XPath [ XPath ]. XPath ( ), XPath XPath XPath XPath 224 FORCS Co., LTD

XPath [ XPath ]. [ ] XPath XPath. XPath XPath [ ] XPath. [ ],, XPath ( ) ( )., XPath. [ ],, XPath ( ) ( ). FORCS Co., LTD 225

OZ Query Designer User's Guide,.. Step 4. 226 FORCS Co., LTD

FORCS Co., LTD 227

OZ Query Designer User's Guide XML XML, The World Wide Web Consortium(W3C)., HTML UI XML. XML DTD/XSD DTD/XSD XML (Schema). DTD/XSD XML,.. XML XML DTD/XSD XML XML. XML XML. XML XML XML, DTD XSD XML /HTTP DTD XSD XML. XML XML DTD XML XSD. XML XML 228 FORCS Co., LTD

XML XML DTD/XSD. XML XML. XML XML XML ( URL) XML (DTD XSD). XML. XML. DTD/XSD. FORCS Co., LTD 229

OZ Query Designer User's Guide. "V. ". XML DTD. datasource.properties... : " " XSD [] ' '. ' ' Prefix Namespace URI. Prefix Namespace URI XSD Prefix Prefix. XSD Prefix. ' ' "ns1, ns2, ns3 ". URI,. 230 FORCS Co., LTD

: XML XML DTD Root Element, Root Element [] 'Root Element '. Root Element [] XML XML. XML XML (DTD/XSD ). XSD DTD DTD. XML DTD FORCS Co., LTD 231

OZ Query Designer User's Guide Step 1 [XML] [XML ]. Step 2 'XML ' [] 'XML '. Step 3 XML [ ] 232 FORCS Co., LTD

. [] XML. XPath XML... 1, 1 ( ) 0, 0, 1 1, XPath FORCS Co., LTD 233

OZ Query Designer User's Guide XPath. XPath [ ] XPath [ XPath ]. XPath ( ), XPath XPath XPath XPath XPath [ XPath ]. [ ] XPath XPath. XPath XPath 234 FORCS Co., LTD

[ ] XPath. [ ],, XPath ( ) ( )., XPath. [ ],, XPath ( )) ( ). FORCS Co., LTD 235

OZ Query Designer User's Guide,.. Step 4. 236 FORCS Co., LTD

FORCS Co., LTD 237

OZ Query Designer User's Guide SAP SAP, SAP R/3. SAP,. SAP SAP SAP. SAP. SAP RFC(Remote Function Call: R/3 ). 238 FORCS Co., LTD

SAP. SAP SAP SAP ID () SAP...... SAP IP Address. SAP. SAP,. FORCS Co., LTD 239

OZ Query Designer User's Guide (sap.properties). : sap.properties " ". SAP SAP. Step 1 [SAP] [SAP ]. Step 2 [SAP ] 'SAP ' SAP. SAP. - 240 FORCS Co., LTD

- 'SAP ' [] 'SAP '. FORCS Co., LTD 241

OZ Query Designer User's Guide Step 3 SAP [ ] SAP 'SAP RFC Set '. RFC., []., '*', '?' [] RFC. 242 FORCS Co., LTD

[] (RFC). RFC []. Step 4. RFC [] RFC. FORCS Co., LTD 243

OZ Query Designer User's Guide [] RFC. RFC. Step 5 [] RFC. ODI. 244 FORCS Co., LTD

RFC, RFC FORCS Co., LTD 245

OZ Query Designer User's Guide 246 FORCS Co., LTD

FORCS Co., LTD 247

OZ Query Designer User's Guide CLEAR QUEST CLEAR QUEST IBM Rational Clear Quest DB. CLEAR QUEST PC IBM Rational Clear Quest. CLEAR QUEST. CLEAR QUEST. CLEAR QUEST.. CLEAR QUEST SQL. 248 FORCS Co., LTD

CLEAT QUEST IBM CLEAT QUEST DB. CLEAT QUEST IBM CLEAT QUEST DB. CLEAT QUEST CLEAR QUEST CLEAR QUEST. CLEAR QUEST... FORCS Co., LTD 249

OZ Query Designer User's Guide. CLEAR QUEST CLEAR QUEST. CLEAR QUEST. Step 1 [CLEAR QUEST] [ ]. Step 2 'CLEAR QUEST ' CLEAR QUEST [ ] CLEAR QUEST. 250 FORCS Co., LTD

Step 3. Step 4 [] CLEAR QUEST. FORCS Co., LTD 251

OZ Query Designer User's Guide Step 5 "CLEAR QUEST" [ ]. Step 6 'CLEAR QUEST ' []. Step 7. 252 FORCS Co., LTD

Step 8 (. ) CLEAR QUEST UI. Step 1 [CLEAR QUEST] [ ]. FORCS Co., LTD 253

OZ Query Designer User's Guide Step 2 'CLEAR QUEST ' CLEAR QUEST, [] CLEAR QUEST. Step 3 "CLEAR QUEST" [ ] 'CLEAR QUEST '. 254 FORCS Co., LTD

CLEAR QUEST. 'CLEAR QUEST ' [ ]. [] [ ]. FORCS Co., LTD 255

OZ Query Designer User's Guide [ ]. [ ] ( ), ( ) (, ).... [ ] ( ), ( ) (, ). 256 FORCS Co., LTD

NOT SQL. "NOT".. : "Between". "IN". ' '.. " ". SQL. SQL. FORCS Co., LTD 257

OZ Query Designer User's Guide ( ). CLEAR QUEST. 258 FORCS Co., LTD

'CLEAR QUEST ' []. [] [ ].. ( ). FORCS Co., LTD 259

OZ Query Designer User's Guide 260 FORCS Co., LTD

FORCS Co., LTD 261

OZ Query Designer User's Guide (, UDS, /HTTP, XML DTD ) 2,.. - GDS, /.... - 262 FORCS Co., LTD

.,. 10 ACCOUNTING NEW YORK CLARK MANAGER 2572.2 10 ACCOUNTING NEW YORK KING PRESIDENT 5500 10 ACCOUNTING NEW YORK MILLER CLERK 920 20 RESEARCH DALLAS JONES MANAGER 3123.75 20 RESEARCH DALLAS CHAN ANALYST 3450 30 SALES CHICAGO ALLEN SALESMAN 1600 30 SALES CHICAGO MARTIN SALESMAN 1312.5,. FORCS Co., LTD 263

OZ Query Designer User's Guide <> <> ACCOUNT CLARK, KING, MILLER RESEARCH JOHNS, CHAN SALES ALLEN, MARTIN : true : #.# == #.# true. 'true'..... A FLAT TV 19" 500,000 A FLAT TV 21" 800,000 A FLAT TV 25" 1,500,000 B 100,000... B V 180,000 C 500 C 500 - < A > () #.# == "A"... A FLAT TV 19" 500,000... A FLAT TV 21" 800,000 264 FORCS Co., LTD

A FLAT TV 25" 1,500,000 - < B > () #.# == "B"... B 100,000 B V 180,000... - < C > () #.# == "C"... C 500 C 500... :. FORCS Co., LTD 265

OZ Query Designer User's Guide UDS. [ ] [ ]., []. 266 FORCS Co., LTD

[ ] ' '. [] ' '. Consume Row.. Comsum Row. 'True'. 'True'. FORCS Co., LTD 267

OZ Query Designer User's Guide. " ".. [ ]. [].. 268 FORCS Co., LTD

[], [ ]. FORCS Co., LTD 269

OZ Query Designer User's Guide 270 FORCS Co., LTD

FORCS Co., LTD 271

OZ Query Designer User's Guide UDS(User Data Store) (, CSV, XML) (EJB, Servlet, ASP, JSP, Applet) Java Interface. UDS JDBC/ODBC XML,,, EJB. UDS UDS Java Interface 272 FORCS Co., LTD

ResultSet., UDS UDS.. UDS "API ". FORCS Co., LTD 273

OZ Query Designer User's Guide UDS,. (DLL) [ ]. UDS. UDS.. UDS. Step 1 [ (UDS)] [ ]. 274 FORCS Co., LTD

Step 2 ' ' []. Step 3 []. Step 2 []. Step 3 [] [ ]. FORCS Co., LTD 275

OZ Query Designer User's Guide Step 4 [ ]. Step 5 []. [] [] [ ] ( ) <F5>. 276 FORCS Co., LTD

[]. :...,. Step 1 [ (UDS)] [ ]. FORCS Co., LTD 277

OZ Query Designer User's Guide Step 2 ' ' " ",. Step 3 [] [ ]. [ ]. Step 4 [ ]. Step 5 [ ] ' '. 278 FORCS Co., LTD

. []. FORCS Co., LTD 279

OZ Query Designer User's Guide 280 FORCS Co., LTD

FORCS Co., LTD 281

OZ Query Designer User's Guide...,, /HTTP, XML DTD 2. ROWIDX, COLUMN, VALUE,.,.. - ROWIDX : - COLUMN : - VALUE : 1 2 ROWIDX, COLUMN, VALUE.,, Row Index. 1 282 FORCS Co., LTD

Region Sales2000 Sales2001 157000 890235 5234991 5432123 1234789 1123454 4563300 4992100 3551090 3901234 2 ROWIDX COLUMN VALUE 0 Region 0 Sales2000 257000 0 Sales2001 890235 1 Region 1 Sales2000 5234991 1 Sales2001 5432123 2 Region 2 Sales2000 1234789 2 Sales2001 1123454 3 Region 3 Sales2000 4563300 3 Sales2001 4992100 4 Region 4 Sales2000 3551090 4 Sales2002 3901234 FORCS Co., LTD 283

OZ Query Designer User's Guide. Step 1 [] [ ]. Step 2 [ ]. 284 FORCS Co., LTD

Step 3 ' ' []. Step 4. Step 5 ( ). ROWIDX, COLUMN, VALUE. FORCS Co., LTD 285

OZ Query Designer User's Guide 286 FORCS Co., LTD

FORCS Co., LTD 287

OZ Query Designer User's Guide. ODI, OZR, OZA,,,.. 288 FORCS Co., LTD

Step 1 ' ' [ ]. Step 2 ' ' ' '. Button Description XML. FORCS Co., LTD 289

OZ Query Designer User's Guide XML... [ ]..... ' '. Option IP URL Description. OZ Server. Daemon TCP, Servlet HTTP. Daemon OZ Server IP. Daemon OZ Server Port. Servlet OZ Server URL..... : " ".. 290 FORCS Co., LTD

' '. Step 3 [].. 'admin'. :,. 1) " ".,. FORCS Co., LTD 291

OZ Query Designer User's Guide. [], (,.) [], []. 2) " ". : [ ] " ",, [],[]. 292 FORCS Co., LTD

Step 4. [ ]. FORCS Co., LTD 293

OZ Query Designer User's Guide ODI. [] [] ( ). [] [] ( '. ) ' Button Description. : Disable, ' '. 294 FORCS Co., LTD

. : Disable, ' '.. : Disable. Option Description.. "ozp://", "ozpserver://". / 10, 20. :. ' ' "Max history count". 10 10 ' ' 20. conf/ozserverlist.xml. "MaxHistoryCount", "<SERVER Name=..." " MaxHistoryCount", "<LOCAL MaxHistoryCount=". FORCS Co., LTD 295

OZ Query Designer User's Guide.. [] [] ( ).. 296 FORCS Co., LTD

,.,,,,. [ ]. ' ' []. FORCS Co., LTD 297

OZ Query Designer User's Guide & ' '. []. <Ctrl> <Shift>. ' '. []. ' ' 298 FORCS Co., LTD

: odi. []. ' ' []. ' ' ' ' ( ). FORCS Co., LTD 299

OZ Query Designer User's Guide., [] ' '. []. 300 FORCS Co., LTD

[ ] ' ' ' '. []. FORCS Co., LTD 301

OZ Query Designer User's Guide,,. Admin 'None',, BuiltIn RDB. ' '.,.,.,.. []. 302 FORCS Co., LTD

' ' [Check In]. ' ' [].. : Admin 'None' Admin,.. [], ' ' []. FORCS Co., LTD 303

OZ Query Designer User's Guide. [ ], ' ' [ ]. ' '. 304 FORCS Co., LTD

. [ ]. [ ]., FORCS Co., LTD 305

OZ Query Designer User's Guide.,,,,. ". ". 306 FORCS Co., LTD

[ ]. [ ] " ",.,, []. FORCS Co., LTD 307

OZ Query Designer User's Guide,,. 308 FORCS Co., LTD

. (.) " ". None,, " " " ". "", " ",., [] []. FORCS Co., LTD 309

OZ Query Designer User's Guide 310 FORCS Co., LTD

FORCS Co., LTD 311

OZ Query Designer User's Guide,.. : " ". ASCII Big5 us-ascii, ascii, 646, iso646-us, default, ascii7 big5 Cp037 ibm037, ibm-037, cp037, 037 Cp1006 ibm1006, ibm-1006, cp1006, 1006 Cp1025 ibm1025, ibm-1025, cp1025, 1025 Cp1026 ibm1026, ibm-1026, cp1026, 1026 Cp1046 Cp1097 ibm1097, ibm-1097, cp1097, 1097 Cp1098 ibm1098, ibm-1098, cp1098, 1098 Cp1112 ibm1112, ibm-1112, cp1112, 1112 Cp1122 ibm1122, ibm-1122, cp1122, 1122 Cp1123 ibm1123, ibm-1123, cp1123, 1123 Cp1124 ibm1124, ibm-1124, cp1124, 1124 Cp1140 Cp1141 Cp1142 Cp1143 Cp1144 Cp1145 Cp1146 Cp1147 Cp1148 Cp1149 Cp1250 Cp1251 windows-1250 windows-1251 312 FORCS Co., LTD

Cp1252 Cp1253 Cp1254 Cp1255 Cp1256 Cp1257 Cp1258 windows-1252 windows-1253 windows-1254 windows-1255 windows-1256 windows-1257 windows-1258 Cp1381 ibm1381, ibm-1381, cp1381, 1381 Cp1383 ibm1383, ibm-1383, cp1383, 1383 Cp273 ibm273, ibm-273, cp273, 273 Cp277 ibm277, ibm-277, cp277, 277 Cp278 ibm278, ibm-278, cp278, 278 Cp280 ibm280, ibm-280, cp280, 280 Cp284 ibm284, ibm-284, cp284, 284 Cp285 ibm285, ibm-285, cp285, 285 Cp297 ibm297, ibm-297, cp297, 297 Cp33722 Ibm33722, ibm-33722, cp33722, 33722 Cp420 ibm420, ibm-420, cp420, 420 Cp424 ibm424, ibm-424, cp424, 424 Cp437 ibm437, ibm-437, cp437, 437 Cp500 ibm500, ibm-500, cp500, 500 Cp737 ibm737, ibm-737, cp737, 737 Cp775 ibm775, ibm-775, cp775, 775 Cp838 ibm838, ibm-838, cp838, 838 Cp850 Cp852 Cp855 ibm850, ibm-850, cp850, 850, cspc850multilingual ibm852, ibm-852, cp852, 852, cspcp852 ibm855, ibm-855, cp855, 855, cspcp855 Cp856 ibm856 ibm-856, cp856 856 Cp857 ibm857, ibm-857, cp857, 857, csibm857 Cp858 FORCS Co., LTD 313

OZ Query Designer User's Guide Cp860 Cp861 Cp862 Cp863 Cp864 Cp865 Cp866 ibm860, ibm-860, cp860, 860, csibm860 ibm861, ibm-861, cp861, cp-is, 861, csibm861 ibm862, ibm-862, cp862, cp862, 862, cspc862latinhebrew ibm863, ibm-863, cp863, 863, csibm863 ibm864, ibm-864, cp864, csibm864 ibm865, ibm-865, cp865, 865, csibm865 ibm866, ibm-866, cp866, 866, csibm866 Cp868 ibm868, ibm-868, cp868, 868 Cp869 ibm869, ibm-869, cp869, 869, cp-gr, csibm869 Cp870 ibm870, ibm-870, cp870, 870 Cp871 ibm871, ibm-871, cp871, 871 Cp874 ibm874, ibm-874, cp874, 874 Cp875 ibm875, ibm-875, cp875, 875 Cp918 ibm918, ibm-918, cp918, 918 Cp921 ibm921, ibm-921, cp921, 921 Cp922 ibm922, ibm-922, cp922, 922 Cp923 Cp930 ibm930, ibm-930, cp930, 930 Cp933 ibm933, ibm-933, cp933, 933 Cp935 ibm935, ibm-935, cp935, 935 Cp937 ibm937, ibm-937, cp937, 937 Cp939 ibm939, ibm-939, cp939, 939 Cp942 ibm942, ibm-942, cp942, 942 Cp942C cp942c Cp943 ibm943, ibm-943, cp943, 943 Cp943C cp943c Cp948 ibm948, ibm-948, cp948, 948 Cp949 ibm949, ibm-949, cp949, 949 Cp949C cp949c Cp950 ibm950, ibm-950, cp950, 950 314 FORCS Co., LTD

Cp964 ibm964, ibm-964, cp964, 964 Cp970 ibm970, ibm-970, cp970, 970 DBCS_ASCII DBCS_EBCDIC Default DoubleByte EUC EUC_CN EUC_JP EUC_KR EUC_TW gb2312, gb2312-80, gb2312-1980, euc-cn, euccn eucjis, euc-jp, eucjp, extended_unix_code_packed_format_for_japanese, cseucpkdfmtjapanese, x-euc-jp, x-eucjp ksc5601, euc-kr, euckr, ks_c_5601-1987, ksc5601-1987, ksc5601_1987, ksc_5601, 5601 cns11643, euc-tw, euctw GBK ISO2022 ISO2022CN ISO2022JP jis, iso-2022-jp, csiso2022jp, jis_encoding, csjisencoding ISO2022KR ISO8859_1 ISO8859_15_FDIS ISO8859_2 ISO8859_3 ISO8859_4 8859_1, iso_8859-1:1978, iso-ir-100, iso_8859-1, iso-8859-1, iso8859-1, latin1, l1, ibm819, ibm-819, cp819, 819, csisolatin1 8859_15, iso-8859-15, iso_8859-15, iso8859-15, ibm923, ibm-923, cp923, 923, latin0, latin9, csisolatin0, csisolatin9 8859_2, iso_8859-2:1987, iso-ir-101, iso_8859-2, iso-8859-2, iso8859-2, latin2, l2, ibm912, ibm-912, cp912, 912, csisolatin2, 8859_3, iso_8859-3:1988, iso-ir-109, iso_8859-3, iso-8859-3, iso8859-3, latin3, l3, ibm913, ibm-913, cp913, 913, csisolatin3 8859_4, iso_8859-4:1988, iso-ir-110, iso_8859-4, iso-8859-4, iso8859-4, latin4, l4, ibm914, ibm-914, cp914, 914, csisolatin4 FORCS Co., LTD 315

OZ Query Designer User's Guide ISO8859_5 ISO8859_6 ISO8859_7 ISO8859_8 ISO8859_9 ISO8859_13 8859_5, iso_8859-5:1988, iso-ir-144, iso_8859-5, iso-8859-5,iso8859-5, cyrillic, csisolatincyrillic, ibm915, ibm-915, cp915, 915, 8859_6, iso_8859-6:1987, iso-ir-127, iso_8859-6, iso-8859-6, iso8859-6, ecma-114, asmo-708, arabic, csisolatinarabic, ibm1089, ibm-1089, cp1089, 1089 8859_7, iso_8859-7:1987, iso-ir-126, iso_8859-7, iso-8859-7, iso8859-7, elot_928, ecma-118, greek, greek8, csisolatingreek, ibm813, ibm-813, cp813, 813 8859_8, iso_8859-8:1988, iso-ir-138, iso_8859-8, iso-8859-8, iso8859-8, hebrew, csisolatinhebrew, ibm916, ibm-916, cp916, 916 8859_9, iso-ir-148, iso_8859-9, iso-8859-9, iso8859-9, latin5, l5, ibm920, ibm-920, cp920, 920, csisolatin5 8859_13, iso_8859-13, iso-8859-13, iso8859-13, JIS0201 JIS0208 JIS0212 JISAutoDetect Johab KOI8_R MS874 MS932 jis auto detect ksc5601-1992, ksc5601_1992, ms1361 koi8-r, koi8, cskoi8r windows-874 shift_jis, ms_kanji, csshiftjis, windows-31j, cswindows31j, x-sjis MS932DB MS936 MS949 windows-949 MS950 MacArabic MacCentralEurope MacCroatian 316 FORCS Co., LTD

MacCyrillic MacDingbat MacGreek MacHebrew MacIceland MacRoman MacRomania MacSymbol MacThai MacTurkish MacUkraine SJIS?, pck SingleByte TIS620 UTF8 UTF16 Unicode UnicodeBig UnicodeLittle tis620.2533 utf-8, unicode-1-1-utf-8 utf-16 unicode unicode-1-1, iso-10646-ucs-2, utf-16be, x-utf-16be utf-16le, x-utf-16le FORCS Co., LTD 317